Duplicate Queries

  • Resolved issami1

    (@issami1)


    7 years, 6 months ago

    Hello,
    First of all, thank you so much for this wonderful plugin!

    We have duplicate queries related to BP Better Messages and we do not know how to deal with that:
    BP_Messages_Thread::get_total_threads_for_user()

    BP_Better_Messages_Component->setup_nav()
    1 call
    BP_Better_Messages->load_scripts()
    1 call

    Could you help us to resolve this issue please?

    Thanks in advance!

Viewing 10 replies - 1 through 10 (of 10 total)
  • Plugin Author wordplus

    (@wordplus)

    7 years, 6 months ago

    Hi there!

    Dont understood your issue sorry.

    Can you explain abit better?

    Thanks!

    Thread Starter issami1

    (@issami1)

    7 years, 6 months ago

    Hello,
    We are using a plugin called “Query Monitor” which detectes anomalies related to the other plugins.
    And through this plugin we did detect many “Duplicate queries” making the website slow..
    Some of those are related to “BP Better Message” as mentioned in the last message.

    We hope the explanation is more clear 🙂

    Regards!

    Plugin Author wordplus

    (@wordplus)

    7 years, 6 months ago

    Can you send some queries which making it slow please?

    Thanks!

    Thread Starter issami1

    (@issami1)

    7 years, 6 months ago

    Here is the report:
    SELECT COUNT(thread_id)
    FROM wp_y7o24n1_bp_messages_recipients
    WHERE user_id = 14
    AND is_deleted = 0
    AND sender_only != 1
    AND unread_count != 0

    BP_Messages_Thread::get_total_threads_for_user()
    2 calls
    Plugin: buddypress
    2 calls
    BP_Better_Messages_Component->setup_nav()
    1 call
    BP_Better_Messages->load_scripts()
    1 call

    Regards.

    Plugin Author wordplus

    (@wordplus)

    7 years, 6 months ago

    And what is the speed?

    Thread Starter issami1

    (@issami1)

    7 years, 6 months ago

    PageSpeed Score
    (37%)
    YSlow Score
    (64%)
    Page Details
    Fully Loaded Time
    25.1s
    Total Page Size
    11.1MB
    Requests
    250

    Plugin Author wordplus

    (@wordplus)

    7 years, 6 months ago

    No I mean this query speed?
    It works enough fast for me on all my websites, its standard SQL query, taken from BuddyPress messaging component really, cant be improved.

    Plugin Author wordplus

    (@wordplus)

    7 years, 6 months ago

    Also this and other queries are executed only for logged in users, so this cant affect to google pagespeed and yslow.

    Thread Starter issami1

    (@issami1)

    7 years, 6 months ago

    I do not know where I could find it 🙂
    I understand you’re doing your best.
    Thank you very much for your efforts and have a nice day!

    Thread Starter issami1

    (@issami1)

    7 years, 6 months ago

    Resolved.

Viewing 10 replies - 1 through 10 (of 10 total)

The topic ‘Duplicate Queries’ is closed to new replies.