| Subject | Re: [firebird-support] Re: FireBird 2.5 How can i create 1 byte (0-255) column? |
|---|---|
| Author | Mark Rotteveel |
| Post date | 2013-04-06T12:55:41Z |
On 6-4-2013 14:19, wan30032 wrote:
DefaultDbCachePagesis related to the size of the page cache in pages. So
4096 with a pagesize of 4096 bytes leads to a memory consumption of
16MB, with a page size of 16 kb it is 64MB. In case of superserver that
is for the entire db, for classic server that is *per connection*.
DefaultDbCachePages is only applied if no specific cache size is
specified in the database itself.
For inserts the page cache is not really relevant AFAIK.
Mark
--
Mark Rotteveel
>I have no idea what you are asking here.
>> Try with a larger page size (eg 16 kilobytes instead of 4 kilobytes).
> that right,i change to 16k,now 60 seconds insert 2,000,000 records!!!
>
> by the way,DefaultDbCachePages=4096 ,if change bigger like 268435456(256MB) can protected HardDisk?
DefaultDbCachePagesis related to the size of the page cache in pages. So
4096 with a pagesize of 4096 bytes leads to a memory consumption of
16MB, with a page size of 16 kb it is 64MB. In case of superserver that
is for the entire db, for classic server that is *per connection*.
DefaultDbCachePages is only applied if no specific cache size is
specified in the database itself.
For inserts the page cache is not really relevant AFAIK.
Mark
--
Mark Rotteveel