Tomas,

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.

Thanks,
Alessio

----- Original Message -----
From: Tomas Krejzek
To: firebird-support@yahoogroups.com
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

Tom

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
> SELECT SUM ?
>
> Alessio
>
> [Non-text portions of this message have been removed]
>
>




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