|
Wednesday 02 August 2006 6:56:46 am
Hi ez, I'm trying to update my 3.7.x to 3.8.3. It took me about 6 hours running scripts but now it's done. Last time i tried with 3.8.0 it was more than 1day so it's better now. My database is big, the tgz dump is 150MB. With 3.7 every thing was working, i had a maximum of 6 seconds without cache and really fast when compiled. Now i have a serious performance problem: When the cache is empty times are ridiculous, about 74 seconds. When in the same siteaccess i go to another page i got 9.6 secconds and that times are with the english siteaccess, which is faster than any other. During that 70 or more secconds the only thing the server is doing is mysql querys, tons of them:
Total script time: 73.4326 sec
Mysql Total
Mysql_queries 57.0676 sec 77.7142% 596 0.0958 sec
Looping result 0.0670 sec 0.0913% 592 0.0001 sec
My site is multilingual, but it wasn´t a problem before. Am I missing something? some setting?
I followed steps for upgrading from http://ez.no/download/ez_publish/changelogs/ez_publish_3_8/upgrading If you need one of the querys here is an example:
Notice: eZMySQLDB::query(15 rows, 6,703.989 ms) query number per page:31 Aug 02 2006 15:25:10
SELECT ezcontentobject.*,
ezcontentobject_tree.*,
ezcontentclass.name as class_name,
ezcontentclass.identifier as class_identifier
, ezcontentobject_name.name as name, ezcontentobject_name.real_translation
FROM
ezcontentobject_tree,
ezcontentobject,ezcontentclass
, ezcontentobject_name
WHERE
path_string like '/1/2/1295/%' and depth = 3 and
ezcontentclass.version=0 AND
ezcontentobject_tree.contentobject_id = ezcontentobject.id AND
ezcontentclass.id = ezcontentobject.contentclass_id AND
ezcontentobject_tree.contentobject_id = ezcontentobject_name.contentobject_id and
ezcontentobject_tree.contentobject_version = ezcontentobject_name.content_version and
( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 16 ) >> 3 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 8 ) >> 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 256 ) >> 5 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 128 ) >> 3 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 64 ) >> 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 32 ) << 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 4 ) << 5 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) << 7 )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 16 ) >> 3 )
+ ( ( ezcontentobject_name.language_id & 8 ) >> 1 )
+ ( ( ezcontentobject_name.language_id & 256 ) >> 5 )
+ ( ( ezcontentobject_name.language_id & 128 ) >> 3 )
+ ( ( ezcontentobject_name.language_id & 64 ) >> 1 )
+ ( ( ezcontentobject_name.language_id & 32 ) << 1 )
+ ( ( ezcontentobject_name.language_id & 4 ) << 5 )
+ ( ( ezcontentobject_name.language_id & 2 ) << 7 )
)
AND ezcontentobject_tree.is_invisible = 0
AND
ezcontentobject.language_mask & 511 > 0
ORDER BY ezcontentobject_tree.priority DESC
LIMIT 0, 15
Thanks
Luis
|