> > 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]
