5. SQL 92
5.4. FrontBase Extensions
Table of Contents
ALTER TABLE <table-name> SET CACHE ([<lower>], [<upper>], [<percent>]);
Sets or adjusts the cache parameters for the given table.
<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
<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
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.
FALSEmeans 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.
FALSEmeans that the cache is loaded as dictated by the actual use of the given table.
All of the above statements are transaction initiating. A
COMMITis required to make the changes visible to other users.
If you have feedback or questions on this document, please send e-mail to firstname.lastname@example.org. Please reference the section number and topic. Thanks!!
©2000 FrontBase, Inc. All rights reserved.