Link to home
Create AccountLog in
Avatar of Igor UL7AAjr
Igor UL7AAjrFlag for Kazakhstan

asked on

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
Avatar of kretzschmar
kretzschmar
Flag of Germany image

hi igor,

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

meikl ;-)
Avatar of Igor UL7AAjr

ASKER

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

___
Igor
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
Avatar of CleanupPing
CleanupPing

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.
ASKER CERTIFIED SOLUTION
Avatar of CetusMOD
CetusMOD
Flag of Netherlands image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account