Subject | Re: [IBO] ISQL Faster than IBO?.. why? |
---|---|
Author | Carlos GarcĂa Trujillo |
Post date | 2006-10-20T04:53:09Z |
> IBO is doing some extra things that are designed to cache schemadata and
> such so initial connection and prepare will take longer. Continueto do
> more things and you should notice IBO will hang in there fine.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.
Thanx, hope you can give me a hand with this