Board index » delphi » Why is DBExpress so slow compared to ADO

2007-08-02 12:13:40 AM
delphi186
I have 1 master query and two detail queries. I have the master query iterate through 2000 records. Using ADO this takes 6 seconds. Using DBExpress it takes 60. Why is DBExpress performing so bad?
Using SQL Server Express 2005
 

Preston writes:
information.
What components are you using with ADO and dbExpress?
I assume you are using Delphi 2007 and DBX4 since you did not say
otherwise. Is that correct?
Are you using a client side cursor with ADO?
Are you using a ClientDataSet and DataSetProvider with DBX?
How many rows does the master query return?
How are you creating the master/detail link with ADO?
How are you creating the master detail link with DBX?
--
Bill Todd (TeamB)
 

Hi Bill,
Answers are inline.
procedure TForm2.Button1Click(Sender: TObject);
var
x : integer;
begin
// ADOQuery1.Active := True;
// ADOQuery2.Active := True;
// ADOQuery3.Active := True;
SQLQuery1.Active := True;
SQLQuery2.Active := True;
// SQLQuery3.Active := True;
//SQLQuery4.Active := True;
//SQLQuery5.Active := True;
x := 0;
while not SQLQuery1.Eof do
begin
label1.Caption := intToStr(x);
inc(x);
SQLQuery1.Next;
Application.ProcessMessages;
end;
SQLQuery1.Active := False;
end;
 

I don't know what the difference is. Since you do not access any value
in the record it is possible that ADO does not fetch the record from
the server and DBX does. I'd change the code to assign the value
from some field to a variable and see what happens. I'd also try
just the master query without the details and see what happens.
--
Bill Todd (TeamB)
 

"Bill Todd" <XXXX@XXXXX.COM>writes:
I really don't know if ADO is retrieving the data. I can see that it IS executing the detail queries (using the profiler).
Is there a way to turn the client side caching off for ADO?
 

Preston writes:
--
Bill Todd (TeamB)