|Subject||Re: [firebird-support] large system slows over time|
On May 5, 2015, at 2:38 PM, Jesus Garcia jegaza@... [firebird-support] <firstname.lastname@example.org> wrote:
Hello, I think the problem is the database fragmentation along the time. I have databases in production 24x7x365. If I backup and restore on a test environment, the time is good.
In your case, yes data distribution in the database is a likely culprit, though disk I/O speed is not always best with contiguous data. However Nick says his database speed improved just by restarting the server or rebooting the system. That's unlikely to defragment the database.