Subject Re: [firebird-support] Best page size
Author Alessio

Thanks for the reply.

We store a graph of links between pages, so each entry (=link) is around 1K, but for
each loop (=web page analysis) we use a bulk insert which size is around 100-1000 entries
(each of if is 1K as I said before).

16k is better? I'm looking to improve performances through a sync delay between the cache
and the disk.


----- Original Message -----
From: Tomas Krejzek
Sent: Monday, August 23, 2010 11:33 AM
Subject: Re: [firebird-support] Best page size

Hi, it depends on Your data.

if You have long strings, I can recomend You to raise the size of page to maximal size 16k


Dne 19.8.2010 10:51, Alessio napsal(a):
> Hi,
> I'm working on a database with bulk inserting and few select (all are SUM). Platform is Linux x86_64,
> Firebird 2.1.x SuperServer 64 bit, file system ext3.
> Page size is 4k for now. If i move to bigger page size, what about performance with bulk insert and
> Alessio
> [Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]