> But i notice this delay at every query that is made... i'd know that
> at the first query IBO brings to the client some metadata information
> and that's ok... but i notice this 2-3 seconds delay at every prepare
> after the first query... with ISQL the delay is almost imperceptible,
> but with IB_SQL (and my App) every prepare operation takes a
> significat seconds, can i configure something to make the Querys
> faster with IBO??? i've trye'd UIB components and with those the
> performance is like the ISQL, so i think that could be something
> configurable with the prepare of statements.
>
> I would like to use IBO instead of UIB because the great SQL features
> that offer, but i have to improve this speed thing to can convince my
> crew of programmers that IBO is better.

The difference is ISQL is likely not preparing any statement at all. It's
probably just doing an execute immediate command and displaying the result.

If you are using a statement over and over again then it makes sense to have
the cost of a prepare to be able to repeat execution, but if you are using a
different statement each time then you don't need to prepare it at all.

You can use the ExecuteImmediate function within IBO to avoid preparing a
statement.

Perhaps you could tell me a bit more of what you are doing so I can help you
more.

Also, please put a TIB_UtilityBar in your app, set the IB_Connection
property and then pop open a SQL trace dialog to watch exactly what is
happening on the server and it will tell you what is taking so long. This
will give me more hints to help you with.

You don't need to use any other toolset because with IBO you can go as low
as you want to work as efficiently as you want. For that matter, if you
wanted to put together your own native BLR requests with IBO you can do that
too.

Jason Wharton