ExpressionEngine CMS
Open, Free, Amazing

Thread

This is an archived forum and the content is probably no longer relevant, but is provided here for posterity.

The active forums are here.

{reverse_related_entries} Exhausting Memory

December 10, 2010 7:02am

Subscribe [2]
  • #1 / Dec 10, 2010 7:02am

    Ian Ebden

    312 posts

    Running into some difficulties with this suddenly on a live site. Been working fine up till now. Code is pretty straightforward…

    <ul>
    {exp:channel:entries 
        disable="member_data|pagination" 
        cache="yes" 
        channel="teams" 
        dynamic="yes" 
        orderby="title" 
        refresh="60" 
        sort="asc" 
        sticky="no"
    }
    {reverse_related_entries channel="clubs"}
    {if no_reverse_related_entries}<li>No clubs available</li>{/if}
    <li><a href="http://{title_permalink=clubs}">{title}</a></li>
    {/reverse_related_entries}
    {/exp:channel:entries}
    </ul>

    It should display a list of all clubs with teams (based on category_url).

    This is a fairly high traffic site with a large exp_relationships table (80Mb). Various reasons it was done with relationships rather than categories in this case. I’ve optimised the table, and the server has a 128Mb memory_limit. All I get from the template is the dreaded white screen!

    Anyone know any tricks/tips I can try to optimise further?

    Any help much appreciated.

  • #2 / Dec 10, 2010 8:09am

    Sue Crocker

    26054 posts

    Hi, Ian. If you just put in that bit of code in a template, does the same thing happen?

  • #3 / Dec 10, 2010 9:19am

    Ian Ebden

    312 posts

    Hi Sue. Created a separate template with just that code in and it appears to work fine. I’ll do some more testing, but it may be that I split this bit out into a new template for now. Thanks for your help.

  • #4 / Dec 10, 2010 4:18pm

    Sue Crocker

    26054 posts

    Glad that’ll work for you.. Don’t hesitate to post again as needed.

.(JavaScript must be enabled to view this email address)

ExpressionEngine News!

#eecms, #events, #releases