Missing Index on addon_id columns which slows down WHERE and JOIN queries

[Painbaker]

Many core XenForo tables contain an addon_id column but do not have an index.
This column is commonly used in JOIN queries or WHERE conditions ( with('AddOn') or whereAddOnActive() ), leading to inefficient full table scans on large installations.

I believe the lack of indexes in addon_id may be intentional to reduce the load on small forums, however this can lead to noticeable performance issues in large installations or when performing frequent operations with add-ons.

Even...

Read more

Continue reading...