Difference between revisions of "CLEAR SMARTQUERY"

Latest revision as of 16:05, 13 January 2010

Clear the SmartQuery cache for all tables

CLEAR SMARTQUERY

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

clear smartquery

Recital, Recital Server, Recital Web

@@ 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==
+Clear the SmartQuery cache for all tables
@@ Line 16: / Line 12: @@
 ==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==
+<code lang="recital">
+clear smartquery
+</code>
 ==Products==
-Recital Replication, Recital Server, Recital Web
+Recital, Recital Server, Recital Web
 [[Category:Documentation]]
 [[Category:Commands]]
 [[Category:SQL]]