Optimized List Queries by Xon 2.12.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.