1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Optimized List Queries by Xon 1.2.3b

A collection of replacement queries for getting lists of stuff aimed at large forums.

  1. Xon

    Xon Well-Known Member

    Xon submitted a new resource:

    Optimized List Queries by Xon - A collection of replacement queries for getting lists of stuff aimed at large forums.

    Read more about this resource...
     
  2. Xon

    Xon Well-Known Member

    This addon should help when dealing with forums with very high page counts. It implements one of the suggestions (use a sub-select and only return a list of Ids, then get the full data).

    Was the idea to use something like a 'position' column like the posts table does?

    I was considering that one, but wanted to get something out fast to address some slow-downs that were being experienced.
     
    nrep likes this.
  3. nrep

    nrep Well-Known Member

    Thanks @Xon, I'm trialling it now and will let you know how it goes :). So far, I'm seeing about a 10-15% improvement in loading large forum sections (around 8000 pages - 3.1s down to 2.7s)
     
  4. Xon

    Xon Well-Known Member

    How far back is this? I was only going back ~3600 pages and seeing a rather large improvement but I likely could be done better.
     
  5. nrep

    nrep Well-Known Member

    That was right at the end of the 8000 pages, but I saw a similar improvement when I tested a handful of mid-range pages (4000ish).
     
  6. Xon

    Xon Well-Known Member

  7. lazy llama

    lazy llama Well-Known Member

    Looks good, made a vast improvement on my test system, from 7 seconds to under a quarter of a second picking a page out of 5600 in one forum.
    We also have a conversation with 174,000+ replies, so this should help with that too.
     
    Xon likes this.
  8. Xon

    Xon Well-Known Member

    That is a lot of messages in a conversation!
     
    Last edited: Aug 14, 2015
    lazy llama likes this.
  9. HWS

    HWS Well-Known Member

    If 174.000 people take part in that conversation, only 1 message per participant is needed. :D :cool:
     
  10. lazy llama

    lazy llama Well-Known Member

    I think we'd need a different sort of addon for 174,000 participants in one conversation!
    Think of all those notifications.... and that sidebar listing participants might go on a bit.
     
    Xon likes this.
  11. Wesker

    Wesker Active Member

    This works in 1.3?
     
  12. Xon

    Xon Well-Known Member

    It should, as there hasn't been any major structural changes to the code it modifies for quite some time.

    If it fails, it should log the error and fall back to the standard XenForo code.

    But as always I recommend you test.
     
  13. Xon

    Xon Well-Known Member

    Xon updated Optimized List Queries by Xon with a new update entry:

    Optimize "Members Online" sidebar

    Read the rest of this update entry...
     
    eva2000 likes this.
  14. Xon

    Xon Well-Known Member

    eva2000 likes this.
  15. RoldanLT

    RoldanLT Well-Known Member

    Will this work for Online List created on BD Widget?
     
  16. Xon

    Xon Well-Known Member

    It doesn't. But you should be able to configure the BD Widget to caching for 30 seconds to a minute or so.

    I hooked at a very high level to avoid altering the other functionality which uses the same backend of 'members online' list.
     
  17. RoldanLT

    RoldanLT Well-Known Member

    Sadly some widgets like Online List don't have caching feature or option.
    [​IMG]
     
  18. RoldanLT

    RoldanLT Well-Known Member

    OK, I use the default XenForo Online list template now to take advantage of your addon :)
    [​IMG]
     
    Xon likes this.
  19. Xon

    Xon Well-Known Member

    Just keep in mind the list of members which shows up as 'online' is massively reduced since it only shows staff & people being followed. The totals are still correct.
     
    RoldanLT likes this.
  20. RoldanLT

    RoldanLT Well-Known Member

    By the way, this addon really drop my home timing with debug mode enabled.
    From 0.3xxx now 0.17xxx :D
     
    Xon and eva2000 like this.

Share This Page