Limit queries to avoid page errors

  • Resolved chissco

    (@chissco)


    6 months ago

    Good afternoon

    I’m using the plugin on my multi-suite website. The problem is that, due to the numerous queries the program itself makes, the page freezes with 500 and 502 errors. If I generate matches and open two or three screens, it generates errors. When the event is created with a query, each page has around 150 query monitor. I’d like to know if there’s any way to limit these queries so I can continue using the program normally?

    Thanks as always.

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Contributor Savvas

    (@savvasha)

    6 months ago

    Hi @chissco ,

    To help reduce the query load, I’d recommend first enabling a caching plugin like WP Super Cache or W3 Total Cache, which can significantly reduce database queries by serving cached versions of your pages. Additionally, you might want to limit the number of events, players, or teams displayed on each page by adjusting the “Number of results to show” settings in the SportsPress configuration options (SportsPress > Settings). If you’re using widgets or shortcodes that display multiple league tables or player lists, consider reducing the number of items shown or splitting them across different pages.

    Another important step is to check if there are any plugin conflicts by temporarily deactivating other plugins to see if the query count improves.

    You should also ensure your hosting environment has adequate resources for a multisite installation with SportsPress, as 500/502 errors often indicate server memory or timeout limits being reached.

    If the issue persists, consider reaching out to your hosting provider about increasing PHP memory limits and max execution time, or explore upgrading to a more robust hosting plan that can handle the database load from SportsPress on a multisite network.

    Thanks,
    Savvas

    Thread Starter chissco

    (@chissco)

    5 months, 3 weeks ago

    Good morning

    Thank you for your messages. I’ve already been doing those kinds of tests and so on, but since it’s a multi-suite site, there are obviously many events and types of sports, which makes things very complicated. I’m consulting with you to see if there’s anything that actually works, because neither the caching plugins nor other tests have worked.

    We’ll see how I can solve it.

    Thank you very much.

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

You must be logged in to reply to this topic.