Details
-
Bug
-
Resolution: Fixed
-
Medium
-
3.8.6
-
None
-
Operating System:redhat
Apache 10337100
PHP Version: 4.4.4
Database and version: Mysql 4.1.22
Description
We have 400000 object and more than 4M lines in the table ezcontentobject_attribute
When we try to edit an article or any object with an image attribute, the system didn't reponse anything.
In the log file notice.log
ez try to fetch data on the ezcontentobject_attribute :
[ Jan 30 2007 23:06:37 ] [82.226.216.49] eZMySQLDB::query(2 rows, 10,976.943 ms) query number per page:14: EXPLAIN SELECT id, version FROM ezcontentobject_attribute WHERE data_type_string = 'ezimage' and data_text like '%url="var/premiere/storage/images/jeux/quizz-la-mome/4171905-4-fre-FR/quizz_la_mome.png"%'
This query take 12s.
the query didn't use any index