Setting Advanced Table Options |
For the table you are creating, you can choose various table options that affect the performance of tables in handling data. The options follow:
Temporary / permanent tables: Temporary tables support fast data operations and can be used only by the creator. Temporary tables only exist during a single session, and DBMaker will automatically drop the temporary table when you disconnect from the database. Permanent tables on the other hand exist in the database until the user with the privilege to access and delete the table drops it. The default table type is Permanent.
Lock mode: The lock mode of a table identifies the type of lock that DBMaker places on objects when accessing them. DBMaker supports three levels of lock mode: TABLE, PAGE, and ROW. The default lock mode is the PAGE lock mode. If the lock mode is set to a higher level (such as TABLE), the level of concurrency on database accesses will be lower, but the required lock resources (shared memory) will be smaller. If the lock mode is set to a lower level (such as ROW), the level of concurrency on database access will be higher, but the required lock resources (shared memory) will be larger.
Fill Factor: The fill factor specifies the percentage of a page that can be filled before it stops allowing new records to be filled. Lowering the fill factor value facilitates the growth of existing records in the page.
No-cache: The no-cache feature is useful when accessing large tables by table scan. Table scans on large tables can cause frequent disk I/O activity. This happens during a table scan on a table with a larger number of data pages than the number of page buffers, which causes all page buffers to be exhausted. If the no-cache option is specified when creating a table, DBMaker only uses one page buffer to cache the data retrieved from a table during a table scan. This prevents the page buffers from being exhausted by only one large table scan.
Related topic:
Creating a Table
Adding a Foreign Key While Creating a Table
Completing Table Creation