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
- 25,734
- Points
- 823
I have a site that is pretty heavily modified and definitely has a lot of attachments. Does anyone know what might be running this query? It could be an add-on as well. I'm looking to speed it up, the query can take upwards of 45 seconds sometimes.
Code:
Read more
Continue reading...
Code:
EXPLAIN SELECT xf_attachment.attachment_id, xf_attachment.content_type, xf_attachment.content_id, xf_attachment_data.data_id FROM xf_attachment INNER JOIN xf_attachment_data ON xf_attachment_data.data_id = xf_attachment.data_id INNER JOIN...Read more
Continue reading...