Subject | Re: [firebird-support] Re: Query never return |
---|---|
Author | Vlad Khorsun |
Post date | 2009-06-21T11:44:04Z |
> Last version of firebird (classic server), windows server 2008 with 8 GO of memory (i just bought another quad core processor andAre you use x64 version of Windows and Firebird ?
> 32 GO of memory and wait them... but i don't thing it's will resolve the problem).
> the number of client is average about 200 (so i see 200 process in task manager), in firebird conf i customize only this params :You *do use* the memory. Think about OS file cache.
> DefaultDbCachePages = 512 (instead of 74)
> so it's mean 200 * 512 * 4kb = 409600 kb = 400 Mb only ? so how can i use all the memory ??
And remember that 32-bit OS can't effectively use more than 4GB of RAM (in reality much less).
So, ensure you use x64
> i also notice that the .lck file grow to 80 MB ! is it normal ? (average 30 Mo)Too much i'd said...
Regards,
Vlad