Difference between revisions of "VbzCart/queries/qryCache Flow Procs"
Jump to navigation
Jump to search
(one field missing) |
(more specific purpose) |
||
| Line 1: | Line 1: | ||
==About== | ==About== | ||
| − | * '''Purpose''': | + | * '''Purpose''': gives a list of procs for a given table, making sure that any proc with a set "doesClear" flag comes before the rest. |
* '''Requires''': {{vbzcart|table|cache_flow}}, {{vbzcart|table|cache_queries}} | * '''Requires''': {{vbzcart|table|cache_flow}}, {{vbzcart|table|cache_queries}} | ||
* '''Used by''': cache manager | * '''Used by''': cache manager | ||
Latest revision as of 03:14, 14 November 2010
About
- Purpose: gives a list of procs for a given table, making sure that any proc with a set "doesClear" flag comes before the rest.
- Requires: cache_flow, cache_queries
- Used by: cache manager
- History:
- 2010-11-09 Renamed tables, so had to fix this query; renamed from v_data_flow to qryCache_Flow_Queries
- 2010-11-13 Renamed from qryCache_Flow_Queries to qryCache_Flow_Procs; modified to use new cache_flow structure
SQL
<mysql>CREATE OR REPLACE VIEW qryCache_Flow_Procs AS
SELECT cf.ID_Proc, cf.ID_Table, cf.doWrite, cp.doesClear FROM cache_flow AS cf LEFT JOIN cache_queries AS cp ON cf.ID_Proc=cp.ID ORDER BY cp.doesClear;</mysql>