troubleshooting Question

Interbase client V6.0 faster then latest versions?

Avatar of Igor UL7AAjr
Igor UL7AAjrFlag for Kazakhstan asked on
Delphi
5 Comments1 Solution248 ViewsLast Modified:
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
ASKER CERTIFIED SOLUTION
CetusMOD

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 5 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 5 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros