Chief SAS App Officer
Backend Optimisation Options in SAS
Separation of front and backend is non-negotiable!
Send only the data you need to send!
Avoid browser-freeze! When showing tables of data, divide into 'pages' that can be stepped over.
Browsers automatically cache JS / CSS / Image files etc. Server side data caching significantly improves the responsiveness for large queries - simply store under a hash of the input query and use that as a lookup.
By Allan Bowe