Subject Re: [firebird-support] Performance with heavily updated table
Author Tim Ward
On 07/08/2013 20:21, Steve Wiser wrote:
> Do you have automatic sweeps turned on? Not sure if that matters or not.
> If not, maybe run the gfix sweep command and try your select count again.
I understand that we tried running a sweep but it didn't make any

But even if it's a sweep that's needed, we still don't understand why
that would, apparently, cause the database to re-read the same pages 100

Tim Ward