ENXF NET
Administrator
Staff member
Administrator
Moderator
+Lifetime VIP+
S.V.I.P.S Member
S.V.I.P Member
V.I.P Member
Collaborate
Registered
- Joined
- Nov 13, 2018
- Messages
- 28,412
- Points
- 823
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...