Board index » delphi » Strange query performance problem

Strange query performance problem

I would say that most probably the network card of that system is having
some problem, try replacing the network card.

Thanks.

Kelvin Chua
SINGAPORE

"Stacey R. Brodsky" <sbrodsk...@aol.com> wrote in message
news:3b053ec8$1_1@dnews...

Quote
> Hi All,

> Just curious if anyone has run across this before.  I have a client
running
> Win 98 and using IB6.  The same database runs fine on several other
> (similar) systems we've tried.

> It seems that all non-live data returns very quickly, but as soon as we
> return live data, the system crawls to a halt...taking up to 60 secs to
> return one record.  And yes, we are sure we are getting only one record
> returned as we've spent alot of time optimizing our code, so we are using
a
> parameterized query which is returning only one record.  (And, we've
tested
> the same query in IBConsole to be sure that it is only getting one
record.)

> Strange thing is as I stated above...if we take the same database and the
> same .exe and move them to our systems for testing, the query comes back
in
> a second.

> The systems have the same OS, same version of IB, same amount of memory,
> etc, etc, etc.

> Any ideas would be very helpful...Thanks in advance!!!

> Stacey

 

Re:Strange query performance problem


Hi All,

Just curious if anyone has run across this before.  I have a client running
Win 98 and using IB6.  The same database runs fine on several other
(similar) systems we've tried.

It seems that all non-live data returns very quickly, but as soon as we
return live data, the system crawls to a halt...taking up to 60 secs to
return one record.  And yes, we are sure we are getting only one record
returned as we've spent alot of time optimizing our code, so we are using a
parameterized query which is returning only one record.  (And, we've tested
the same query in IBConsole to be sure that it is only getting one record.)

Strange thing is as I stated above...if we take the same database and the
same .exe and move them to our systems for testing, the query comes back in
a second.

The systems have the same OS, same version of IB, same amount of memory,
etc, etc, etc.

Any ideas would be very helpful...Thanks in advance!!!

Stacey

Other Threads