🚀 go-pugleaf

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