🚀 go-pugleaf

You should optimize 2 things:

1. Your cycle:

TStrings has OnChange event and ADOQuery->SQL handles it. When you do
query->SQL->Add("something") TADOQuery sends this command to provider (it
gets Text, sets internal ADOCommand->CommandText etc.). So you should create
temporary TStringList, fill it with your cycle and then do
query->SQL->Assign(StringList).

2. ExecSQL itself.

You create script and send it to OLEDB provider. It is not the best way to
perform multiple insert operations. You should use TADOCommand, set command
text with parameters, prepare it and inside cycle set parameters and
execute.

Bulk inserts could be done from application. For this you should use OLEDB
interfaces. OLEDB Direct (http://www.oledbdirect.com) let you use them -
look $(OLEDBDirect)\SQL Server\1 000 000 rows demo.

----------------------------------------------------------------
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.



"booker" <diablohsh@163.net> �������/�������� � �������� ���������:
news:3ec8a054$1@newsgroups.borland.com...
> My codes:
>
> for(;node;node=node->mNext)
> {
>     cmdstr.printf("insert int tbl_some values(some1,some2....somen)");
>     adoquery->SQL->Add(cmdstr);
> }
> adoquery->ExecSQL();
>
>     the loop may execute for more than 10000 times....runing in a PIII850
> use 32 seconds(not including the ExecSQL). The speed is
inacceptable......i
> did some test and found that the slowest part is:
>
>     query->SQL->Add(cmdstr);
>
>     if i remove this line,the code only execute for 1500 ms ,i think it
must
> be the AnsiString allocation in the Add methord slow it down.
>
>     I know that Bulk Insert may greatlly inprove the performance ,but i
> can't use it. because in my case,the appserver and sqlserver are in
> different computer,so the bulk insert must be able to locate the file in
the
> appserver via UNC file path.This require the sqlserver to run in a Windows
> Domain Acount,but i don't know how to setup a Windows Domain at all.
>
>    So can any body point me out a way to boost the performance?
>
>
> Best regards,
> Bob H
>
>