🚀 go-pugleaf

Using TADOCommand with parameters and Prepared = true should make inserts 
faster. BatchUpdate() uses similar technique but doing this manually you may 
do it faster.

How fast can you insert data depends not only on methods but on data (how 
much columns, do you have BLOBs or not, how much indexes and which columns 
are indexed, foreign keys etc), for example one example in OLEDB Direct 
(http://www.oledbdirect.com) inserts 200'000 rows in 16.5 seconds, first 
100'000 are inserted into table (using interfaces that TADOTable uses on low 
level), second 100'000 rows are inserted inside transaction and second 
100'000 rows are inserted in 4.5 seconds. However it is simple table without 
indexes.

//------------------------------------------
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:4669c1e0$1@newsgroups.borland.com...
> I'm still not at copy and paste speeds but was able to decrease insert 
> times by over 80%.
>
> I started with this:
>
> TADOQuery *SQLObject = (pointer of actual object);
> do
> {
>   SQLObject->SQL->Text = "Insert into [tablename] (fields...) VALUES 
> (values..)";
> }
> while (still have to import huge number of records);
> SQLObject->ExecSQL();
>
>
> To increase I changed the above to something like this:
> TADOQuery *SQLObject = (pointer of actual object);
> SQLObject->SQL->Text = "Select (field) from [tablename] where (field 
> doesn't already exist); //fast query to turn on SQL
> do
> {
>   SQLObject->InsertRecords(ARRAYOFCONST((fieldvalues...)));
> }
> while (still have to import huge number of records);
> SQLObject->BatchUpdate(arAll);
>
>
> Any other suggestions on how to increase speed?  I am presently at around 
> 200ms for 520 records, and I'd like to be well less than 100ms
>
> Dan