Subject | RE: [firebird-support] DefaultDbCachePages |
---|---|
Author | Leyne, Sean |
Post date | 2013-08-22T20:56:51Z |
Hugo,
With Classic you want to actually use a cache of 150-300 pages to reduce lock manager contention.
Remember to run queries a couple of time in order to exclude the cost/time of cache load when comparing results
> Is it a good idea setting DefaultDbCachePages to high value like "15000"No.
> on a DB with page size 16k?
With Classic you want to actually use a cache of 150-300 pages to reduce lock manager contention.
> The speed of my queries increases.This is due to the huge page cache setting.
Remember to run queries a couple of time in order to exclude the cost/time of cache load when comparing results
> My question is about security. The environment is secure, nobreak, goodIn all other respects Classic engine functions the same as SuperServer
> server, hourly backup, etc.
>
> Could I have problems like data corruption?