/categories/* pages extremely slow (with multiple events)

  • Resolved derweed

    (@derweed)


    7 years, 5 months ago

    From once we had hit around 4.000 events, the display of the category lists got extremely slow. The CPU of my box is going through the roof, currently I see a load of 6-14 (php-cgi process, not mysql). Displaying the pages take around 30-50 sec at the moment. The page is almost blank, except the list.

    Example: https://demo.wp-events-plugin.com/events/categories/jazz
    (this is relatively fast)

    We use cascading categries, like “kids” and “from 6 to 9” (/categories/kids/from9to9/) and do habe a few thousand events in those. They add up quickly, because a lot of events do happen more than once daily. It looks like something is not quite optimal, when fetching the list of events in more-than-one category.

    How can we speed up the display of those category-vie pages? Can we cache the output of the lists? They are used very frequently.

Viewing 4 replies - 1 through 4 (of 4 total)

  • How many categories do you have?

    Are most of your events single events or recurring events?

    Do you have a cache plugin running?

    Thread Starter derweed

    (@derweed)

    Sorry for my late answer, The notificytion somehow did not work.

    > How many categories do you have?
    24

    > Are most of your events single events or recurring events?
    60% recurring / 40% single (trend goes to recurring)

    > Do you have a cache plugin running?
    I didn’t, until we found the category output unuseable. I have set up ‘Cache Enabler’ to cache the Output of the /category/ pages. Which is working aroung 50% of the time.

    Thread Starter derweed

    (@derweed)

    It gets worse. We have 5.500+ events in one category and counting. Now my php processes are dying (around 500 per day):

    mod_fcgid: stderr: PHP Fatal error: Allowed memory size of 268435456 bytes exhausted (tried to allocate 1133265 bytes) in <PATH>/wp-content/plugins/events-manager/classes/em-events.php on line 195

    The Limit is enforces by our hoster and has been risen two times. Maybe something in there is not ideal? ??

    Thread Starter derweed

    (@derweed)

    Any Ideas, or should I open a new thread?

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘/categories/* pages extremely slow (with multiple events)’ is closed to new replies.