>> one of our client have ~118gb database, >> and performance is much better than yours. Since that database have >> ~300 concurrent users, they paid attention to the storage, and bought >> new raid (md3220 from dell with 8 or 12 hard drives). >> Now they have >> sweep - from 5 to 40 minutes, depending on garbage amount >> restore - ~7 hours >> backup - ~2 hours >> > > in fact on the server the backup is around 2 hours (restore 24hours but > this > because of index i m not surprise). but backup from different server > than the > FB server take twice more time :( > > hard drive: 5 RAID 0 SAS 15k on DELL server > > yes i take some risk but i have no other choice need speed ! > > >>>> yes, up to 2-4 times faster. we made tests 3 years ago and found that. >> VCS> hmm i not understand why ? >> >> when gbak runs itself, it also makes backup by itself, telling >> server to read the data. So, here is "intercommunication" between >> 2 processes - gbak and server. >> > > that explain why it's so slow on the remote computer :) > >> VCS> everyday the difference between oldest transaction and next >> transaction >> VCS> grow by more than 20 000 :( >> >> Then you need to check transaction management in your applications. >> First task is to eliminate long running transactions whenever >> possible, or use read read committed transactions for reading >> > > 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? > 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. ;-) -- With regards, Thomas Steinmaurer (^TS^) Firebird Technology Evangelist http://www.upscene.com/ http://www.firebirdsql.org/en/firebird-foundation/
