> > to select or update the data we do only like this :
> >
> > procedure doSQL
> > begin
> > StartTransaction
> > Try
> > select or update data
> > committransaction
> > except
> > rollbacktransaction
> > end;
> > end;
>
> I'm curious what access components you use? Perhaps ZEOS?
>

no, direct api call :) ... but i get inspired from the UIB code

> > for now the only explanation i see is that we do very lot of transaction
> > (average 225 / Secondes is it lot ?)
> > on the server and this why 20000 sean to be too little ... with around
> > 19 millions transactions by days
> > i thing i must use much more than 20000 (1 million?)
>
> I still think you won't resolve the problem with a larger sweep
> interval. ;-)
>

ok, i just make a confusion, it's not the difference between the next
transaction and the OIT that must be done but between the
OST (oldest snapshot) and the OIT that must be done ! (and many
book write this mistake, thanks that i read an article from vlad about
it)

in my case it's always close to 1 so no sweep really need !



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