MEGA Administration : Administrator Guide : Managing Repositories : Optimizing Repository Access Performance : Managing cache in RDBMS environments
   
Managing cache in RDBMS environments
In RDBMS environments, you can:
• increase RDBMS cache size (memory) (see "Increasing RDBMS cache size (memory)")
• manage RDBMS local cache:
• "RDBMS data local cache (files)"
• "Modify location of the RDBMS local cache files"
Increasing RDBMS cache size (memory)
In RDBMS storage case, with repositories including a large amount of objects, we advise you to increase the size of RDBMS caches. The larger your cache space, the fewer the network exchanges and the better your MEGA performance.
To increase cache size:
1. Connect to MEGA Administration.
*See "Connecting to MEGA Administration (Windows Front-End)", page 4.
2. Connect to the environment in which the repository is referenced.
*See "Connecting to an Environment", page 5.
3. Right-click the environment and select Options > Modify.
4. In the environment options, select Options > Installation > Advanced.
5. Increase cache sizes depending on your memory space.
RDBMS data local cache (files)
Activate RDBMS local cache option:
• adds an additional cache level for RDBMS repository objects.
This RDBMS local cache avoid multiple requests when multiple users are on the same repository view. Access for the following users is speed up.
*This option is accessible from the environment options (Options > Installation > Advanced).
• is selected by default.
You must configure your anti-virus accordingly.
*See "Configuring the Anti-Virus According to MEGA Data".
Cache files are generated in .mgc format in RDBMS Data cache folder. This folder is accessible from <ProgramData>\MEGA\MEGA HOPEX 1.0\.
*To modify this location, see "Modify location of the RDBMS local cache files".
Cyphering of RDBMS local cache option enables cyphering data included in the RDBMS local cache. Selecting this option decreases the benefit of RDBMS local cache activation. In that case, balance the benefit of Activate RDBMS local cache option activation.
*This option is accessible from the environment options (Options > Installation > Advanced).
Modify location of the RDBMS local cache files
If needed you can change RDBMS Data cache folder location.
To modify RDBMS Data cache folder location:
1. Connect to MEGA Administration.
*See "Connecting to MEGA Administration (Windows Front-End)", page 4.
2. Connect to the environment in which the repository is referenced.
*See "Connecting to an Environment", page 5.
3. Right-click the environment and select Options > Modify.
4. In the environment options, select Options > Installation > Advanced.
5. In RDBMS local cache path field, enter a location.
*For this location select a local drive that has a good access time.