Subject | Re: [IBO] speed problems after BDE conversion for IBO |
---|---|
Author | Flavio Vieira de Macedo:. |
Post date | 2003-01-14T10:05:54Z |
There isn't a slowwer specific part. What I have it is an unit that flame
several functions and that for luck can call others functions and all of
them stayed a little slowwer. In the final lost 3X the speed.
If you want you authority this code piece to see what can be happening.
several functions and that for luck can call others functions and all of
them stayed a little slowwer. In the final lost 3X the speed.
If you want you authority this code piece to see what can be happening.
----- 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/
>