🚀 go-pugleaf

To make inserts faster, use server-side cursor and call
DisableControls()/EnableControls() even if no controls are attached. 17 000
rows is not much (unless you have BLOBs or foreign keys or triggers). The
fastest way to insert rows into MS SQL Server database is OLEDB Direct
(http://www.oledbdirect.com) - look ($OLEDB Direct)\Examples\SQL
Server\1000000 rows sample - it inserts 1 mln rows.

----------------------------------------------------------------
Regards,
Viatcheslav V. Vassiliev
http://www.oledbdirect.com
The fastest way to access MS SQL Server, MS Jet (MS Access)
and Interbase (through OLEDB) databases.

"In�s Fern�ndez" <ifernandezmed@terra.es> �������/�������� � ��������
���������: news:3e9a6882@newsgroups.borland.com...
> Hello!
> I am using a TADOCommand component to insert records in a Table from an
SQL
> Server Database.
> Each time I have to call that command about 17000 times to insert as many
> records.
> The process takes quite a long time, so I am looking for a way to make
that
> time shorter.
> I have found that using a TADOConnection to connect to de Database it
takes
> twice the time it takes using the ConnectionString directly in the
> TADOCommand component. Why?
> Is there a way to solve this? I want to use the TADOConnection component
> because I have many other ADO components that must connect to the same
> Database.
>
> Thanks in advance:
>
> In�s Fern�ndez
>
>