Very slow responds when showing productlists

Kasper Jensen

Posted on 31/01/2013 14:21:35

Hey,

I got a xslt productlist template, which handles both grouplisting and productlisting. Theres two different grouplisting templates, parent group listing and child group listing.

The reason why i made it all in 1 template, is because of the varius ways of displaying the products and groups on.The productlist template has the possibility to be displayed in 2 or 3 columns. It also has a picture and the description from the group.

To make the group listing correct, i would need the childgroups loop, but it contains 15.000+ lines of xml. When using the childgroups loop, everything works perfectly. The issue is the respond time is around 5 sec+ when using the childgroups loop.

I've tried to make some workarounds, but i can't find a satisfying result. I've tried to split the templates a little up, but in the end, i would still need the childgroups loop.

The DB contains around 4.000 products and around 350 groups.

Have anyone expirenced slow responsetimes when using the childgroups loop? And has anyone found a solution or a workaround for this?

Thanks! :-)

Replies

Nicolai Høeg Pedersen

Posted on 01/02/2013 15:51:57

Hi Kasper

15.000 lines of XML sounds like a Little too much. So I think we have to have a look in order to fully figure out what the issue is.

That said, it sounds like you might benefit from making this in a couple of templates instead of one.

Can you post us you template/url and the sample XML, or send me an e-mail? Then I'll have someone take a look.

BR Nicolai

Oliver Lassen

Posted on 06/02/2013 10:07:26

Hi Nicolai,

We have attatched the Productlist template.

The url for the page on the solution is http://skovlarsen2012.net.dynamicweb-cms.com/da-DK/Brands.aspx

Thanks for the help :-)

SL12BrandsProductList.xslt

Merethe Nielsen

Posted on 07/02/2013 09:51:10

I have created an investigation item with number 11173. Then someone from the Development department will take a look at the problem.

Kind regards,

Merethe

Merethe Nielsen

Posted on 21/02/2013 08:59:38

The developer has written that the problem with perfomance occurs when we use this code in xslt template (SL12BrandsProductList.xslt):

<xsl:variable name="availableloops" select="'Childgroups,Products,ProductGroups,AssociatedGroups'" />

The dynamicweb core creates a lot of similar sql queries.

I have created bug 11284 regarding optimization of this.

Using <xsl:variable name="availableloops" select="'ProductGroups'" /> reduces the page render time and also reduces the number of SQl queries.

Kind regards,

Merethe

Oliver Lassen

Posted on 21/02/2013 12:06:58

Hi,

Thanks for the help! Any expected date when this bugfix is implemented?

Merethe Nielsen

Posted on 21/02/2013 12:47:41

Unfortunately no, the bug has not been prioritized yet.

Kind regards,
Merethe

Merethe Nielsen

Posted on 12/08/2013 12:56:24

Optimization of this with 8.2.1.7 (and later versions).

You must be logged in to post in the forum

Developer forum

Very slow responds when showing productlists

Replies