VbzCart/queries/qryCache Flow Procs: Difference between revisions
from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
extracted from queries page |
correct header |
||
| Line 5: | Line 5: | ||
* '''History''': | * '''History''': | ||
** '''2010-11-09''' Renamed tables, so had to fix this query | ** '''2010-11-09''' Renamed tables, so had to fix this query | ||
== | ==SQL== | ||
<section begin=sql /><mysql>CREATE OR REPLACE VIEW v_data_flow AS | <section begin=sql /><mysql>CREATE OR REPLACE VIEW v_data_flow AS | ||
SELECT | SELECT | ||
Revision as of 18:21, 9 November 2010
About
- Purpose: compiles caching data for quicker processing
- Requires: cache_flow, cache_queries
- Used by: store page display routines (need to be more specific...)
- History:
- 2010-11-09 Renamed tables, so had to fix this query
SQL
<section begin=sql /><mysql>CREATE OR REPLACE VIEW v_data_flow AS
SELECT df.ID_Srce, df.ID_Dest, df.ID_Proc, dfx.doesClear FROM cache_flow AS df LEFT JOIN cache_queries AS dfx ON df.ID_Proc=dfx.ID ORDER BY dfx.doesClear;</mysql>
<section end=sql />
