troubleshooting Question

Interbase client V6.0 faster then latest versions?

Avatar of Igor UL7AAjr
Igor UL7AAjrFlag for Kazakhstan asked on
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

   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


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 is 4x (!!!!) times faster then

Can somebody explain me what I did wrong? I can't beleave that it is real situation. Seems I missed something?


PS: Can somebody repeat my tests? I will grade an additional points.

here is a collection of gds32.dll

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