| Subject | Slow UPDATE from Delphi |
|---|---|
| Author | rks84093 |
| Post date | 2002-02-15T17:55:38Z |
My developer tells me he is using Delphi 6 with IBX and Dataset
component, and inserting a new record into a 125,000 record table (38
fields, 3 basic indexes) is taking 7 seconds. Turning indexes
INACTIVE doesn't make much difference.
When I access the database using IB Console and write the SQL UPDATE,
the same insert with COMMIT takes less than .25 seconds.
What am I missing here? Why the difference?
Kevin
component, and inserting a new record into a 125,000 record table (38
fields, 3 basic indexes) is taking 7 seconds. Turning indexes
INACTIVE doesn't make much difference.
When I access the database using IB Console and write the SQL UPDATE,
the same insert with COMMIT takes less than .25 seconds.
What am I missing here? Why the difference?
Kevin