I noticed a thing. In selects where return a big number of records the
researches improved very put the ones that return an only record they
worsened. The researches that return an only record are always done through
primary key PK. and the ones that return a big number of record for index.

----- Original Message -----
From: "Svein Erling Tysvaer" <svein.erling.tysvaer@...>
To: <IBObjects@yahoogroups.com>
Sent: Tuesday, January 14, 2003 6:34 AM
Subject: Re: [IBO] speed problems after BDE conversion for IBO


> Flavio,
> the reason no-one has answered you is that you have not isolated your
> problem. You need to discover what is being slow and then report your
> findings to this list with a lot more detail. Maybe it has to do with
using
> too many transactions, but from what you have told us any advice will be
> pure guesses.
>
> The only thing I can say from your general description is that if you are
> using Windows as your server, then it is a bad idea to have forced writes
> off (it is faster than forced writes on, but one power failure on the
> server and you get into trouble - at least that used to be the case).
>
> Set
>
> At 17:43 13.01.2003 -0200, you wrote:
> >We change our BDE's application am IBO and win speed in processes
> >majority. In Sales system where there is process with several selects
> >(+-15) I had speed decreased in 3X.
> >
> >I am using TIBODATABASE, TIBOQUERY, TIBOUPDATESQL
> >
> >Is there some parameter in these components that can be enabled of wrong
> >form to to be losing all this speed ?
> >
> >I am with forced writes disable and transaction this like autocommit
> >and isolation like read commited .
> >
> >The property AutoFetchAll also this false and all selects are being
> >executed by PK.
> >
> >What it can be wrong. There is some parameter that can be decreasing so
> >much the speed. I already checked the whole code and don't have no select
> >that searches all of the table records.
> >
> >Virtual Memory Developer System
> > Flavio Vieira de Macedo :.
>
>
>
>
___________________________________________________________________________
> IB Objects - direct, complete, custom connectivity to Firebird or
InterBase
> without the need for BDE, ODBC or any other layer.
>
___________________________________________________________________________
> http://www.ibobjects.com - your IBO community resource for Tech Info
papers,
> keyword-searchable FAQ, community code contributions and more !
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>