Optimized List Queries by Xon 1.4.3

[TDUBS]

This plugin causes Members Online Now to only display Staff, rather than all members online. I disabled all of my plugins and enabled them 1 by 1 and figured out this was the culprit.

 

[rdn]

This plugin causes Members Online Now to only display Staff, rather than all members online. I disabled all of my plugins and enabled them 1 by 1 and figured out this was the culprit.

Yes and that is intended.

 

[TDUBS]

Yes and that is intended.

It wasn't like that until I updated the addon last night.

 

[rdn]

It wasn't like that until I updated the addon last night.

Yes it is intended on the last update.

 

[TDUBS]

Yes it is intended on the last update.

Any way I can change this?

 

[Xon]

Any way I can change this?

Not yet, I'll make that configurable as it only really applies once you hit thousands of users online at once.

 

[Xon]

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

Bugfix release

• Make new "Members Online" behaviour optional (on befault).
• Properly include the viewer into the list of users if they do not have the 'bypass privacy' permission

Read the rest of this update entry...

 

[rdn]

Should be "Optimized List Queries by Xon 1.1.1" right?

 

[rdn]

as it only really applies once you hit thousands of users online at once.

Members only? As I get 900-1300 including guest.

 

[Xon]

Note; converting the xf_session_activity table from MEMORY to InnoDB is likely a good idea if you want to use the Members Online query tuning.

Should be "Optimized List Queries by Xon 1.1.1" right?

I typed the update post.

Members only? As I get 900-1300 including guest.

That number includes guests. Each page request to the forum index pulls all the session activity records which can include guest/robot records. My rough testing is about a 20-30% performance boost on the index page. when in debug mode.

It is up to you to decide if showing a list of users the viewer likely has no idea about is worth the performance hit.

 

[Xon]

My forum which I have just moved to xenforo 1.4.6 from vbulletin is also having issues several times per day with the xf_session_activity table locking and causing the site to come to a standstill. Unfortunately haven't managed to resolve the issue yet, we've now tried changing this to innodb table instead of memory. Our site only has around 600 current users on at any one time.

Looks like this is a major issue for popular forums running xenforo.

fyi, but you may be interested in the Members Online functionality changes I've done in the latest versions of this add-on.

This makes a measurable difference with 1000-2000 members/guests online, and in artificial testing a large significant difference with ~6k users online.

 

[rdn]

Note; converting the xf_session_activity table from MEMORY to InnoDB is likely a good idea if you want to use the Members Online query tuning.

I have mine set to InnoDB already I think for more than a year now .

 

[TDUBS]

This plugin causes Members Online Now to only display Staff, rather than all members online. I disabled all of my plugins and enabled them 1 by 1 and figured out this was the culprit.

I'm not 100% sure if this is caused by the plugin since I know you added an option for it and it essentially fixed the above problem. However, once I updated my theme, this problem returned. I'm in contact with the theme author but I wanted to bring it to your attention in case something happened where the option you created to disable it no longer works. @Xon

 

[Xon]

I'm not 100% sure if this is caused by the plugin since I know you added an option for it and it essentially fixed the above problem. However, once I updated my theme, this problem returned. I'm in contact with the theme author but I wanted to bring it to your attention in case something happened where the option you created to disable it no longer works. @Xon

There is an option to disable the code-path which causes this, as I don't have plans to support this functionality in the near future.

 

[Xon]

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

Feature update release

Implement node-list caching. This helps forums with a large list of nodes which change rarely.

Options:

• Cache root node, or all nodes.
• Caching length for guests (default 300 seconds, 0 to disable).
• Caching length for members (default 0seconds, 0 to disable).

Requires XenForo caching such as Memcache or Redis to be setup.

Read the rest of this update entry...

 

[popr]

Will this work with xcache?

 

[Xon]

Will this work with xcache?

It just needs a caching system set up with XenForo.

Technically you could use a file-based caching system, but I strongly don't recommend that.

 

[popr]

It just needs a caching system set up with XenForo.

Technically you could use a file-based caching system, but I strongly don't recommend that.

Xcache does have a data cache. Will it or won't it work with it?

 

[Xon]

Xcache does have a data cache. Will it or won't it work with it?

It should, but I haven't tested it.

 

[Xon]

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

Feature update release

• Improve Likes Received query on large page numbers.

Read the rest of this update entry...