Hi,

> Is there any way to speed up insert sql with FIBPlus components? I've
> got version 4.70.
> I've done a simple test: I wrote a procedure that performs 1 000 000
> inserts with TpFIBQuery into the same table with 4 columns (varchar,
> integer, float, datetime). I only changed parameters of the insert
> sql, so it should be fast but it took about 20 minutes (Athlon 900,
> 256 MB RAM, local firebird server). Is there any way to achieve close
> to Paradox speed in terms of record insert time? I don't mean the
> same table (that was just a test) but inserts into different tables
> in a sequence. Is there a way to perform many inserts in one sql? I
> need to do about 1 000 000 inserts (no selects and no updates) in a
> shortest time. Please for any answer. Thank you in advance.

Did you've indexes on that table and how unique are the inserted values?
I meant did you insert many duplicates.

Regards,
Arno Brinkman
ABVisie

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Firebird open source database (based on IB-OE) with many SQL-99 features :
http://www.firebirdsql.org
http://www.firebirdsql.info
http://www.fingerbird.de/
http://www.comunidade-firebird.org/

Support list for Interbase and Firebird users :
firebird-support@yahoogroups.com

Nederlandse firebird nieuwsgroep :
news://newsgroups.firebirdsql.info