SET SMARTQUERY

From Recital Documentation Wiki
Revision as of 15:15, 13 January 2010 by Yvonnemilne (Talk | contribs)

Jump to: navigation, search

Template: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

Syntax

SET SMARTQUERY ON | OFF | (<expL>) SET SMARTQUERY TO <expN>


See Also

Description

The SET SMARTQUERY command

Example

Products

Recital Replication, Recital Server, Recital Web