Re: [firebird-support] Issue with Database Cache Size on FB 3.0

2016-06-01 Thread fabia...@itbizolutions.com.au [firebird-support]
, June 01, 2016 3:38 PM Subject: Re: [firebird-support] Issue with Database Cache Size on FB 3.0 01.06.2016 05:30, Alexey Kovyazin wrote: > > Firebird caches only actually used pages. But it allocates all the configured memory immediately, so the memory usage (virtual/reserved

Re: [firebird-support] Issue with Database Cache Size on FB 3.0

2016-06-01 Thread fabia...@itbizolutions.com.au [firebird-support]
[firebird-support] To: firebird-support@yahoogroups.com Sent: Wednesday, June 01, 2016 12:30 PM Subject: Re: [firebird-support] Issue with Database Cache Size on FB 3.0 Hi Fabian, Firebird caches only actually used pages. The small cache means that your application touches the small

Re: [firebird-support] Issue with Database Cache Size on FB 3.0

2016-05-31 Thread Alexey Kovyazin (ak) a...@ib-aid.com [firebird-support]
Hi Fabian, Firebird caches only actually used pages. The small cache means that your application touches the small part of the database. -- Regards, Alexey Kovyazin IBSurgeon PS It is difficult and wrong to give you any direct advice without all details in hands - it can lead to worse

[firebird-support] Issue with Database Cache Size on FB 3.0

2016-05-31 Thread Fabian Ernesto Chocron fabia...@itbizolutions.com.au [firebird-support]
Hi All We are having trouble setting up the database cache size on FB 3.0 running on Windows 2008 R2 64 bits with 32 GB ram. The problem we have is we cannot get the server to allocate the ram for the cache as we intend. With FB 2.54 we had the DB cache set very high, close to 1 GB per