Very slow database query

  • Resolved keengamer

    (@keengamer)


    4 years, 11 months ago

    Hello,

    we are trying to speed up our site because it’s sometimes quite slow even on our dedicated expensive server. We have usually around 100 visitors at the same time on our site. And using Query monitor we just found out that permalink is just taking a LONG time to process the query. We have around 10k posts. Take a look at it https://imgur.com/a/B4l79Uw

    We don’t need this plugin anymore for a long time but at the beginning when moving to wordpress, we used it a lot to make redirects for our old URLs. So we have maybe 2k links redirected and 8k are just fine.

    Is there a way of not running it if it’s not necessary or to speed it up or some other solution?

    Edit: If I go to PostTypes Permalinks then there are 94k items in the list and getting more every day. Most of them are Media…

    Thank you!

    • This topic was modified 4 years, 11 months ago by keengamer.
Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author Sami Ahmed Siddiqui

    (@sasiddiqui)

    Hi @keengamer

    Edit: If I go to PostTypes Permalinks then there are 94k items in the list and getting more every day. Most of them are Media…

    This issue is fixed and released in v2.8.0, please update to the latest version.

    Database query logic is already in my queue list and will be updated and make it faster in v3.0.0.

    Regards,
    Sami

    Thread Starter keengamer

    (@keengamer)

    Hi, well, we just had to disable your plugin and used another plugin to automatically create new 301 redirects, which is working now as well…

    Best,
    Karel

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Very slow database query’ is closed to new replies.