MicroStrategy ONE

Alter Element Caching statement

Modifies the properties for the element caching in a project.

Copy 
ALTER ELEMENT 
 CACHING IN [PROJECT] "project_name"[MAXRAMUSAGEnumber_of_KB][MAXRAMUSAGECLIENTnumber_of_MB][CREATECACHESPERDBLOGIN 
 (TRUE | FALSE)] [CREATECACHESPERDBCONN (TRUE | FALSE)];

where:

  • PROJECT "project_name" is the name of the project in which the element server caching is to be altered, of type string.

  • MAXRAMUSAGE number_of_KB is

  • MAXRAMUSAGECLIENT number_of_MB is

  • CREATECACHESPERDBLOGIN is

  • CREATECACHESPERDBCONN is

This statement can only be used with three-tier or four-tier project source names.

Example

Copy 
ALTER ELEMENT 
 CACHING IN PROJECT "MicroStrategy Tutorial" MAXRAMUSAGE 10;