Change Page Size and Count

<< Click to Display Table of Contents >>

Navigation:  Menus > Database >

Change Page Size and Count

Previous pageReturn to chapter overviewNext page

Database Page Size and Page Count

Setting these parameters may be desired depending on the nature of the data, total size of the database and to optimize either for used space or speed of execution. Adjusting Page Size and Page Count may also solve certain errors.

Default values are 4096 / 8 respectively.

When importing from Paradox/BDE a database Page Size too low for the source table to be imported will raise an import error messages like this:

Table {SomeTable.DB} import failed. Error: Table {SomeTable} does not exist. etc. ...

When importing very large data amounts this may raise an exception error if the Page Count has been set too low.
In this case you may solve the error increasing the Page Count (and maybe the Page Size too, depending on present settings).

AbsoluteSQL Application Manual - 13 March 2023 - Copyright © 2011 - 2023 Niels Knabe