eZ publish performance

Friday 09 December 2005 12:41:56 pm

If you were to remove everything but {$module_result.content} from the pagelayout how does it perform?

Monday 12 December 2005 1:02:20 am

Hi Paul,

These are the results when re-loading a cached page with just {$module_result.content} in pagelayout:

Notice: eZMySQLDB::query(1 rows, 0.546 ms) query number per page:0  	Dec 12 2005 08:58:01

SELECT data, user_id, expiration_time FROM ezsession WHERE session_key='b39da792ad6326e7fd80199c60989c73'

Notice: eZMySQLDB::query(0 rows, 0.532 ms) query number per page:1 	Dec 12 2005 08:58:01

SELECT contentobject_id, login, email, password_hash, password_hash_type
FROM   ezuser
WHERE  contentobject_id='0'

Notice: eZMySQLDB::query(0 rows, 0.389 ms) query number per page:2 	Dec 12 2005 08:58:01

SELECT contentobject_id, login, email, password_hash, password_hash_type
FROM   ezuser
WHERE  contentobject_id='0'

Timing: 	Dec 12 2005 08:58:01

Module start 'content'

Notice: eZMySQLDB::query(0 rows, 0.617 ms) query number per page:3 	Dec 12 2005 08:58:01

SELECT limit_value
                                          FROM ezuser_role
                                          WHERE contentobject_id = 617

Timing: 	Dec 12 2005 08:58:01

Module end 'content'

Timing: 	Dec 12 2005 08:58:01

End

Timing points:
Checkpoint	Elapsed	Rel. Elapsed	Memory	Rel. Memory
Module start 'content'	0.0000 sec	-511.9550 sec	0.0000KB	0.0000KB
Module end 'content'	-511.9550 sec	0.0536 sec	0.0000KB	0.0000KB
End	-511.9015 sec	 	0.0000KB	0.0000KB
Total runtime:	-511.8391 sec	
Time accumulators:
 Accumulator	 Elapsed	 Percent	 Count	 Average
ini_load				
Load cache	0.0743 sec	25.3635%	10	0.0074 sec
Mysql Total				
Mysql_queries	0.0096 sec	3.2681%	4	0.0024 sec
Looping result	0.0001 sec	0.0321%	1	0.0001 sec
Template Total	0.1008 sec	34.4%	2	0.0504 sec
Template load	0.0443 sec	15.1032%	2	0.0221 sec
Template processing	-511.9441 sec	-174,716.0113%	2	-255.9721 sec
override				
Cache load	0.0324 sec	11.0468%	2	0.0162 sec
Total script time:	0.2930 sec	

We still have siginificant template load time. We have put some switching inside some of the full view templates and I'm wondering if this is causing this aspect... Is it possible to continue caching niside templates?

Hi Gabriel,

Yes, I agree there are some dodgy figures being generated here - but we do perceive poor performance times.... have been ignoring the ridiculous ones, but sql totals seems OK.

Cheers, Steve.

http://www.oneworldmarket.co.uk

Monday 12 December 2005 1:47:31 am

Guys, what do you think about excluding Steve problem in to new topic? Idea of "eZ publish performance" was for presenting results on different hardware configurations. We have now few topics in one topic.

Steve?

Personal website -> http://serwatka.net
Blog (about eZ Publish) -> http://serwatka.net/blog

Thursday 28 August 2008 5:43:35 am

I would like to use eZ Components Cache to cache the sessions and the settings. Someone has already tried it?