Kevin,

> 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?

the dataset must be open before you can perform the Insert and Post (BTW
is it a TIBTable, TIBQuery, TIBDataSet?), I guess that the initial
fetching or, more probably, the refresh after the actual insert is
biting you.
Either you bring the number of retrieved records down by means of a
suitable where clause, or you insert new record using a different query
component with an "insert into" SQL statement.
Ciao
--
____
_/\/ando