ez 3.8.3 really slow

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