🚀 go-pugleaf

Hello,

I'm writting several DB access routines with ADO and i started to write them
in Visual Basic, they worked fine. Now i'm 'transalting' those routines to
Builder and i'm very surprised because they work slower than in VB. What in
vb takes aprox. 500 ms in BCB takes almost 800 ms.

I'm creating TADOCommand and TADODataSet inside the code (with new, not
using controls) . The most important time cost is when the command is
executed and the recordset is created (the sentences between the '>>>>>>'
marks):

TADOCommand *ADOcommand = new TADOCommand(Application);
ADOcommand->Connection = ADOconnection;
ADOcommand->CommandType = cmdText;
ADOcommand->CommandText = txtSQL;

>>>>
TADODataSet *ADOrset = new TADODataSet(Application);
ADOrset->Recordset = ADOcommand->Execute();
>>>>

Do you know any tricks for speeding up my code?
Am i doing somethig wrong?

Thank you in advance.

Avix