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


[Non-text portions of this message have been removed]