Hi DW,
It would be really nice to have an option on the eCom-paragraph module to disable the LoadStocks-function.
On high performance sites with a lot of products this takes some valuable time - please see this:
Ecom.mdb (Connection # 4)
CreateConnection (Dynamicweb.dll) in :0
CreateDataReader (Dynamicweb.dll) in :0
CreateDataReader (Dynamicweb.dll) in :0
LoadStocks (Dynamicweb.dll) in :0
GetPagedProductsByGroupIdsWithCount (Dynamicweb.dll) in :0
DeserializeProductsFromIndexByAutoIDs (Dynamicweb.dll) in :0
EcomRender (Dynamicweb.dll) in :0
GetContent (Dynamicweb.dll) in :0
GetModule (Dynamicweb.dll) in :0
WriteParagraph (Dynamicweb.dll) in :0
CreateLayoutContent (Dynamicweb.dll) in :0
CreateContentEXE (Dynamicweb.dll) in :0
CreateContent (Dynamicweb.dll) in :0
GetContent (Dynamicweb.dll) in :0
SetPageTemplateValues (Dynamicweb.dll) in :0
Output (Dynamicweb.dll) in :0
ParseControls (Dynamicweb.dll) in :0
OnInit (Dynamicweb.dll) in :0
Page_Load (Gasa.dll) in :0
ProcessRequest (App_Web_nugilize.dll) in :0
Ms since last stack: 453.1243
Records retrieved from DB by Datareader:
(SQL: SELECT ProductCollectionIndex, ProductStock FROM (( SELECT 0 AS ProductCollectionIndex, ProductStock FROM EcomProducts WHERE ( ProductID = 'M0000005745' ) AND ( ProductVariantID = '' ) AND ( ProductLanguageID = 'LANG1' ) )UNION ( SELECT 1 AS ProductCollectionIndex, ProductStock FROM EcomProducts WHERE ( ProductID = 'M0000004904' ) AND ( ProductVariantID = '' ) AND ( ProductLanguageID = 'LANG1' ) )UNION ( SELECT 2 AS ProductCollectionIndex, ProductStock FROM EcomProducts WHERE ( ProductID = 'M0000005417' ) AND ( ProductVariantID = '' ) AND ( ProductLanguageID = 'LANG1' ) )UNION ( SELECT 3 AS ProductCollectionIndex, ProductStock FROM EcomProducts WHERE ( ProductID = 'M0000004906' ) AND ( ProductVariantID = '' ) AND ( ProductLanguageID = 'LANG1' ) )UNION ( SELECT 4 AS ProductCollectionIndex, ProductStock FROM EcomProducts WHERE ( ProductID = 'M0000013392' ) AND ( ProductVariantID = '' ) AND ( ProductLanguageID = 'LANG1' ) )UNION ( SELECT 5 AS ProductCollectionIndex, ProductStock FROM EcomProducts WHERE ( ProductID = 'M0000004907' ) AND ( ProductVariantID = '' ) AND ( ProductLanguageID = 'LANG1' ) )UNION ( SELECT 6 AS ProductCollectionIndex, ProductStock FROM EcomProducts WHERE ( ProductID = 'M0000004908' ) AND ( ProductVariantID = '' ) AND ( ProductLanguageID = 'LANG1' ) )UNION ( SELECT 7 AS ProductCollectionIndex, ProductStock FROM EcomProducts WHERE ( ProductID = 'M0000004909' ) AND ( ProductVariantID = '' ) AND ( ProductLanguageID = 'LANG1' ) )UNION ( SELECT 8 AS ProductCollectionIndex, ProductStock FROM EcomProducts WHERE ( ProductID = 'M0000005462' ) AND ( ProductVariantID = '' ) AND ( ProductLanguageID = 'LANG1' ) )UNION ( SELECT 9 AS ProductCollectionIndex, ProductStock FROM EcomProducts WHERE ( ProductID = 'M0000004910' ) AND ( ProductVariantID = '' ) AND ( ProductLanguageID = 'LANG1' ) )UNION ( SELECT 10 AS ProductCollectionIndex, ProductStock FROM EcomProducts WHERE ( ProductID = 'M0000004911' ) AND ( ProductVariantID = '' ) AND ( ProductLanguageID = 'LANG1' ) )UNION ( SELECT 11 AS ProductCollectionIndex, ProductStock FROM EcomProducts WHERE ( ProductID = 'M0000005463' ) AND ( ProductVariantID = '' ) AND ( ProductLanguageID = 'LANG1' ) )UNION ( SELECT 12 AS ProductCollectionIndex, ProductStock FROM EcomProducts WHERE ( ProductID = 'M0000004912' ) AND ( ProductVariantID = '' ) AND ( ProductLanguageID = 'LANG1' ) )UNION ( SELECT 13 AS ProductCollectionIndex, ProductStock FROM EcomProducts WHERE ( ProductID = 'M0000004913' ) AND ( ProductVariantID = '' ) AND ( ProductLanguageID = 'LANG1' ) )UNION ( SELECT 14 AS ProductCollectionIndex, ProductStock FROM EcomProducts WHERE ( ProductID = 'M0000004914' ) AND ( ProductVariantID = '' ) AND ( ProductLanguageID = 'LANG1' ) )UNION ( SELECT 15 AS ProductCollectionIndex, ProductStock FROM EcomProducts WHERE ( ProductID = 'M0000004915' ) AND ( ProductVariantID = '' ) AND ( ProductLanguageID = 'LANG1' ) )UNION ( SELECT 16 AS ProductCollectionIndex, ProductStock FROM EcomProducts WHERE ( ProductID = 'M0000005464' ) AND ( ProductVariantID = '' ) AND ( ProductLanguageID = 'LANG1' ) )UNION ( SELECT 17 AS ProductCollectionIndex, ProductStock FROM EcomProducts WHERE ( ProductID = 'M0000005465' ) AND ( ProductVariantID = '' ) AND ( ProductLanguageID = 'LANG1' ) )UNION ( SELECT 18 AS ProductCollectionIndex, ProductStock FROM EcomProducts WHERE ( ProductID = 'M0000005469' ) AND ( ProductVariantID = '' ) AND ( ProductLanguageID = 'LANG1' ) )UNION ( SELECT 19 AS ProductCollectionIndex, ProductStock FROM EcomProducts WHERE ( ProductID = 'M0000005471' ) AND ( ProductVariantID = '' ) AND ( ProductLanguageID = 'LANG1' ) )UNION ( SELECT 20 AS ProductCollectionIndex, ProductStock FROM EcomProducts WHERE ( ProductID = 'M0000005419' ) AND ( ProductVariantID = '' ) AND ( ProductLanguageID = 'LANG1' ) )UNION ( SELECT 21 AS ProductCollectionIndex, ProductStock FROM EcomProducts WHERE ( ProductID = 'M0000004917' ) AND ( ProductVariantID = '' ) AND ( ProductLanguageID = 'LANG1' ) )UNION ( SELECT 22 AS ProductCollectionIndex, ProductStock FROM EcomProducts WHERE ( ProductID = 'M0000005470' ) AND ( ProductVariantID = '' ) AND ( ProductLanguageID = 'LANG1' ) )UNION ( SELECT 23 AS ProductCollectionIndex, ProductStock FROM EcomProducts WHERE ( ProductID = 'M0000005474' ) AND ( ProductVariantID = '' ) AND ( ProductLanguageID = 'LANG1' ) )UNION ( SELECT 24 AS ProductCollectionIndex, ProductStock FROM EcomProducts WHERE ( ProductID = 'M0000005473' ) AND ( ProductVariantID = '' ) AND ( ProductLanguageID = 'LANG1' ) )UNION ( SELECT 25 AS ProductCollectionIndex, ProductStock FROM EcomProducts WHERE ( ProductID = 'M0000004920' ) AND ( ProductVariantID = '' ) AND ( ProductLanguageID = 'LANG1' ) )UNION ( SELECT 26 AS ProductCollectionIndex, ProductStock FROM EcomProducts WHERE ( ProductID = 'M0000005468' ) AND ( ProductVariantID = '' ) AND ( ProductLanguageID = 'LANG1' ) )UNION ( SELECT 27 AS ProductCollectionIndex, ProductStock FROM EcomProducts WHERE ( ProductID = 'M0000005467' ) AND ( ProductVariantID = '' ) AND ( ProductLanguageID = 'LANG1' ) )UNION ( SELECT 28 AS ProductCollectionIndex, ProductStock FROM EcomProducts WHERE ( ProductID = 'M0000004921' ) AND ( ProductVariantID = '' ) AND ( ProductLanguageID = 'LANG1' ) )UNION ( SELECT 29 AS ProductCollectionIndex, ProductStock FROM EcomProducts WHERE ( ProductID = 'M0000004922' ) AND ( ProductVariantID = '' ) AND ( ProductLanguageID = 'LANG1' ) )UNION ( SELECT 30 AS ProductCollectionIndex, ProductStock FROM EcomProducts WHERE ( ProductID = 'M0000004923' ) AND ( ProductVariantID = '' ) AND ( ProductLanguageID = 'LANG1' ) )UNION ( SELECT 31 AS ProductCollectionIndex, ProductStock FROM EcomProducts WHERE ( ProductID = 'M0000004924' ) AND ( ProductVariantID = '' ) AND ( ProductLanguageID = 'LANG1' ) )UNION ( SELECT 32 AS ProductCollectionIndex, ProductStock FROM EcomProducts WHERE ( ProductID = 'M0000004939' ) AND ( ProductVariantID = '' ) AND ( ProductLanguageID = 'LANG1' ) )UNION ( SELECT 33 AS ProductCollectionIndex, ProductStock FROM EcomProducts WHERE ( ProductID = 'M0000005475' ) AND ( ProductVariantID = '' ) AND ( ProductLanguageID = 'LANG1' ) )UNION ( SELECT 34 AS ProductCollectionIndex, ProductStock FROM EcomProducts WHERE ( ProductID = 'M0000005746' ) AND ( ProductVariantID = '' ) AND ( ProductLanguageID = 'LANG1' ) )UNION ( SELECT 35 AS ProductCollectionIndex, ProductStock FROM EcomProducts WHERE ( ProductID = 'M0000004940' ) AND ( ProductVariantID = '' ) AND ( ProductLanguageID = 'LANG1' ) )UNION ( SELECT 36 AS ProductCollectionIndex, ProductStock FROM EcomProducts WHERE ( ProductID = 'M0000009883' ) AND ( ProductVariantID = '' ) AND ( ProductLanguageID = 'LANG1' ) )UNION ( SELECT 37 AS ProductCollectionIndex, ProductStock FROM EcomProducts WHERE ( ProductID = 'M0000009886' ) AND ( ProductVariantID = '' ) AND ( ProductLanguageID = 'LANG1' ) )UNION ( SELECT 38 AS ProductCollectionIndex, ProductStock FROM EcomProducts WHERE ( ProductID = 'M0000004942' ) AND ( ProductVariantID = '' ) AND ( ProductLanguageID = 'LANG1' ) )UNION ( SELECT 39 AS ProductCollectionIndex, ProductStock FROM EcomProducts WHERE ( ProductID = 'M0000004943' ) AND ( ProductVariantID = '' ) AND ( ProductLanguageID = 'LANG1' ) )) AS p)
Best regards, Anders