35% OFF EVERYTHING
Our 11th BIRTHDAY SALE
Buy Now

Slow query issue

This topic contains 21 replies, has 3 voices, and was last updated by  IAN PETERS 7 years, 4 months ago.

We have moved to a support ticketing system and our forums are now closed.

Open Support Ticket

Tagged: 

  • Author
    Posts
  • December 4, 2017 at 1:04 pm #408130

    Stiofan O’Connor
    Site Admin
    Post count: 22956

    Sorry ian, i replied to this earlier but i think i was logged out in between starting and posting the reply…

    The pages seem fast for logged out where caching is running, for the slow queries the problem is that its trying to sort huge data sets, like 500k, we need to narrow it down to smaller number to get the query times down or add some more caching.

    For example the post widgets, setting them to only show featured will reduce the query times greatly and avoiding random sorts at all costs.

    Stiofan

    December 4, 2017 at 3:22 pm #408180

    IAN PETERS
    Buyer
    Post count: 39

    HI Stiofan

    OK I will try that, the slow queries were before I added 400k listings, so any other settings adjustments welcome

    Cheers

    Ian

    December 4, 2017 at 3:44 pm #408181

    IAN PETERS
    Buyer
    Post count: 39

    There is a warning on the dashboard about wp rocket that I don’t understand?

    December 4, 2017 at 4:03 pm #408182

    IAN PETERS
    Buyer
    Post count: 39

    OK cleared that and did as you suggested on the widgets. What additional caching were you thinking of?

    Tonbridgeflogit. Co. UK is almost identical and running fine, so I think there is something more

    December 6, 2017 at 6:13 am #408479

    IAN PETERS
    Buyer
    Post count: 39

    Hi Stiofan

    I have given you the settings on Skype. I made the changes you suggested but can’t see any difference yet

    December 6, 2017 at 6:37 pm #408561

    Stiofan O’Connor
    Site Admin
    Post count: 22956

    Does your other site have a catchall “main” category?
    Ping me on skype tomorrow about 11am and i’ll make time for you.

    Thanks,

    Stiofan

    December 6, 2017 at 10:45 pm #408606

    IAN PETERS
    Buyer
    Post count: 39

    I’m not sure what you mean. Speak to you at 11 tomorrow

  • Author
    Posts
Viewing 7 posts - 16 through 22 (of 22 total)

We have moved to a support ticketing system and our forums are now closed.

Open Support Ticket
20% Discount Offer
Hurry! Get your 20% discount before it expires. Get 20% Discount