Difference between revisions of "CLEAR SMARTQUERY"

From Recital Documentation Wiki
Jump to: navigation, search
 
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==
 
+
Clear the SmartQuery cache for all tables
  
  
Line 16: Line 12:
 
   
 
   
 
==Description==
 
==Description==
The CLEAR SMARTQUERY command
+
The CLEAR SMARTQUERY command clears the SmartQuery cache for all tables.  For a description of SmartQuery caching, please see [[SET SMARTQUERY]].
  
  
 
==Example==
 
==Example==
 +
clear smartquery
  
  
 
==Products==
 
==Products==
Recital Replication, Recital Server, Recital Web
+
Recital, Recital Server, Recital Web
 
[[Category:Documentation]]
 
[[Category:Documentation]]
 
[[Category:Commands]]
 
[[Category:Commands]]
 
[[Category:SQL]]
 
[[Category:SQL]]

Revision as of 15:57, 13 January 2010

Purpose

Clear the SmartQuery cache for all tables


Syntax

CLEAR SMARTQUERY


See Also

SELECT, SET SMARTQUERY


Description

The CLEAR SMARTQUERY command clears the SmartQuery cache for all tables. For a description of SmartQuery caching, please see SET SMARTQUERY.


Example

clear smartquery


Products

Recital, Recital Server, Recital Web