E

Slow running query?

  • Thread starter Thread starter ekool
  • Start date Start date

Visitor Greeting

Welcome to NullWarehouse.com... We are currently seeking Mod's and Contributors. If you wish to apply for a Mod position then please click on Members dropdown arrow, then click on Staff App and fill it out completely and submit it. If you want to be a Contributor then start contributing and we will have our eye on you and take notice, something great could come of it.

  • We have redone the forum. If you notice any issues or errors please open a Support Ticket under the Members dropdown and let us know.
E

ekool

Guest

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:
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...
 
Similar content Most view View more
Back
Top Bottom