Tagged: ,

Viewing 9 reply threads
  • Author
    Posts
    • October 8, 2014 at 4:10 pm #2543
      ralmestro
      Member

      Hi, I experimented a hight use of my server CPU, then I search about and I find a P3 – Plugin Performance Profiler and when I run it the test the results show that piklist is using the 78% of runtime of all plugins.

      Has anyone experimented the same?

      Attachments:
      You must be logged in to view attached files.
    • October 8, 2014 at 4:31 pm #2545
      Steve
      Keymaster

      @ralmestro– If Piklist is a core part of your site, it would make sense that is uses more resources. I just ran it on a site using Piklist, BuddyPress and 23 other plugins activated. The results were pretty shocking 😉

      Attachments:
      You must be logged in to view attached files.
    • October 10, 2014 at 4:16 pm #2555
      ralmestro
      Member

      Thanks for the response…Yeah the result is pretty shocking haha, I have another question: I’m using W3 Total Cache and when active the “Object Cache” the plugin stop saving.

    • October 12, 2014 at 7:29 pm #2558
      ianmuscat
      Member

      HI,

      I actually came here to post about the exact same issue I am facing. However, I’ve narrowed the issue down to several queries that Piklist seems to be making (I’m not 100% sure what these queries are for).

      I’ve been using Query Monitor (https://wordpress.org/plugins/query-monitor/) and it seems that the site I’m testing is generating ~134 Queries just for the home page. I’ve done some digging and it seems these queries are originating from …Piklist/includes/class-piklist-meta.php. As soon as I comment out the following lines (again, I’m not 100% sure what there use is), the query count drops to ~23 queries – quite a stark difference!

         add_filter('get_post_metadata', array('piklist_meta', 'get_post_meta'), 100, 4);
    add_filter('get_user_metadata', array('piklist_meta', 'get_user_meta'), 100, 4);
    add_filter('get_term_metadata', array('piklist_meta', 'get_term_meta'), 100, 4);

      It seems that what I’m using from Piklist (mainly metaboxes) still seem to work ok, so I’m not particularly sure what effect the mentioned lines have, however the load on MySQL, and therefore the load on the CPU is drastically reduced – I’m not sure if this is related to some sort of bug, but for higher-traffic sites, this is quite a performance hit.

      Regards,
      Ian

    • October 14, 2014 at 9:50 am #2564
      Steve
      Keymaster

      @ian– Thanks for the feedback. Is your site loading slow? Piklist is running on tons of sites, some are high-traffic (100,000+ page views a day), and we’ve never had an issue. Remember, not all queries are the same… and Piklist queries are optimized.

    • October 15, 2014 at 4:16 am #2569
      ianmuscat
      Member

      Hi Steve,

      Thank you for your reply. Usually, Piklist’s performance is not an issue for me – I’ve used it in the past and I never needed to tweak anything. However, I am working on a large, high-traffic site at the moment and as soon as we went live with a version of the site that made use of Piklist, the CPU usage shot up because of all the queries being made to the DB and the site even went offline for a few minutes because MySQL crashed.

      After some digging around, we commented out the mentioned lines and the site stabilized and the number of queries on each page decreased dramatically.

      If you need additional information, I’d be able to provide this via e-mail, just let me know where to reach you guys 🙂

      Once again, thank you for all your help regarding the matter.

      Regards,
      Ian

    • January 20, 2015 at 8:23 pm #3193
      andy
      Member

      Hey all,

      I’m working on a site with Piklist where speed is *the* major issue. I opened up Debug Bar’s query analyzer, and I saw that Piklist was performing ~700 queries on a page that had nothing Piklist-related on it. I removed the filters Ian mentioned like so:

      remove_filter('get_post_metadata', array('piklist_meta', 'get_post_meta'), 100, 4);
remove_filter('get_user_metadata', array('piklist_meta', 'get_user_meta'), 100, 4);
remove_filter('get_term_metadata', array('piklist_meta', 'get_term_meta'), 100, 4);

      However, I’m worried about blindly removing filters like this. If you don’t mind, could you elaborate on what these filters are doing? For what it’s worth, I’m using Piklist for a few meta boxes and settings pages.

    • January 20, 2015 at 9:32 pm #3194
      Kevin
      Keymaster

      Hi all-

      Just wanted to post an update on this one. The current method we use to determine grouped meta can add a large number of queries given the right circumstances. However in the current beta we are prepping for release, we have rewritten and it is extremely fast no matter what. In fact the upcoming version has a number of major improvements for queries not only in Piklist but WordPress itself, more on that later. If you need the update before the next version, please email [email protected] and we will get you taken care of.

      Thanks,

      Kevin

    • January 21, 2015 at 3:33 pm #3199
      andy
      Member

      Thanks Kevin! When is the beta scheduled for launch? I still have some time.

    • January 21, 2015 at 4:10 pm #3200
      Steve
      Keymaster

      @andy– Please email us at [email protected] and we’ll get it to you.

  • Author
    Posts
Viewing 9 reply threads
  • You must be logged in to reply to this topic.