It is possible to increase the performance of the database by increasing the cache memory available to it

Date:Archived
Product/Release:Visual LANSA
Abstract:It is possible to increase the performance of the database by increasing the cache memory available to it
Submitted By:LANSA Technical Support
External(s):SQL/Anywhere performance tuning

Currently, during the installation of SQL/Anywhere, the cache memory available to set to 2 megabytes. To speed up SQL/Anywhere performance (especially during full function check and compiles) you can increase the cache memory available to it by the following commands;

set envar=-c 4096 <dbname> e.g e:\lansa\lx_lansa.db dbeng50 @envar.

This will increase the cache memory size to 4 megabytes.