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 (
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...
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...