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).

--
Aurimas