Keyword

Excessive load causes server timout from module

  • Rob Joyce
  • Rob Joyce's Avatar Topic Author
  • Offline
  • New Member
More
11 years 1 month ago #117083 by Rob Joyce
Need help to identify what is causing the generation of this query so that we can eliminate it.
It is causing our site to timeout under times of heavy usage.

SELECT DISTINCT i . * , c.name AS categoryname, c.id AS categoryid, c.alias AS categoryalias, c.params AS categoryparams
FROM esqt7_k2_items AS i
LEFT JOIN esqt7_k2_categories AS c ON c.id = i.catid
WHERE i.published =1
AND i.access
IN ( 1, 1 )
AND i.trash =0
AND c.published =1
AND c.access
IN ( 1, 1 )
AND c.trash =0
AND (
i.publish_up = '0000-00-00 00:00:00'
OR i.publish_up <= '2013-08-13 13:04:12'
)
AND (
i.publish_down = '0000-00-00 00:00:00'
OR i.publish_down >= '2013-08-13 13:04:12'
)
AND i.catid
IN ( 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14 )
ORDER BY i.id DESC
LIMIT 0 , 10

Please Log in or Create an account to join the conversation.

More
11 years 1 month ago #117084 by FidelGonzales
Replied by FidelGonzales on topic Re: Excessive load causes server timout from module
I am not certain what is causing the issue. Additional information would be helpful.

This appears to be a category page, correct?

It is possible that there is one item that is causing the issue. Though, unlikely, it could be that it is not checked in or perhaps some code included in the content output.

Please Log in or Create an account to join the conversation.


Powered by Kunena Forum