Performance issue

  • aleks12

    (@aleks12)


    9 years, 5 months ago

    Hi,
    I have a high traffic website with more than 100.000 posts and 760.000 postmeta records.
    I had a serious performance issue on every page load, and I figured it out that there is heavy php load on every call of function get_main_array(), because it uses join query of those two tables.
    I think that you should consider removing wp_posts from that query since it’s only used to check if post is in trash or not.
    The benefit:
    old query on my db – 0.8701 sec
    query without wp_posts – 0.0061 sec

    who cares about a few array records with trashed posts? They will never be used anyway, so it’s better to have nearly good set of records with 150x faster load than a 100% accurate set of records

    Hope you will think about this and implement it in next version, I know i will.

    https://wordpress.org/plugins/quick-pagepost-redirect-plugin/

Viewing 2 replies - 1 through 2 (of 2 total)
  • Don Fischer

    (@prophecy2040)

    9 years, 5 months ago

    Thanks @aleks12,
    We are in the process of rewriting some of the functionality and this should be addressed in the next version. We have made changes to this function as well as a few others to speed some things up.

    Thanks for the feedback and suggestion.
    Warm regards,
    Don

    Thread Starter aleks12

    (@aleks12)

    9 years, 5 months ago

    Hi Don, great news,
    It’s a great plugin and if you speed it up like you say you will, it will be awsome 🙂

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Performance issue’ is closed to new replies.