|Subject||Re: [FB 2.1] Firebird engine seems to slow down on high load without utilizing hardware|
1) We have sweep set to 0. We do monitor the transaction gab and if needed, we interact. Any kind of automatic sweep under high load will kill the server :)
2) We do run gbak daily. We do not use nbackup - we would like to and tried it but it's corrupting the db.
3) We do use read-only readcommited transactions with record versioning as much as we can.
Otherwise, same Settings but not read-only.