Hello,

> I have a performance problem with TIBOQuery.
> When I mesured times, I saw, that the first Open() is almost always
> faster than subsequent Close() & Open() or Refresh().
> Why can that be?
> How can this be fixed?
>
> In most cases the difference is very small and are not significant in
> real situation, where are several users working at once, but one
> particular case has a *very* big difference: the first Open() is done in
> about 30 miliseconds, but each next Open() or Refresh() is about 500
> miliseconds - that exact problem I'm trying to solve. I don't see any
> big diffrence between that select and others in the application. When
> running that select in IBExpert I always get the same execution time
> (less than 30 miliseconds).

Rule number one in a client/server application is integrating some kind
of monitoring/profiling facility to see what's going on.

Drop a TIB_MonitorDialog component onto your form/data module and see
what's going over the wire. Possibly it's all about how many records are
being fetched from the server.


--
Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and
NexusDB V2
Upscene Productions
http://www.upscene.com