Interbase Buffers

1. Change Interbase's page size
Use IBExpert backup and then restore. When restore, change the page size to 4096 and that's it.

2. Set Sweep interval to 0 (Use IBExpert) so that the garbage colection will not be performed automatically.

3. Don't use Foreign key.

Buffers: "Buffers
The Buffers/Cache can be set using the IBExpert menu item Database Properties, found in the Services menu, or using the command-line utility, GFIX. The amount of buffers/cache reserved can be viewed in IBExpert under Services / Database Properties. The IBExpert Performance Analysis also displays the number of data pages that are being held as cache on the server (from InterBase 6 onwards the standard is 2,048). This can be altered for the current database if wished.
If this is increased the database can load considerably more pages. For instance, it is much more efficient to load 10,000 pages, than loading 2,000 and then exchanging for new pages once the 2,000 have been loaded. The only limit to amount of cache is the physical size of the RAM (e.g. 10,000 x 4K page size). The total KB is calculated according to the current database page size. For an alteration to become effective, it is therefore necessary for all users to disconnect from the database and then reconnect. Buffers are only reserved, if they are really necessary."