Home Forums Popup Fire slow log database queries

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • #5194
    AvatarCharlie
    Keymaster

    Hi,

    I love the popup fire, content fire and firebar plugins and recently purchased all of them. But there is a problem, they are creating too many queries to my database, causing my cpu usage to exceed bandwidth.

    Here is an example of the query:

    Query Example: UPDATE wp_nnrobots_content_fire_stats SET
    impressions = impressions + 1
    WHERE date = ‘2015-05-27’ AND content_fire_id = 2;
    SELECT * FROM wp_wpsite_firebar_stats WHERE date = ‘2015-05-27’ AND firebar_id = 2;

    Can you help find a solution to this – or some way to turn analytics off, so it doesnt keep generating so many slow logs for the server?

    Please let me know as soon as possible.

    Thank you

    #5195
    Avatarsupportsite
    Participant

    Hi – Glad to see you like the plugin.

    Since we’ve actually never received notice from any of our users saying our plugin is causing slowness, can you share a few more details:

    1) How much traffic do you get per day / month?
    2) What type of hosting do you have? limits?
    3) Is it possible that the slowness is caused by any other plugins on your site? Can you list out what plugins you have, or maybe even use P3 Profiler to see which is causing the most slowness. https://wordpress.org/plugins/p3-profiler/
    4) Do you use a Cache plugin? If not, try WP Super Cache or W3 Total Cache and see how the performance is after a day or two of use.

    Most of our users are on shared hosting as well, and they are not having any such issues. For example, we host a lot of sites on HostGator that all run these plugins simulataneously, and have not had any issues. So any additional information you provide would be helpful.

    Thank you.

Viewing 2 posts - 1 through 2 (of 2 total)
  • You must be logged in to reply to this topic.