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