Uwe Oeder wrote:

>What is the page size of a DB ?
>

A firebird database is comprised of fixed sized pages. Each page has
header information that gives the page type, then specific information
for that type. A page is the unit that firebird reads and writes.

> I read it should not be smaller than the largest record size
>

Splitting a record across pages means more I/O and is generally a bad idea.

> and it if possible be the same size as disk low-level I/O performed mostly in 4096 bytes.
>

That part isn't worth worrying about anymore.

>...My largest table / record structure is of
>[120 characters , 1 small int and 6 x Integers] = 120 + 2 + 6 x 4 bytes =
>132 bytes. What should I make the page size ?
>

Either 4096 or 8192. Probably 4096 is OK.

>What should I make the Buffer size ?
>

Try 2000. The buffer size is really a factor of the number of records
in the table and how the table is used. Very large tables and smaller
tables that are searched exhaustively benefit from larger cache sizes.

Regards,


Ann