View Full Version : What is SMARTQUERY

2012-03-14, 08:01
The Lianja SQL Server has the ability to cache SQL SELECT resultsets across multiple client connections. It will only throw away an existing cached resultset if any of the tables involved in the query have been modified since the cached copy was created. Many web apps are WORM (Write Once Read Many) so if you SET SMARTQUERY ON this will result in high performance when many users are querying the same data as no parsing or querying is required, the cached resultset can just be sent back to the client.