Difference between revisions of "SET SMARTQUERY"

From Recital Documentation Wiki
Jump to: navigation, search
 
(2 intermediate revisions by one user not shown)
Line 1: Line 1:
{{YLM to do}}
 
 
Recital 10 introduces new SmartQuery technology which improves SQL SELECT performance dramatically. Most web applications are WORM applications (Write Once Read Many). When SET SMARTQUERY ON is in effect, then data selected with SQL SELECT commands is cached. When the same SELECT query is run again and no modifications have been made to the tables involved in the query, then the cached result set is returned without having to re-execute the query. This improves web application query performance. cached results are deleted automatically when their lifetime expires which defaults to any changes being made within 1 second. You can change the lifetime with the SET SMARTQUERY TO <lifetime_in_seconds> command.
 
 
 
==Purpose==
 
==Purpose==
 
+
Enable and configure SmartQuery caching
  
  
 
==Syntax==
 
==Syntax==
 
SET SMARTQUERY ON | OFF | (<expL>)
 
SET SMARTQUERY ON | OFF | (<expL>)
 +
 
SET SMARTQUERY TO <expN>
 
SET SMARTQUERY TO <expN>
  
Line 17: Line 14:
 
   
 
   
 
==Description==
 
==Description==
The SET SMARTQUERY command
+
When SET SMARTQUERY ON is in effect, then data selected with SQL SELECT commands is cached.  When the same SELECT query is run again and no modifications have been made to the tables involved in the query, then the cached result set is returned without having to re-execute the query.  This improves web application query performance.
 +
 
 +
The cached results are deleted automatically when their lifetime expires.  This ''lifetime'' defaults to any changes being made within 1 second.  The lifetime can be changed using the SET SMARTQUERY TO <expN> command, where <expN> is the lifetime in seconds.
  
  
 
==Example==
 
==Example==
 +
<code lang="recital">
 +
set smartquery on
 +
set smartquery to 2
 +
</code>
  
  
 
==Products==
 
==Products==
Recital Replication, Recital Server, Recital Web
+
Recital, Recital Server, Recital Web
 
[[Category:Documentation]]
 
[[Category:Documentation]]
 
[[Category:Commands]]
 
[[Category:Commands]]

Latest revision as of 16:04, 13 January 2010

Purpose

Enable and configure SmartQuery caching


Syntax

SET SMARTQUERY ON | OFF | (<expL>)

SET SMARTQUERY TO <expN>


See Also

CLEAR SMARTQUERY, SELECT


Description

When SET SMARTQUERY ON is in effect, then data selected with SQL SELECT commands is cached. When the same SELECT query is run again and no modifications have been made to the tables involved in the query, then the cached result set is returned without having to re-execute the query. This improves web application query performance.

The cached results are deleted automatically when their lifetime expires. This lifetime defaults to any changes being made within 1 second. The lifetime can be changed using the SET SMARTQUERY TO <expN> command, where <expN> is the lifetime in seconds.


Example

set smartquery on
set smartquery to 2


Products

Recital, Recital Server, Recital Web