very slow with D2009 and remote firebird 2.1 DB
Posted: Sun 09 Oct 2011 13:23
Hi I just tested your last dbexpress driver (3.0) with D2009 and remote Firebird 2.1. I created few TSQLConnection and TSQLQuery objects with standard Firebird driver (from D2009), with Upscene and with Devart.
And execute something like this:
SQLQuery1.Open;
I := 0;
while not SQLQuery1.Eof do begin
cxMemo2.Lines.Append(IntToStr(I)
+ ' ' + SQLQuery1.FieldByName('ID').AsString
+ ' ' + SQLQuery1.FieldByName('PAVADINIMAS').AsString
);
SQLQuery1.Next;
I := I + 1;
end;
And results in seconds was:
(DevartInterBase): Open: 5.221 Last: 33.981 Total: 39.202
(InterXpress for Firebird): Open: 0.227 Last: 0.634 Total: 0.861
(InterBase): Open: 0.036 Last: 0.661 Total: 0.697
Table has only 265 rows. Very long takes not only retrieve but open operation also. Wrong my devart driver settings or what?
My test project: http://e-servisas.lt/x/9.zip
Remote FB server is on slow network ~2MBits.
p.s. As i can see on my test project output - devart driver reads records in chunks of 25 and it takes few seconds. Why takes so long?
And execute something like this:
SQLQuery1.Open;
I := 0;
while not SQLQuery1.Eof do begin
cxMemo2.Lines.Append(IntToStr(I)
+ ' ' + SQLQuery1.FieldByName('ID').AsString
+ ' ' + SQLQuery1.FieldByName('PAVADINIMAS').AsString
);
SQLQuery1.Next;
I := I + 1;
end;
And results in seconds was:
(DevartInterBase): Open: 5.221 Last: 33.981 Total: 39.202
(InterXpress for Firebird): Open: 0.227 Last: 0.634 Total: 0.861
(InterBase): Open: 0.036 Last: 0.661 Total: 0.697
Table has only 265 rows. Very long takes not only retrieve but open operation also. Wrong my devart driver settings or what?
My test project: http://e-servisas.lt/x/9.zip
Remote FB server is on slow network ~2MBits.
p.s. As i can see on my test project output - devart driver reads records in chunks of 25 and it takes few seconds. Why takes so long?