Optimized List Queries by Xon 2.13.0

[MentaL]

Does this addon support MariaDB 10.11.8?
Using the slow query logger, this addon appears most of the time, especially on the forum_view listing.

Mdb is just a drop in replacement so it should work unless there's some version changes that depreciated some stuff

 

[Xon]

It should work fine with later mariadb versions, the tricky part is sometimes the rewritten queries may be slower or not depending on how much data is required to be touched.

Even with this disabled you might still find forum_view listings are unexpectedly slow

 

[rdn]

It should work fine with later mariadb versions, the tricky part is sometimes the rewritten queries may be slower or not depending on how much data is required to be touched.

Even with this disabled you might still find forum_view listings are unexpectedly slow

Reducing the thread list to something like 30 will help?

My current discussions per page is set to 50 right now.

 

[arn]

Found a bug in this addon and Xenforo Media Gallery 2.3.8.

A user noticed different people's uploads in their profile's media gallery.

I was able to replicate this on my dev site. I found a strange query (attached). Turned off all add-ons. Turned only XFMG back on. Strange query gone. No further weirdness in the profile. I turned back on Standard Library and Optimized List Queries only, and the problem came back.

I just turned off Optimized List Queries on production and it fixed the issue.

 

[Xon]

I just turned off Optimized List Queries on production and it fixed the issue.

Please set the Better XFMG Album List Page Threshold and Better XFMG Album List Page Threshold options to to the value of -1 to disable that part.

@arn Can you open a ticket on my site? I'll need to get some query samples before/after the add-on is enabled to understand how the query is being mutated.

 

[Xon]

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

2.13.0 - Bugfix & Maintainance update

• Require StandardLib v1.23.0+
• Only post sort usage patch on old enough XF version
• Improve XFMG v2.3+ compatibility

Read the rest of this update entry...

 

[Xon]

I just turned off Optimized List Queries on production and it fixed the issue.

This ended up being an issue with StandardLib, but updating that add-on or this add-on to the latest will fix the issue.