Subject | RE: [firebird-support] Occasional unexplained Slow down |
---|---|
Author | Maya Opperman |
Post date | 2011-06-08T07:18:28Z |
>>The problem is the size of the page buffers. The page buffers is setAha!! 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!
>>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...
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