Subject | DefaultDbCachePages |
---|---|
Author | Hugo Eyng |
Post date | 2013-08-22T20:49:55Z |
Hi Firends.
Is it a good idea setting DefaultDbCachePages to high value like "15000"
on a DB with page size 16k?
This causes de fb_inet_server.exe to consume around 240 megabytes of RAM
per connection. 50 connection 12 gigabytes.
The speed of my queries increases.
My question is about security. The environment is secure, nobreak, good
server, hourly backup, etc.
Could I have problems like data corruption?
--
Atenciosamente,
Hugo Eyng
Is it a good idea setting DefaultDbCachePages to high value like "15000"
on a DB with page size 16k?
This causes de fb_inet_server.exe to consume around 240 megabytes of RAM
per connection. 50 connection 12 gigabytes.
The speed of my queries increases.
My question is about security. The environment is secure, nobreak, good
server, hourly backup, etc.
Could I have problems like data corruption?
--
Atenciosamente,
Hugo Eyng