Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17


Interbase client V6.0 faster then latest versions?

Posted on 2003-03-20
Medium Priority
Last Modified: 2010-04-04
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
Question by:ITugay
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
LVL 27

Expert Comment

ID: 8173480
hi igor,

firsttime listening . . .
maybe at weekend i can do some tests,
if it is already needed until then

meikl ;-)

Author Comment

ID: 8173514
hi meikl :-)
yes, would be nice. I would like to be sure that this situation not only in my town.


Author Comment

ID: 8229911
Hi meikl,

here is link to interbase TA where the same Q discussed.
As you see, this is not only my case. Seems Interbase did something very wrong.


Expert Comment

ID: 9316660
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 
Post your closing recommendations!  No comment means you don't care.

Accepted Solution

CetusMOD earned 0 total points
ID: 10661171
PAQed, with points refunded (500)

Community Support Moderator

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article explains how to create forms/units independent of other forms/units object names in a delphi project. Have you ever created a form for user input in a Delphi project and then had the need to have that same form in a other Delphi proj…
Introduction Raise your hands if you were as upset with FireMonkey as I was when I discovered that there was no TListview.  I use TListView in almost all of my applications I've written, and I was not going to compromise by resorting to TStringGrid…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …
Suggested Courses

688 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question