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 :.