Setting the Database Page Fill Ratio

From InterBase

Go Up to Database Properties


Data pages store multiple versions of data records, as applications update data. When a database is restored, the gbak utility fills pages with data only up to 80 percent of the capacity of each page, to leave space for new record version deltas to be stored, hopefully on the same page with the original record. But in a database that is used mostly for reading data rather than updating it, applications never benefit from this 80 percent fill ratio. In this case, it makes sense to restore data using the full capacity of each page. By storing 25 percent more data on each page, it reduces the amount of record fragmentation and increases the amount of data returned in each page read. You can specify the option to use all the space of every page for storing data during a database restore using the command:

gbak -c -use_all_space backup_file.ibk database_file.ib

Advance To: