VbzCart/queries/qryCache Flow Procs
Jump to navigation
Jump to search
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>