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 Simecek | 16 Apr |