Subject Re: [firebird-support] Restart fixes performance issues
Author Martijn Tonies
> at our biggest client, the database tends to get slower with the time
> (half a day), and issuing a restart to the Firebird server fixes it.
> For example, one routine takes 2 minutes before the restart. After the
> restart, it takes only 10 seconds. No sweep is issued during the process.
> Also, issuing a sweep with the database up doesn't change
> OIT/OAT/Snapshot values.
> Any ideas what may be causing it?
> Database header page information:
> Flags 0
> Checksum 12345
> Generation 494291
> Page size 4096
> ODS version 10.1
> Oldest transaction 339206
> Oldest active 339207
> Oldest snapshot 336985
> Next transaction 494283

This does.

You have a runaway transaction somewhere. The difference between
"oldest active" and "next" is too large.

Fix it.

With regards,

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Upscene Productions
Database development questions? Check the forum!