|
Friday 03 February 2006 2:43:32 am
Hello everybody, I have a big problem with a site (arround 40 000objects). In fact, sometime, ezpublish generate big query. The result of this big query is that the server down. I'm looking for the reasons of this request but I don't find the source of this problem. Here, an extract of the slow queries
# Query_time: 113 Lock_time: 1 Rows_sent: 19532 Rows_examined: 78128
SELECT ezcontentobject_attribute.*, ezcontentclass_attribute.identifier as identifier FROM
ezcontentobject_attribute, ezcontentclass_attribute
WHERE
ezcontentclass_attribute.version = '0' AND
ezcontentclass_attribute.id = ezcontentobject_attribute.contentclassattribute_id AND
( ( ezcontentobject_attribute.version = '7' AND
ezcontentobject_attribute.contentobject_id = '15249' AND
ezcontentobject_attribute.language_code = 'fre-FR' ) OR ( ezcontentobject_attribute.version = '1' AND
....
50000 lins after
...
ezcontentobject_attribute.language_code = 'fre-FR' ) OR ( ezcontentobject_attribute.version = '1' AND
ezcontentobject_attribute.contentobject_id = '45527' AND
ezcontentobject_attribute.language_code = 'fre-FR' ) OR ( ezcontentobject_attribute.version = '1' AND
ezcontentobject_attribute.contentobject_id = '45642' AND
ezcontentobject_attribute.language_code = 'fre-FR' ) )
ORDER BY
ezcontentobject_attribute.contentobject_id, ezcontentclass_attribute.placement ASC;
I must say you that these objects are stocked in the same parent node.
And, I tried, to find the bug, doing a fetch(all) on this node but the fetch don't create a such query.
So, I don't understand where this big query is created. Thank you for your help Sébastien
--
eZ c'est plus fort que toi !
http://www.ez-france.org
http://blog.plopix.net
@Novactive (http://www.novactive.com)
|