1. briviumlover

    briviumlover - Apr 22, 2015 New Member

    Credit
    Point
    Hi Brivium,

    The problem is that when viewing the "Most Followers" tab at the Notable Members list I have a slow query that uses around 85% of my CPU:


    slow_query


    Isn't this due to a missing index? As far as I know when a query says "using filesort" it means that an index would be of help. For example take a look at the stock XF query that processes the "Most Messages" tab at the Notable Members list:


    most_messages


    As you can see the stock XF query doesn't "uses filesort".

    Could you please check this?

    Thanks,
    briviumlover
     
    Loading...
  2. Brivium

    Brivium - Apr 22, 2015 XenForo Services Staff Member

    Credit
    Point
    Dear Friend,

    Thanks for your report. Let me check and have a response to you asap.

    Regards,
     
    #2
  3. Brivium

    Brivium - Apr 23, 2015 XenForo Services Staff Member

    Credit
    Point
    #3
  4. briviumlover

    briviumlover - Apr 25, 2015 New Member

    Credit
    Point
    Hello,

    It looks like the file structure of your add-on version 1.0.1 is wrong. I got the following error message on install:

    I can see that folder Brivium/BriviumLibrary exists on 1.0.0 but on version 1.0.1 it looks like you changed the path to Brivium/BriviumHelper but forgot to update the path in the add-on files.

    Please fix.

    Thanks,
    briviumlover
     
    #4
  5. Brivium

    Brivium - Apr 25, 2015 XenForo Services Staff Member

    Credit
    Point
    Could you please try to download this add-on again ?
     
    #5
  6. briviumlover

    briviumlover - Apr 28, 2015 New Member

    Credit
    Point
    Installed the updated 1.0.1 package, ran "Rebuild User Followers" however when on members/?type=follower I see the latest 20 members registered on my forums not the 20 members with the highest followers count.

    Please fix and test the add-on before releasing 1.0.2

    Thanks,
    briviumlover
     
    #6
  7. briviumlover

    briviumlover - Apr 30, 2015 New Member

    Credit
    Point
    Could you please check?
     
    #7
  8. Brivium

    Brivium - Apr 30, 2015 XenForo Services Staff Member

    Credit
    Point
    I've just tested this add-on and this still works normally. Could you please submit a ticket which contains your forum URL and an admin account to debug your issue ?

    Regards,
     
    #8
  9. rafass

    rafass - May 22, 2015 Active Member VIP Member

    Credit
    Point
    #9
  10. Brivium

    Brivium - May 22, 2015 XenForo Services Staff Member

    Credit
    Point
    I don't totally understand your mean ? What's problem at here?
     
    #10
  11. rafass

    rafass - May 22, 2015 Active Member VIP Member

    Credit
    Point
    Not a performance issue actually, just curious..
    I was testing with Modern statistics because I'm getting this punctual problem:
    aaa1
    Don't load sometimes. I don't know why. any idea Brivium?
    .
    .
    .
     
    #11
  12. Brivium

    Brivium - May 23, 2015 XenForo Services Staff Member

    Credit
    Point
    Could you please tell me when this problem occurs ?
     
    #12
  13. rafass

    rafass - May 23, 2015 Active Member VIP Member

    Credit
    Point
    it happen only sometimes (very few times) reloading the homepage. using this option:
    R 2015-05-23 at 144423
    I'll keep testing if it continue happening I'll open a ticket. Thanks!
     
    #13