Subject RE: [firebird-support] Occasional unexplained Slow down
Author Maya Opperman
>>The problem is the size of the page buffers. The page buffers is set
>>too high, for classic. Change the page buffers, ideally for classic,
>>anywhere between 75 and 150 pages.

>Thanks, I haven't gone there yet, as customer says memory usage is lower than normal when the slow down happens (but, being 32 bit, maybe there is some internal memory limitation occurring...)

>I'll give it a try...

Aha!! We changed the page size to 150 last night, and this morning (it's the busiest at the start of the day, and their slowest period) the speed was fine!

NOW, they tell me: "And the paged memory is much less as well"

So it WAS using a lot of memory!

For lack of a more scientific method, they are now going to play around with various methods between 75 and 150, to see which is going to be optimal for them

Thanks for all the help!
Maya