[SLOW_QUERIES] Query of 50000 lines

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)