FrontBase Documentation

Backtrack:
  Welcome!
    5. SQL 92
      5.4. FrontBase Extensions
Updated: 20-Nov-2000
prev — next
Table of Contents

5.4.3. Table Cache Management

ALTER TABLE <table-name> SET CACHE ([<lower>], [<upper>], [<percent>]);

Sets or adjusts the cache parameters for the given table. <lower> and <upper> are given as absolute row counts. The server will keep a minimum of <lower> rows and a maximum of <upper> rows in memory. Defaults are 2,000 for <lower> and 20,000 for <upper>. The <percent> value tells the server to keep a varying number of rows in the cache, while still obeying the <upper> value. The default value for <percent> is 20.

ALTER TABLE <table-name> SET CACHE PRESERVE FALSE | TRUE;

Instructs the server to maintain (TRUE) the cache for the given table even if there are no references to the table. FALSE means that the server will discard the cache when there are no more references to the given table.

ALTER TABLE <table-name> SET CACHE PREPARE FALSE | TRUE;

Instructs the server to load (TRUE) the cache fully for the given table the first time the table is referenced. FALSE means that the cache is loaded as dictated by the actual use of the given table.
All of the above statements are transaction initiating. A COMMIT is required to make the changes visible to other users.

If you have feedback or questions on this document, please send e-mail to doc-feedback@frontbase.com. Please reference the section number and topic. Thanks!!