Interbase client V6.0 faster then latest versions?
Hi experts!
I know that it is not good idea to ask a question about Interbase in this TA, but seems I'll get a best support here.
Recently I noticed that report preparation process of the same reports takes very different time on differnt client's computers. Explorations shows that they use different versions of IB client. After making some tests I noticed that the best timing can be achived with gds32.dll V6.0.1.0.
I build a test application and a database.
Database has a large table with next format
TESTTABLE
ID_PRIMARYKEY integer,
STR_DATA varchar(20),
FLT_DATA numeric 12.4
TS_DATA timestamp
Nothing unusual. It has 500,000 records.
Test application just calculates time of fetching all records from that table. Something like this:
Q.SQL.Add('select * from testtable');
while not Q.EOF do
begin
Q.Next;
....
end;
I ran different servers versions on different computers. Results doesn't depends from server version but very differ from gds32.dll version on client computer.
gds32.dll version 6.0.1.0 is 4x (!!!!) times faster then
6.0.1.6
6.5.0.28
7.0.0.206
Can somebody explain me what I did wrong? I can't beleave that it is real situation. Seems I missed something?
____
Igor
PS: Can somebody repeat my tests? I will grade an additional points.
here is a collection of gds32.dll
http://web.host.kz/itugay/zip/gds32dll.zip
I know that it is not good idea to ask a question about Interbase in this TA, but seems I'll get a best support here.
Recently I noticed that report preparation process of the same reports takes very different time on differnt client's computers. Explorations shows that they use different versions of IB client. After making some tests I noticed that the best timing can be achived with gds32.dll V6.0.1.0.
I build a test application and a database.
Database has a large table with next format
TESTTABLE
ID_PRIMARYKEY integer,
STR_DATA varchar(20),
FLT_DATA numeric 12.4
TS_DATA timestamp
Nothing unusual. It has 500,000 records.
Test application just calculates time of fetching all records from that table. Something like this:
Q.SQL.Add('select * from testtable');
while not Q.EOF do
begin
Q.Next;
....
end;
I ran different servers versions on different computers. Results doesn't depends from server version but very differ from gds32.dll version on client computer.
gds32.dll version 6.0.1.0 is 4x (!!!!) times faster then
6.0.1.6
6.5.0.28
7.0.0.206
Can somebody explain me what I did wrong? I can't beleave that it is real situation. Seems I missed something?
____
Igor
PS: Can somebody repeat my tests? I will grade an additional points.
here is a collection of gds32.dll
http://web.host.kz/itugay/zip/gds32dll.zip
ASKER
hi meikl :-)
yes, would be nice. I would like to be sure that this situation not only in my town.
___
Igor
yes, would be nice. I would like to be sure that this situation not only in my town.
___
Igor
ASKER
Hi meikl,
here is link to interbase TA where the same Q discussed.
https://www.experts-exchange.com/questions/20553318/old-gds32-dll-faster-then-new-version.html
As you see, this is not only my case. Seems Interbase did something very wrong.
____
Igor
here is link to interbase TA where the same Q discussed.
https://www.experts-exchange.com/questions/20553318/old-gds32-dll-faster-then-new-version.html
As you see, this is not only my case. Seems Interbase did something very wrong.
____
Igor
ITugay:
This old question needs to be finalized -- accept an answer, split points, or get a refund. For information on your options, please click here-> http:/help/closing.jsp#1
EXPERTS:
Post your closing recommendations! No comment means you don't care.
This old question needs to be finalized -- accept an answer, split points, or get a refund. For information on your options, please click here-> http:/help/closing.jsp#1
EXPERTS:
Post your closing recommendations! No comment means you don't care.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
firsttime listening . . .
maybe at weekend i can do some tests,
if it is already needed until then
meikl ;-)