🚀 go-pugleaf

It is difficult to say without seeing your code and data why TADOTable is 
slow. If you have no BLOBs and not much columns, inserting 19000 rows should 
take ~1-2 minutes. Transactions can be batched.

//------------------------------------------
Regards,
Vassiliev V. V.
http://www.managed-vcl.com - using .Net objects in Delphi for Win32 +
ADO.Net
http://www.oledbdirect.com - The fastest way to access MS SQL Server,
MS Jet (Access) and Interbase (through OLEDB)



"Dan" <Dan@do.not.spam> ???????/???????? ? ???????? ?????????: 
news:466580d1@newsgroups.borland.com...
> Vassiliev V. V. wrote:
>> For Access (but not for most other DBMS) try to use TADOTable with
>> CursorLocation = crServer.
>
> I did this and then did a quick test off inserting 100 sets of 520 
> records, and the time was exactly the same.
>
> Using transaction (open transaction, insert 5000
>> or 19000 rows, then commit transaction, then start new transation etc.) 
>> will
>> also speed up inserts (again, for other DBMS this may or may be not 
>> true).
>> For best results you may look at third-party components, but they may
>> require more code.
>
> How can you batch transactions in this manner?