Thread

Hi guys,

I have 1 page that takes a ridiculous amount of time to load and from my debugging log it appears to be the simple commerce module. At the moment it’s anywhere from 40 seconds to 90 seconds to load the page. Seems to be about 70 at the moment.

My template debugging log and sql log is attached to this post and you will be able to see the simple commerce module tags looping over and over.

I’ve stripped the template down from what it once was the but the large delay is still present:

{exp:weblog:entries weblog="shopping_categories" disable="categories|member_data|pagination|trackbacks" sort="asc" orderby="date"}

<h3>{title}</h3>

<p>{reverse_related_entries sort="desc" orderby="title"} </p>

<p>{exp:simple_commerce:purchase entry_id="{entry_id}" success="/" cancel="/" country_code="NZ" currency="NZD"}</p>

<p><a href="http://{title_permalink=shopping/product}"><strong>{item_name}</strong></a></p>

<p>{/exp:simple_commerce:purchase}    <br />
    <br />
{/reverse_related_entries}</p>

<p>{/exp:weblog:entries}

If I remove the simple commerce tags the page loads in 0.8 seconds like so:

{exp:weblog:entries weblog="shopping_categories" disable="categories|member_data|pagination|trackbacks" sort="asc" orderby="date"}

<h3>{title}</h3>

<p>{reverse_related_entries sort="desc" orderby="title"} <br />
    <br />
{/reverse_related_entries}</p>

<p>{/exp:weblog:entries}

Let’s check this- use the simple commerce tag, but not in a related entry tag.  So something like

{exp:weblog:entries weblog="shopping_categories" disable="categories|member_data|pagination|trackbacks" sort="asc" orderby="date"}

<h3>{title}</h3>

<p>{exp:simple_commerce:purchase entry_id="{entry_id}" success="/" cancel="/" country_code="NZ" currency="NZD"}</p>

<p><a href="http://{title_permalink=shopping/product}"><strong>{item_name}</strong></a></p>

<p>{/exp:simple_commerce:purchase}    <br />
    </p>

<p>{/exp:weblog:entries}

Set so it’s pulling in whatever entries you were calling up via reverse related.  I’m wondering if there’s something going on with the combo.

Hi Robin,

Interestingly enough, I removed the reverse related tags as in your example and it loads super fast. I probably should have mentioned that the way I’ve built it now with the reverse related tags is actually different to what it originally is. I tried to make it more efficient in a bid to fix the slowness. My original way actually has category_archive tags, categories and all sorts nested within each other.

And just to confuse you even more I setup the site on a Media Temple DV 3.5 server last night and the shopping page loads extremely fast (0.5 seconds as opposed to 70). So could the entire problem just be because of my current host? It is a shared server, and I have contacted them but they are pointing the finger at the site itself, more specifically the cache folder they said within the EE system folder.

Spare no more thought on this though, because I’m just going to move the whole site over to the MT server. Will post back if for any reason it starts to bog down on the new server.

So shall we close this thread now? You can reference it again in a new thread if needed.

Yes thanks

Closing thread..