Subject | Re: [firebird-support] DefaultDbCachePages |
---|---|
Author | Hugo Eyng |
Post date | 2013-08-22T21:00:31Z |
Hi.
I am using SuperServer.
Em 22/08/2013 17:56, Leyne, Sean escreveu:
Atenciosamente,
Hugo Eyng
[Non-text portions of this message have been removed]
I am using SuperServer.
Em 22/08/2013 17:56, Leyne, Sean escreveu:
>--
> Hugo,
>
> > Is it a good idea setting DefaultDbCachePages to high value like "15000"
> > on a DB with page size 16k?
>
> No.
>
> 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, good
> > server, hourly backup, etc.
> >
> > Could I have problems like data corruption?
>
> In all other respects Classic engine functions the same as SuperServer
>
>
Atenciosamente,
Hugo Eyng
[Non-text portions of this message have been removed]