On 08/09/12 06:31, Martin Schreiber wrote:
It depends on the reaction time of the network because AFAIK there is a roundtrip for every inserted record...
I didn't commit the transaction after every record. I first tried in a batch of 10000 records per transaction. Later I even bumped that up more, and still no problems.
Anyway, that code isn't used too much in our product - it is only used for data conversion from our old system to our new system. So normally only needed once per setup.
Regards, - Graeme - _______________________________________________ fpc-pascal maillist - [email protected] http://lists.freepascal.org/mailman/listinfo/fpc-pascal
