Difference between revisions of "SET SMARTQUERY"
Yvonnemilne (Talk | contribs) |
Yvonnemilne (Talk | contribs) |
||
| Line 4: | Line 4: | ||
==Purpose== | ==Purpose== | ||
| + | |||
| Line 12: | Line 13: | ||
==See Also== | ==See Also== | ||
| + | [[CLEAR SMARTQUERY]], [[SQL SELECT|SELECT]] | ||
| − | + | ||
==Description== | ==Description== | ||
The SET SMARTQUERY command | The SET SMARTQUERY command | ||
| + | |||
==Example== | ==Example== | ||
Revision as of 15:30, 13 January 2010
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
