Hello Jason

From your note I'd guess you are loading and creating Delphi forms
and their attached TIB_Query's at program run time. If so you are
opening the 20 queries at load time. This may be the cause of
a "pronounced pause". Still in guess mode, have you considered
loading your forms on demand as you need them?

There are other reasons for having a "pronounced pause" at program
run time, especially in the delphi/IBO logic used to connect to your
database. For example, the way you use the TIB_CONNECTION.connect
function.

I have more than a hundred TIB_Query's in a program, and my forms are
loaded only on demand. Connection to a DB is "fast", but can be
slower when I in test connect to a DB server on a tiny and slow
laptop which needs its disk to spin up again.

Hope this helps,

Russell


--- In IBObjects@yahoogroups.com, "jaguarius2003" <jaguarius@c...>
wrote:

> Hi,
>
> I've been monitoring some of the posts on this group regarding the

use

> of IB_Cursors for speed. I am currently using TIB_Query objects for
> all my queries, and I have a lot (about 20). I am noticing a very
> pronounced pause when I load the program, and I have virtually

nothing

> in the database at this time.
>
> I tried to replace some of the TIB_Query components with IB_Cursors
> and it didn't work. I got an access violation error in the IB_Grid
> unit. I am not using grids on these particulat datasets, but I am
> using drop down lookup combo boxes - does this prevent me from using
> IB_Cursors? I do not need to scroll these datasets, but I do need to
> be able to choose a record from a drop down.
>
> Please give me some insight into where and how to use a cursor

object

> - I am worried about performance issues as the database increases in
> size and I would like to streamline things, but I am a little

unclear

> on the various uses.
>
> Thanks,
>
> Jason S. Gagnon