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.