Difference between revisions of "VbzCart/queries/qryCache Flow Procs"
Jump to navigation
Jump to search
m (moved VbzCart/queries/qryCache Flow Queries to VbzCart/queries/qryCache Flow Procs: going back to "procs" instead of "queries") |
(queries -> procs, new flow structure) |
||
| Line 5: | Line 5: | ||
* '''History''': | * '''History''': | ||
** '''2010-11-09''' Renamed tables, so had to fix this query; renamed from v_data_flow to qryCache_Flow_Queries | ** '''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== | ==SQL== | ||
| − | <section begin=sql /><mysql>CREATE OR REPLACE VIEW | + | <section begin=sql /><mysql>CREATE OR REPLACE VIEW qryCache_Flow_Procs AS |
SELECT | SELECT | ||
| − | |||
| − | |||
df.ID_Proc, | df.ID_Proc, | ||
| + | df.ID_Table, | ||
dfx.doesClear | dfx.doesClear | ||
FROM cache_flow AS df LEFT JOIN cache_queries AS dfx ON df.ID_Proc=dfx.ID | FROM cache_flow AS df LEFT JOIN cache_queries AS dfx ON df.ID_Proc=dfx.ID | ||
ORDER BY dfx.doesClear;</mysql> | ORDER BY dfx.doesClear;</mysql> | ||
<section end=sql /> | <section end=sql /> | ||
Revision as of 22:26, 13 November 2010
About
- Purpose: compiles caching data for quicker processing
- 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 df.ID_Proc, df.ID_Table, dfx.doesClear FROM cache_flow AS df LEFT JOIN cache_queries AS dfx ON df.ID_Proc=dfx.ID ORDER BY dfx.doesClear;</mysql>