Subject RE: [firebird-support] More on over-sweeping
Author Alan McDonald
> This is the sweeping advice I was given:
> =============
> "frequent sweeping will delay transaction start-up, as the time since
> the last sweep increases, the time for transaction startup will also
> increase.
> this can all be avoided by more frequent back/restore and less frequent
> sweeping."
> ...
> "Only if you CAN'T do timely backup/restore operations AND your
> application results in large numbers of rolled back transactions, you
> should do sweeps, but do not do them frequently."
> ...
> "You can reduce DB peformance significatnly by sweeping too regularly.
> You are much better off doing a backup/restore cycle. If you do know
> that a seeep is unnecessary then don't do it. (certainly not every
> night)
> that's my understanding - it's not a matter of belt-and-braces, it's a
> retrograde step for overall performance"
> ===============
> Comments? ;)
> John

you have a supporter for your nightly sweeps - you mentioned that you were
trying to write a scheduled program to sweep - try using AT to run this
gfix -s db_name