List:MaxDB« Previous MessageNext Message »
From:Tomas Simecek Date:April 16 2003 4:35pm
Subject:Perfomance ?
View as plain text  
Hi,

strange thing with SAP DB. I made little testing program. It connects to 
the DB, then drop/create table then insert some random values into the 
table of 6 integers and 5 strings with no primary key or index.

The problem is, that the process when I make drop/create and then insert 
values is 10-20x slower then if I skip part drop/create, even if in the 
table is more then 10.000 records before any insert starts.

This is normal ? I dont think so, the same program using MySQL has 
stable speed with or without drop/create step.

I am using Delphi 7, dbExpress, latest version of SAP DB.

Regards,
    Tom


Thread
Perfomance ?Tomas Simecek16 Apr