--- In ib-support@y..., Nando Dessena <nandod@d...> wrote:

> 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

He is using TIBDataSet. The refresh issue is interesting.