Page 1 of 1

Cache on Server

Posted: Mon Aug 28, 2017 3:05 pm
by dominique
Hi everyone

Does anyone know how to cache data on a web server/application server? We like to use a cache for mostly static data to get the "best" performance.

Thank you in advance
dominique

Re: Cache on Server

Posted: Mon Aug 28, 2017 3:45 pm
by Stewart Marshall
Hi Dominique

When running a VL WebPage, the best technique is to store static data in memory on the client. All you need do is look up an entry in a collection or working list, depending on your preference. This avoids unnecessary calls to the webserver, making your application even more efficient.

Depending on the volume of static data, it may be worth simply downloading it all when the application starts. If you have the typical code table files with a few hundred records, you may find that it's really only a few Kb of data. Alternatively, you can load on demand the first time you try to access the table.

Regards