Search results

...This query is '''very slow''' (40-45 seconds to execute)[[category:vbzcart/slow]]

** This query provides some of the same information as {{vbzcart|table|_title_ittyps}}, but (a) broken down by Item and (b) using live data. * '''Requires''': {{vbzcart/query|qryTitles_ItTyps_grpItems}}, {{vbzcart/table|cat_ittyps}}

** Prior to 2011-02-02, a very slow query ({{vbzcart/query|qryItTypsDepts_ItTyps}}) was temporarily in use. * '''Sources''': {{vbzcart|proc|Upd_DeptIttyps_fr_TitleIttyps}}, {{vbzcart|proc|Upd_DeptIttyps_fr_CatIttyps}}

* '''Requires''': {{vbzcart/query|qryOrders_Active}}, {{vbzcart/query|qryPkgLines_byOrdLine_andItem}} * '''Notes''': Very slow -- about takes 40 seconds

** may be slow/inefficient ...art/tables/event vc legacy]], [[VbzCart/tables/ord pull/migration]], and [[VbzCart/tables/stk bin history]]. If there's ever any proper documentation found (a

...bzCart]], but could be used in any other project where certain queries are slow and only need to be run when their source tables are updated.

PURPOSE: Special page for administering VbzCart 'url' => 'http://htyp.org/VbzCart',