I tested on 1.5.1 firebird, and it inserts 610.000 records in less than 1 minute in 1 transaction.
Wow... this is very impresive indeed! I tested on 1.5.3, inserting about 300.000 records in a single transaction, took about 9 minutes!
I think it's about the table design, my table has 12 fields and some are indexed and constrained (foreign) fields. Those might causes the extra delay, I believe.
Can you give me the detail table design of your insert test above? And your firebird configuration too? So, I can compare it with my own test, and I'll try to find where the bottle neck is. TIA.
-Bee- has Bee.ography at: http://beeography.wordpress.com _________________________________________________________________ To unsubscribe: mail [EMAIL PROTECTED] with "unsubscribe" as the Subject archives at http://www.lazarus.freepascal.org/mailarchives
