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

x
?
Solved

Interbase client V6.0 faster then latest versions?

Posted on 2003-03-20
6
Medium Priority
?
224 Views
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

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
0
Comment
Question by:ITugay
[X]
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
6 Comments
 
LVL 27

Expert Comment

by:kretzschmar
ID: 8173480
hi igor,

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

meikl ;-)
0
 
LVL 9

Author Comment

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

___
Igor
0
 
LVL 9

Author Comment

by:ITugay
ID: 8229911
Hi meikl,

here is link to interbase TA where the same Q discussed.
http://www.experts-exchange.com/Databases/Interbase/Q_20553318.html
As you see, this is not only my case. Seems Interbase did something very wrong.

____
Igor
0
 

Expert Comment

by:CleanupPing
ID: 9316660
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.
0
 

Accepted Solution

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

CetusMOD
Community Support Moderator
0

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