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.
>
> There were no indexes and the values were random. Does it matter if
> there are duplicates?

transaction / insert (autocommit) or did you start a transaction yourself?

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com