Hi guys
We have set up a site using version 8.3.1.8. This is in general working as intended, we do however have a problem with performance. Loading the product pages and cart takes a really long time, and when I use the ?debug=true function I get some weird results.
| 10:40:11.904 | Executing datareader (Ecom.mdb: SELECT * FROM EcomCountries WHERE CountryCode2 = 'DK' AND CountryRegionCode <> '' ORDER BY CountryRegionCode) - took: 0 ms. | 0 | 547 |
| 10:40:12.951 | Executing datareader (Ecom.mdb: SELECT * FROM EcomShippings WHERE ShippingID = 'SHIP3' AND ShippingLanguageID = 'LANG1') - took: 0 ms. | 1047 | 1594 |
| 10:40:13.482 | Executing datareader (Ecom.mdb: SELECT * FROM EcomCountries WHERE CountryCode2 = 'DK' AND CountryRegionCode <> '' ORDER BY CountryRegionCode) - took: 0 ms. | 0 | 2125 |
| 10:40:14.732 | Starting template.output (E:\dynamicweb.net\solotest.nozebrahosting.dk\S_DW_SOLO\Files\Templates\Designs\Solo2013\eCom7/CartV2/Step/SoloShowCart.html (Shippingmethods)) | 1250 | 3374 |
These are some particular example of some weird performance. The above posting is quite consistent. On all pages where those methods are being used. It always takes about 1000+ milliseconds for the execution to go from the first to the second line. Does anyone have a suggestion as to why this is the case? Is there some setting I might have overlooked? Besides these crazy examples there are other parts with between 50 and 500 ms wait times.