Hi VigneZ,

> In ibconnection there is a page size property. Is there any
> arithmetics in setting that property?

If you connect to an existing database, it's no use setting it: this
property will reflect the real page size of the database after
connecting (just like SQL Dialect).

If you use the IB_Connection to create a new database, you can set it
(before creation) to determine the page size.

Page size can be 1024, 2048, 4096, 8192, 16384 (last one is max for FB
1.0 I think).

Normally you should take at least 8192. Bigger may be better,
especially if a single row might not fit on a page otherwise.

If you want to change the page size of an existing db, you have to
back it up and then restore specifying the new page size. This is
also the way to test the speed and filesize effects of different
page sizes.


Greetings,
Paul Vinkenoog