> On May 5, 2015, at 2:38 PM, Jesus Garcia jeg...@gmail.com [firebird-support] > <firebird-support@yahoogroups.com> 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. Good luck, Ann
