Subject | Re: [firebird-support] Re: Rename database command |
---|---|
Author | Alexandre Benson Smith |
Post date | 2013-06-05T16:47:15Z |
Em 5/6/2013 13:33, Leyne, Sean escreveu:
I read that, but the point I was talking about is related to this phrase:
"It became clear to us that to keep the system going we have to run a
backup/restore every weekend because of slow downs when transaction
counts got too high"
But I don't think that the transaction count getting too high would lead
to a server slowdown.
see you !
> Alexandre,Hi Sean !
>
> While I completely agree with your points. I read the OP as meaning
> that they are running out of transactions ID (given the current 2GB
> limit) -- they have an 800GB database, so a large number of
> transactions would/could be expected, so transactions ID could get
> exhausted. In that case, a backup/restore would be required, but a
> weekly cycle is excessive (it means that the db is handling more than
> 3550 transactions per second!!! Very unlikely). Sean
I read that, but the point I was talking about is related to this phrase:
"It became clear to us that to keep the system going we have to run a
backup/restore every weekend because of slow downs when transaction
counts got too high"
But I don't think that the transaction count getting too high would lead
to a server slowdown.
see you !