--- In firebird-support@yahoogroups.com, Mark Rotteveel <mark@...> wrote:

>
> On 6-4-2013 14:19, wan30032 wrote:
> >
> >> 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?
>
> I have no idea what you are asking here.
>
> 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
>

thanks, i know a bit .
However, FirdBird is very good in my case¡£

thanks again¡£