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.