eZ publish performance

Author Message

Łukasz Serwatka

Wednesday 18 May 2005 5:25:08 am

Hi Guys,

I tested a little eZ publish performance on Windows XP Professional and here are my results:

Hardware
CPU: Athlon XP 3200+ (Burton) ~2195 MHz
Memory: 1 GB (2x 512MB dual channel)
Hard disk: IDE ATA 133

PHP 4.3.11 (DOM XML, MB STRING), Apache 1.3.33 (mod_php), MySQL 4.1.11, eAccelerator 0.9.2a

"First run" time test (empty var/cache, var/plain/cache dirs ):

eZ publish 3.5.2 "Plain" installation (english language) with all installed additional packages:

Time accumulators:
 Accumulator	 Elapsed	 Percent	 Count	 Average
ini_load				
Load cache	0.2499 sec	2.9907%	16	0.0156 sec
Mysql Total				
Mysql_queries	0.1191 sec	1.4253%	40	0.0030 sec
Looping result	0.0056 sec	0.0665%	39	0.0001 sec
Template Total	8.1402 sec	97.4%	2	4.0701 sec
Template load	2.5195 sec	30.1549%	2	1.2597 sec
Template parser: create text elements	0.1627 sec	1.9475%	155	0.0010 sec
Template parser: remove whitespace	0.0430 sec	0.5144%	155	0.0003 sec
Template parser: construct tree	0.8273 sec	9.9018%	155	0.0053 sec
Template load and register function	0.0048 sec	0.0576%	9	0.0005 sec
Template processing	5.6203 sec	67.2677%	2	2.8101 sec
override				
Cache load	0.2537 sec	3.0369%	26	0.0098 sec
Matching rules	0.0021 sec	0.0246%	4	0.0005 sec
Sytem overhead				
Fetch class attribute name	0.0000 sec	0.0000%	0	0.0000 sec
class_abstraction				
Instantiating content class attribute	0.0005 sec	0.0056%	10	0.0000 sec
XML				
Image XML parsing	0.0006 sec	0.0071%	1	0.0006 sec
General				
INI string conversion	0.0099 sec	0.1185%	42	0.0002 sec
String conversion	0.0072 sec	0.0864%	46	0.0002 sec
String conversion w/ mbstring	0.0032 sec	0.0379%	46	0.0001 sec
Total script time:	8.3551 sec	

On default eZ publish configuration with compiled templates and cached content was:

Time accumulators:
 Accumulator	 Elapsed	 Percent	 Count	 Average
ini_load				
Load cache	0.0223 sec	18.3677%	10	0.0022 sec
Mysql Total				
Mysql_queries	0.0010 sec	0.8183%	1	0.0010 sec
Looping result	0.0000 sec	0.0410%	1	0.0000 sec
Template Total	0.0473 sec	38.9%	1	0.0473 sec
Template load	0.0127 sec	10.4802%	1	0.0127 sec
Template processing	0.0342 sec	28.1551%	1	0.0342 sec
override				
Cache load	0.0091 sec	7.4591%	1	0.0091 sec
Total script time:	0.1216 sec	

I would like to compare this results to your hardware/software configuration.

What are your results?

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

Bård Farstad

Wednesday 18 May 2005 5:57:41 am

Dell M60 Laptop
1.8GHz Centrino
1GB RAM
Running Mandriva Linux, PHP 4.3.7 and Apache 1.3 compiled statically.
APC PHP Accelerator running.

Here are my results:
First page run:

Timing points:
Checkpoint
Elapsed
Rel. Elapsed
Memory
Rel. Memory
Script start  0.0000 sec  0.1175 sec  245.3906KB  193.2578KB
  Module start 'content'  0.1175 sec  3.8576 sec  438.6484KB  6,502.5859KB
  Module end 'content'  3.9751 sec  1.2076 sec  6,941.2344KB  1,228.6250KB
  End  5.1826 sec     8,169.8594KB  0.0010KB
  Total runtime:  5.1828 sec
  Time accumulators:
 Accumulator
 Elapsed
 Percent
 Count
 Average
ini_load
  Load cache  0.2237 sec  4.3061%  16  0.0140 sec
  Mysql Total
  Mysql_queries  0.0851 sec  1.6386%  55  0.0015 sec
  Looping result  0.0058 sec  0.1117%  50  0.0001 sec
  Template Total  4.9431 sec   95.2%   2   2.4715 sec
  Template load  1.5908 sec  30.6245%  2  0.7954 sec
  Template parser: create text elements  0.1598 sec  3.0761%  155  0.0010 sec
  Template parser: remove whitespace  0.0651 sec  1.2535%  155  0.0004 sec
  Template parser: construct tree  0.9263 sec  17.8320%  155  0.0060 sec
  Template load and register function  0.0513 sec  0.9884%  9  0.0057 sec
  Template processing  3.3517 sec  64.5243%  2  1.6758 sec
  override
  Cache load  0.1763 sec  3.3934%  26  0.0068 sec
  Matching rules  0.0015 sec  0.0284%  4  0.0004 sec
  Sytem overhead
  Fetch class attribute name  0.0000 sec  0.0000%  0  0.0000 sec
  class_abstraction
  Instantiating content class attribute  0.0005 sec  0.0103%  10  0.0001 sec
  XML
  Image XML parsing  0.0036 sec  0.0696%  1  0.0036 sec
  General
  INI string conversion  0.0056 sec  0.1087%  21  0.0003 sec
  String conversion  0.0046 sec  0.0889%  26  0.0002 sec
  String conversion w/ mbstring  0.0019 sec  0.0359%  26  0.0001 sec
  Total script time:  5.1945 sec

With compiled templates and cache for rendering frontpage:

Timing points:
Checkpoint
Elapsed
Rel. Elapsed
Memory
Rel. Memory
Script start  0.0000 sec  0.0169 sec  199.6719KB  342.5000KB
  Module start 'content'  0.0169 sec  0.0079 sec  542.1719KB  139.5469KB
  Module end 'content'  0.0247 sec  0.0235 sec  681.7188KB  361.6797KB
  End  0.0482 sec     1,043.3984KB  0.3532KB
  Total runtime:  0.0484 sec
  Time accumulators:
 Accumulator
 Elapsed
 Percent
 Count
 Average
ini_load
  Load cache  0.0102 sec  20.3605%  10  0.0010 sec
  Mysql Total
  Mysql_queries  0.0003 sec  0.5145%  1  0.0003 sec
  Looping result  0.0000 sec  0.0983%  1  0.0000 sec
  Template Total  0.0210 sec   42.0%   1   0.0210 sec
  Template load  0.0057 sec  11.3413%  1  0.0057 sec
  Template processing  0.0151 sec  30.1585%  1  0.0151 sec
  override
  Cache load  0.0042 sec  8.4928%  1  0.0042 sec
  Total script time:  0.0500 sec

--bård

Hans Melis

Wednesday 18 May 2005 8:50:17 am

CPU: Intel PIII 1 GHz
Memory: 256MB (SDRAM)
HD: IDE ATA100
OS: Gentoo Linux
Server: Apache/2.0.52 PHP/4.3.11 (extension list quite long) MySQL 4.0.24 eAccelerator 0.9.2a

First page run:

Timing points:
Checkpoint	Elapsed	Rel. Elapsed	Memory	Rel. Memory
Script start	0.0000 sec	0.1756 sec	0.0000KB	0.0000KB
Module start 'content'	0.1756 sec	6.9470 sec	0.0000KB	0.0000KB
Module end 'content'	7.1227 sec	2.5621 sec	0.0000KB	0.0000KB
End	9.6848 sec	 	0.0000KB	0.0000KB
Total runtime:	9.6852 sec	
Time accumulators:
 Accumulator	 Elapsed	 Percent	 Count	 Average
ini_load				
Load cache	0.3645 sec	3.7619%	16	0.0228 sec
Mysql Total				
Mysql_queries	0.0820 sec	0.8459%	40	0.0020 sec
Looping result	0.0114 sec	0.1179%	39	0.0003 sec
Template Total	9.4191 sec	97.2%	2	4.7095 sec
Template load	2.6232 sec	27.0751%	2	1.3116 sec
Template parser: create text elements	0.3400 sec	3.5094%	155	0.0022 sec
Template parser: remove whitespace	0.1083 sec	1.1176%	155	0.0007 sec
Template parser: construct tree	1.5329 sec	15.8214%	155	0.0099 sec
Template load and register function	0.0036 sec	0.0369%	9	0.0004 sec
Template processing	6.7946 sec	70.1297%	2	3.3973 sec
override				
Cache load	0.2458 sec	2.5365%	26	0.0095 sec
Matching rules	0.0027 sec	0.0278%	4	0.0007 sec
Sytem overhead				
Fetch class attribute name	0.0000 sec	0.0000%	0	0.0000 sec
class_abstraction				
Instantiating content class attribute	0.0011 sec	0.0115%	10	0.0001 sec
XML				
Image XML parsing	0.0013 sec	0.0132%	1	0.0013 sec
General				
INI string conversion	0.0194 sec	0.2002%	42	0.0005 sec
String conversion	0.0135 sec	0.1392%	46	0.0003 sec
String conversion w/ mbstring	0.0047 sec	0.0484%	46	0.0001 sec
Total script time:	9.6886 sec	

With compile & caching:

Timing points:
Checkpoint	Elapsed	Rel. Elapsed	Memory	Rel. Memory
Script start	0.0000 sec	0.0415 sec	0.0000KB	0.0000KB
Module start 'content'	0.0415 sec	0.0159 sec	0.0000KB	0.0000KB
Module end 'content'	0.0573 sec	0.0674 sec	0.0000KB	0.0000KB
End	0.1248 sec	 	0.0000KB	0.0000KB
Total runtime:	0.1251 sec	
Time accumulators:
 Accumulator	 Elapsed	 Percent	 Count	 Average
ini_load				
Load cache	0.0322 sec	25.1437%	10	0.0032 sec
Mysql Total				
Mysql_queries	0.0005 sec	0.4277%	1	0.0005 sec
Looping result	0.0001 sec	0.0780%	1	0.0001 sec
Template Total	0.0625 sec	48.8%	1	0.0625 sec
Template load	0.0206 sec	16.0515%	1	0.0206 sec
Template processing	0.0413 sec	32.2558%	1	0.0413 sec
override				
Cache load	0.0172 sec	13.3989%	1	0.0172 sec
Total script time:	0.1281 sec		

Not bad for some old hardware :)

Hans
http://blog.hansmelis.be

bisk

Wednesday 18 May 2005 1:29:28 pm

Hardware: 2x Xeon 3GHz/3GB/2x73GB (PERC RAID-1)
Load average: 0.22, 0.10, 0.07
Server software: Apache/2.0.46 (CentOS), php 4.3.11 (dom xml, mb string), mysql 4.0.23, ez publish 3.5.1, no accelerator.

First run, same ez setup as Lukasz.

Time accumulators:
 Accumulator	 Elapsed	 Percent	 Count	 Average
ini_load				
Load cache	0.1613 sec	2.1999%	13	0.0124 sec
Mysql Total				
Mysql_queries	0.0355 sec	0.4844%	44	0.0008 sec
Looping result	0.0056 sec	0.0759%	39	0.0001 sec
Template Total	7.0536 sec	96.2%	2	3.5268 sec
Template load	2.5803 sec	35.1945%	2	1.2901 sec
Template parser: create text elements	0.1590 sec	2.1685%	155	0.0010 sec
Template parser: remove whitespace	0.0490 sec	0.6678%	155	0.0003 sec
Template parser: construct tree	0.7202 sec	9.8231%	155	0.0046 sec
Template load and register function	0.0199 sec	0.2715%	9	0.0022 sec
Template processing	4.4727 sec	61.0076%	2	2.2364 sec
override				
Cache load	0.2530 sec	3.4508%	26	0.0097 sec
Matching rules	0.0016 sec	0.0220%	4	0.0004 sec
Sytem overhead				
Fetch class attribute name	0.0000 sec	0.0000%	0	0.0000 sec
class_abstraction				
Instantiating content class attribute	0.0006 sec	0.0082%	10	0.0001 sec
XML				
Image XML parsing	0.0007 sec	0.0100%	1	0.0007 sec
General				
INI string conversion	0.0057 sec	0.0779%	21	0.0003 sec
String conversion	0.0086 sec	0.1171%	44	0.0002 sec
String conversion w/ mbstring	0.0032 sec	0.0434%	44	0.0001 sec
Total script time:	7.3315 sec

compiled/cached

Time accumulators:
 Accumulator	 Elapsed	 Percent	 Count	 Average
ini_load				
Load cache	0.0243 sec	9.6100%	7	0.0035 sec
Mysql Total				
Mysql_queries	0.0003 sec	0.1121%	1	0.0003 sec
Looping result	0.0001 sec	0.0241%	1	0.0001 sec
Template Total	0.0820 sec	32.3%	1	0.0820 sec
Template load	0.0217 sec	8.5751%	1	0.0217 sec
Template processing	0.0599 sec	23.6462%	1	0.0599 sec
override				
Cache load	0.0155 sec	6.1048%	1	0.0155 sec
Total script time:	0.2534 sec	

-------------------------------
http://www.kookfijn.nl & http://www.magento.be

Łukasz Serwatka

Thursday 19 May 2005 3:07:11 am

WOW, Hans your CPU speed is a half less then mine, are you sure that you have one CPU? ;)

Any other eZ publish test results? We have Windows and Linux, maybe some Mac Os users can present their results?

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

Hans Melis

Thursday 19 May 2005 5:46:49 am

Lukasz,

I can post /proc/cpuinfo for you ;-)

It's quite normal though. Gentoo Linux compiles everything from source, which makes the old machine quite fast. It also beats my actual PC[1] (only slightly, but the linux box is 0.2s faster) which is filled with a lot of programs and a lot of fragmentation. And Windows is a very slow OS too.

[1]: P4 3GHz, 1GB RAM, WinXP

Hans
http://blog.hansmelis.be

Kristian Hole

Monday 06 June 2005 7:34:46 am

I did a small test during the eZ camp using eZ publish 3.6.0.

First load:

on linux:

uname -a:
Linux localhost 2.6.8.1-12mdk #1 Fri Oct 1 12:53:41 CEST 2004 i686 Intel(R) Pentium(R) M processor 1300MHz unknown GNU/Linux

Setup:

Site: 127.0.0.1/ezpublish-3.6.0/index.php
Version: 3.6.0 (3.6.0)
SVN revision: 11973
Extensions: Not in use.
PHP
Version: 4.3.8
Extensions: yp, sysvshm, sysvsem, standard, session, posix, pcre, gettext, ftp, ctype, zlib, openssl, apache, mbstring, mysql, Turck MMCache
Miscellaneous: Safe mode is off.
Basedir restriction is off.
Global variable registration is off.
File uploading is enabled.
Maximum size of post data (text and files) is 8M.
Script memory limit is 48M.
Maximum execution time is 120 seconds.
PHP Accelerator
Name:Turck MMCache
Version: Version information could not be detected.
Status: Enabled.
Webserver (software)
Name: Apache
Version: Apache-AdvancedExtranetServer/1.3.31 (Mandrakelinux/7.1.101mdk) PHP/4.3.8
Modules: The modules of the webserver could not be detected.
Webserver (hardware)
CPU: Intel(R) Pentium(R) M processor 1300MHz 1298.866 MHz
Memory: 503.39 MB
Database
Type: mysql
Server: localhost
Socket path: Not in use.
Database name: plain36
Connection retry count: 0
Character set: iso-8859-1 (Internal)

Result

Timing points:
Checkpoint	Elapsed	Rel. Elapsed	Memory	Rel. Memory
Script start	0.0000 sec	0.0811 sec	234.5391KB	332.7656KB
Module start 'content'	0.0811 sec	1.3620 sec	567.3047KB	2,389.9844KB
Module end 'content'	1.4431 sec	1.2809 sec	2,957.2891KB	1,142.8672KB
End	2.7240 sec	 	4,100.1563KB	0.0010KB
Total runtime:	3.4135 sec	
Time accumulators:
 Accumulator	 Elapsed	 Percent	 Count	 Average
ini_load				
Load cache	0.1820 sec	5.1672%	16	0.0114 sec
Mysql Total				
Mysql_queries	0.0223 sec	0.6331%	26	0.0009 sec
Looping result	0.0030 sec	0.0842%	22	0.0001 sec
Template Total	3.1923 sec	90.6%	3	1.0641 sec
Template load	1.7338 sec	49.2165%	3	0.5779 sec
Template parser: create text elements	0.1253 sec	3.5577%	64	0.0020 sec
Template parser: remove whitespace	0.0459 sec	1.3024%	64	0.0007 sec
Template parser: construct tree	0.6337 sec	17.9883%	64	0.0099 sec
Template load and register function	0.0019 sec	0.0536%	9	0.0002 sec
Template processing	1.4573 sec	41.3681%	3	0.4858 sec
override				
Cache load	0.1200 sec	3.4064%	15	0.0080 sec
Matching rules	0.0014 sec	0.0401%	4	0.0004 sec
Sytem overhead				
Fetch class attribute name	0.0000 sec	0.0000%	0	0.0000 sec
XML				
Image XML parsing	0.0045 sec	0.1269%	1	0.0045 sec
General				
INI string conversion	0.0068 sec	0.1933%	22	0.0003 sec
String conversion	0.0056 sec	0.1575%	27	0.0002 sec
String conversion w/ mbstring	0.0021 sec	0.0599%	27	0.0001 sec
Total script time:	3.5228 sec	

On Windows XP pro (eZ publish windows installer):

Setup:

Site: localhost/ezpublish360/index.php
Version: 3.6.0 (3.6.0)
SVN revision: 11973
Extensions: Not in use.
PHP
Version: 4.3.10
Extensions: standard, bcmath, calendar, ctype, com, ftp, mysql, odbc, overload, pcre, session, tokenizer, xml, wddx, zlib, apache, ldap, mbstring, Turck MMCache
Miscellaneous: Safe mode is off.
Basedir restriction is off.
Global variable registration is off.
File uploading is enabled.
Maximum size of post data (text and files) is 8M.
Script memory limit is Unlimited.
Maximum execution time is 60 seconds.
PHP Accelerator
Name:Turck MMCache
Version: Version information could not be detected.
Status: Enabled.
Webserver (software)
Name: Apache
Version: Apache/1.3.31 (Win32) PHP/4.3.10
Modules: The modules of the webserver could not be detected.
Webserver (hardware)
CPU:
Memory: B
Database
Type: mysql
Server: localhost
Socket path: Not in use.
Database name: plain36
Connection retry count: 0
Character set:

Result:

Timing points:
Checkpoint	Elapsed	Rel. Elapsed	Memory	Rel. Memory
Script start	0.0000 sec	0.2920 sec	0.0000KB	0.0000KB
Module start 'content'	0.2920 sec	2.7408 sec	0.0000KB	0.0000KB
Module end 'content'	3.0328 sec	2.4562 sec	0.0000KB	0.0000KB
End	5.4891 sec	 	0.0000KB	0.0000KB
Total runtime:	6.4327 sec	
Time accumulators:
 Accumulator	 Elapsed	 Percent	 Count	 Average
ini_load				
Load cache	0.1903 sec	2.9348%	16	0.0119 sec
Mysql Total				
Mysql_queries	0.0440 sec	0.6791%	35	0.0013 sec
Looping result	0.0034 sec	0.0525%	30	0.0001 sec
Template Total	5.7619 sec	88.8%	3	1.9206 sec
Template load	3.2294 sec	49.7935%	3	1.0765 sec
Template parser: create text elements	0.1323 sec	2.0394%	64	0.0021 sec
Template parser: remove whitespace	0.0422 sec	0.6510%	64	0.0007 sec
Template parser: construct tree	0.7628 sec	11.7612%	64	0.0119 sec
Template load and register function	0.0405 sec	0.6237%	9	0.0045 sec
Template processing	2.5315 sec	39.0325%	3	0.8438 sec
override				
Cache load	0.2554 sec	3.9382%	15	0.0170 sec
Matching rules	0.0017 sec	0.0257%	4	0.0004 sec
Sytem overhead				
Fetch class attribute name	0.0000 sec	0.0000%	0	0.0000 sec
XML				
Image XML parsing	0.0044 sec	0.0679%	1	0.0044 sec
General				
INI string conversion	0.0071 sec	0.1099%	22	0.0003 sec
String conversion	0.0060 sec	0.0925%	27	0.0002 sec
String conversion w/ mbstring	0.0027 sec	0.0412%	27	0.0001 sec
Total script time:	6.4856 sec	

Kristian

http://ez.no/ez_publish/documenta...tricks/show_which_templates_are_used
http://ez.no/doc/ez_publish/techn...te_operators/miscellaneous/attribute

Mark Marsiglio

Thursday 09 June 2005 9:59:20 am

I just configured a new dual 2.8ghz Xeon/1gb RAM/ATA133 drive with Red Hat Enterprise Linux 4 with the following details:
-eZ Publish 3.6.0 full plain install
-Apache 2.0.52
-MySQL 4.1.10
-PHP 4.3.9
-No accelerator (according to system info)

Site: localhost/index.php
Version: 3.6.0 (3.6.0)
SVN revision: 11973
Extensions: ezpaypal
PHP
Version: 4.3.9
Extensions: yp, xml, wddx, tokenizer, sysvshm, sysvsem, standard, sockets, shmop, session, pspell, posix, pcre, overload, mime_magic, iconv, gmp, gettext, ftp, exif, dio, dbx, dba, curl, ctype, calendar, bz2, bcmath, zlib, openssl, apache2handler, ldap, mysql
Miscellaneous: Safe mode is off.
Basedir restriction is off.
Global variable registration is off.
File uploading is enabled.
Maximum size of post data (text and files) is 8M.
Script memory limit is 42M.
Maximum execution time is 30 seconds.
PHP Accelerator
A known and active PHP accelerator could not be found.
Webserver (software)
Name: Apache
Version: Apache/2.0.52 (Red Hat)
Modules: core, prefork, http_core, mod_so, mod_access, mod_auth, mod_auth_anon, mod_auth_dbm, mod_auth_digest, util_ldap, mod_auth_ldap, mod_include, mod_log_config, mod_env, mod_mime_magic, mod_cern_meta, mod_expires, mod_deflate, mod_headers, mod_usertrack, mod_unique_id, mod_setenvif, mod_mime, mod_dav, mod_status, mod_autoindex, mod_asis, mod_info, mod_dav_fs, mod_vhost_alias, mod_negotiation, mod_dir, mod_imap, mod_actions, mod_speling, mod_userdir, mod_alias, mod_rewrite, mod_proxy, proxy_ftp, proxy_http, proxy_connect, mod_cache, mod_suexec, mod_disk_cache, mod_file_cache, mod_mem_cache, mod_cgi, mod_perl, sapi_apache2, mod_python, mod_ssl
Webserver (hardware)
CPU: Intel(R) Xeon(TM) CPU 2.80GHz 2800.399 MHz
Memory: 1,010.24 MB
Database
Type: mysql
Server: localhost
Socket path: Not in use.
Database name: test
Connection retry count: 0
Character set: iso-8859-1 (Internal)
Timing points:
Checkpoint	Elapsed	Rel. Elapsed	Memory	Rel. Memory
Script start	0.0000 sec	0.1137 sec	1,534.2891KB	4,219.4531KB
Module start 'content'	0.1137 sec	0.4972 sec	5,753.7422KB	3,862.1953KB
Module end 'content'	0.6109 sec	0.0600 sec	9,615.9375KB	776.1406KB
End	0.6709 sec	 	10,392.0781KB	0.7579KB
Total runtime:	0.7164 sec	
Time accumulators:
 Accumulator	 Elapsed	 Percent	 Count	 Average
ini_load				
Load cache	0.0390 sec	5.3974%	14	0.0028 sec
Mysql Total				
Mysql_queries	0.0143 sec	1.9840%	14	0.0010 sec
Looping result	0.0019 sec	0.2635%	13	0.0001 sec
Template Total	0.5440 sec	 75.2%	 3	 0.1813 sec
Template load	0.0259 sec	3.5767%	3	0.0086 sec
Template processing	0.5173 sec	71.5511%	3	0.1724 sec
override				
Cache load	0.0460 sec	6.3688%	27	0.0017 sec
Sytem overhead				
Fetch class attribute name	0.0000 sec	0.0000%	0	0.0000 sec
class_abstraction				
Instantiating content class attribute	0.0007 sec	0.0917%	10	0.0001 sec
General				
String conversion	0.0317 sec	4.3799%	4	0.0079 sec
String conversion w/ codepage reverse	0.0311 sec	4.2950%	4	0.0078 sec
Total script time:	0.7230 sec

I was hoping for a bit better with a dual 2.8 xeon.

http://www.thinkcreative.com
Turning Ideas Into Strategic Solutions

Kristian Hole

Friday 10 June 2005 3:00:50 am

Mark: Always use an accellerator for eZ publish! That will reduce your loadtime significantly..

Kristian

http://ez.no/ez_publish/documenta...tricks/show_which_templates_are_used
http://ez.no/doc/ez_publish/techn...te_operators/miscellaneous/attribute

Norman Leutner

Tuesday 14 June 2005 5:56:38 am

Here is the result on my notebook:

Toshiba M30
Intel Centrino 1,4 Ghz / 512 MB RAM
Windows XP

Site:
 localhost:50 
Version:
 3.6.0 (3.6.0) 
SVN revision:
 11973 
Extensions:
 Not in use.  
PHP 
Version:
 4.3.8 
Extensions:
 standard, bcmath, calendar, ctype, com, ftp, mysql, odbc, overload, pcre, session, tokenizer, xml, wddx, zlib, apache, gd, mbstring, eAccelerator, Zend Optimizer 
Miscellaneous:
 Safe mode is off.
Basedir restriction is off.
Global variable registration is off.
File uploading is enabled.
Maximum size of post data (text and files) is 8M.
Script memory limit is Unlimited.
Maximum execution time is 600 seconds.
 
PHP Accelerator 
Name:
eAccelerator
Version:
 0.9.2 
Status:
 Enabled.  
Webserver (software) 
Name:
 Apache 
Version:
 Apache/1.3.31 (Win32) mod_ssl/2.8.18 OpenSSL/0.9.7d PHP/4.3.9 
Modules:
 The modules of the webserver could not be detected.  
Webserver (hardware) 
CPU:
 
Memory:
 B  
Database 
Type:
 mysql 
Server:
 localhost 
Socket path:
 Not in use. 
Database name:
 ezp360 
Connection retry count:
 0 
Character set:
 iso-8859-1 (Internal) 

timing points:

Timing points:
Checkpoint Elapsed Rel. Elapsed Memory Rel. Memory 
Script start 0.0000 sec 0.0783 sec 0.0000KB 0.0000KB 
Module start 'content' 0.0783 sec 2.3395 sec 0.0000KB 0.0000KB 
Module end 'content' 2.4178 sec 2.2741 sec 0.0000KB 0.0000KB 
End 4.6918 sec   0.0000KB 0.0000KB 
Total runtime: 5.5529 sec  

Time accumulators:
 Accumulator  Elapsed  Percent  Count  Average 
ini_load     
Load cache 0.2304 sec 4.1450% 16 0.0144 sec 
Mysql Total     
Mysql_queries 0.0319 sec 0.5733% 26 0.0012 sec 
Looping result 0.0028 sec 0.0507% 22 0.0001 sec 
Template Total 5.3077 sec 95.5% 3 1.7692 sec 
Template load 3.1934 sec 57.4404% 3 1.0645 sec 
Template parser: create text elements 0.1352 sec 2.4317% 64 0.0021 sec 
Template parser: remove whitespace 0.0439 sec 0.7904% 64 0.0007 sec 
Template parser: construct tree 0.7079 sec 12.7331% 64 0.0111 sec 
Template load and register function 0.0113 sec 0.2026% 9 0.0013 sec 
Template processing 2.1133 sec 38.0134% 3 0.7044 sec 
override     
Cache load 0.2647 sec 4.7621% 15 0.0176 sec 
Matching rules 0.0019 sec 0.0334% 4 0.0005 sec 
Sytem overhead     
Fetch class attribute name 0.0000 sec 0.0000% 0 0.0000 sec 
XML     
Image XML parsing 0.0049 sec 0.0882% 1 0.0049 sec 
General     
String conversion 0.0018 sec 0.0316% 5 0.0004 sec 
String conversion w/ mbstring 0.0007 sec 0.0124% 5 0.0001 sec 
Total script time: 5.5594 sec 

cached + compiled

Timing points:
Checkpoint Elapsed Rel. Elapsed Memory Rel. Memory 
Script start 0.0000 sec 0.0471 sec 0.0000KB 0.0000KB 
Module start 'content' 0.0471 sec 0.0239 sec 0.0000KB 0.0000KB 
Module end 'content' 0.0709 sec 0.0752 sec 0.0000KB 0.0000KB 
End 0.1461 sec   0.0000KB 0.0000KB 
Total runtime: 0.2172 sec  

Time accumulators:
 Accumulator  Elapsed  Percent  Count  Average 
ini_load     
Load cache 0.0383 sec 17.4026% 11 0.0035 sec 
Mysql Total     
Mysql_queries 0.0005 sec 0.2095% 1 0.0005 sec 
Looping result 0.0001 sec 0.0286% 1 0.0001 sec 
Template Total 0.1310 sec 59.5% 2 0.0655 sec 
Template load 0.0451 sec 20.5235% 2 0.0226 sec 
Template processing 0.0852 sec 38.7265% 2 0.0426 sec 
override     
Cache load 0.0307 sec 13.9493% 2 0.0153 sec 
Total script time: 0.2200 sec  

with all addon packages installed under the root:

Timing points:
Checkpoint Elapsed Rel. Elapsed Memory Rel. Memory 
Script start 0.0000 sec 0.1031 sec 0.0000KB 0.0000KB 
Module start 'content' 0.1031 sec 6.7573 sec 0.0000KB 0.0000KB 
Module end 'content' 6.8604 sec 2.8364 sec 0.0000KB 0.0000KB 
End 9.6968 sec   0.0000KB 0.0000KB 
Total runtime: 10.5990 sec  

Time accumulators:
 Accumulator  Elapsed  Percent  Count  Average 
ini_load     
Load cache 0.3463 sec 3.2670% 17 0.0204 sec 
Mysql Total     
Mysql_queries 0.0622 sec 0.5868% 41 0.0015 sec 
Looping result 0.0077 sec 0.0724% 40 0.0002 sec 
Template Total 10.3329 sec 97.5% 3 3.4443 sec 
Template load 3.4241 sec 32.2993% 3 1.1414 sec 
Template parser: create text elements 0.2470 sec 2.3297% 161 0.0015 sec 
Template parser: remove whitespace 0.0734 sec 0.6925% 161 0.0005 sec 
Template parser: construct tree 1.2837 sec 12.1090% 161 0.0080 sec 
Template load and register function 0.0114 sec 0.1079% 9 0.0013 sec 
Template processing 6.9078 sec 65.1600% 3 2.3026 sec 
override     
Cache load 0.2900 sec 2.7358% 27 0.0107 sec 
Matching rules 0.0020 sec 0.0192% 4 0.0005 sec 
Sytem overhead     
Fetch class attribute name 0.0000 sec 0.0000% 0 0.0000 sec 
class_abstraction     
Instantiating content class attribute 0.0006 sec 0.0060% 10 0.0001 sec 
XML     
Image XML parsing 0.0048 sec 0.0451% 1 0.0048 sec 
General     
INI string conversion 0.0168 sec 0.1583% 49 0.0003 sec 
String conversion 0.0121 sec 0.1144% 54 0.0002 sec 
String conversion w/ mbstring 0.0050 sec 0.0472% 54 0.0001 sec 
Total script time: 10.6013 sec  

cached & compiled

Timing points:
Checkpoint Elapsed Rel. Elapsed Memory Rel. Memory 
Script start 0.0000 sec 0.0458 sec 0.0000KB 0.0000KB 
Module start 'content' 0.0458 sec 0.0231 sec 0.0000KB 0.0000KB 
Module end 'content' 0.0689 sec 0.0725 sec 0.0000KB 0.0000KB 
End 0.1414 sec   0.0000KB 0.0000KB 
Total runtime: 0.2522 sec  

Time accumulators:
 Accumulator  Elapsed  Percent  Count  Average 
ini_load     
Load cache 0.0407 sec 15.9479% 11 0.0037 sec 
Mysql Total     
Mysql_queries 0.0005 sec 0.1788% 1 0.0005 sec 
Looping result 0.0001 sec 0.0247% 1 0.0001 sec 
Template Total 0.1619 sec 63.5% 2 0.0809 sec 
Template load 0.0384 sec 15.0696% 2 0.0192 sec 
Template processing 0.1228 sec 48.1569% 2 0.0614 sec 
override     
Cache load 0.0275 sec 10.7962% 2 0.0138 sec 
Total script time: 0.2550 sec  

Mit freundlichen Grüßen
Best regards

Norman Leutner

____________________________________________________________
eZ Publish Platinum Partner - http://www.all2e.com
http://ez.no/partners/worldwide_partners/all2e_gmbh

Nabil Alimi

Wednesday 15 June 2005 1:52:47 am

Windows XP Pro.
AMD Athlon XP-M 2600+

First page run.

Timing points:
Checkpoint	Elapsed	Rel. Elapsed	Memory	Rel. Memory
Module start 'content'	0.0000 sec	5.8905 sec	0.0000KB	0.0000KB
Module end 'content'	5.8905 sec	33.1180 sec	0.0000KB	0.0000KB
End	39.0086 sec	 	0.0000KB	0.0000KB
Total runtime:	44.2958 sec	
Time accumulators:
 Accumulator	 Elapsed	 Percent	 Count	 Average
ini_load				
Load cache	1.2946 sec	2.8541%	13	0.0996 sec
Mysql Total				
Mysql_queries	0.9847 sec	2.1710%	37	0.0266 sec
Looping result	0.0060 sec	0.0131%	32	0.0002 sec
Template Total	43.1213 sec	95.1%	3	14.3738 sec
Template load	11.2568 sec	24.8174%	3	3.7523 sec
Template parser: create text elements	0.4516 sec	0.9957%	127	0.0036 sec
Template parser: remove whitespace	0.1136 sec	0.2505%	127	0.0009 sec
Template parser: construct tree	5.0411 sec	11.1139%	127	0.0397 sec
Template load and register function	0.2575 sec	0.5676%	6	0.0429 sec
Template processing	31.8632 sec	70.2476%	3	10.6211 sec
override				
Cache load	1.8946 sec	4.1769%	5	0.3789 sec
Matching rules	0.0551 sec	0.1214%	5	0.0110 sec
Sytem overhead				
Fetch class attribute name	0.0000 sec	0.0000%	0	0.0000 sec
class_abstraction				
Instantiating content class attribute	0.0012 sec	0.0026%	12	0.0001 sec
XML				
Image XML parsing	0.5923 sec	1.3059%	3	0.1974 sec
General				
String conversion	0.7897 sec	1.7409%	6	0.1316 sec
String conversion w/ codepage reverse	0.0854 sec	0.1883%	3	0.0285 sec
String conversion w/ codepage	0.7027 sec	1.5491%	3	0.2342 sec
Total script time:	<b>45.3583 sec</b>	

....

My blog : http://www.starnab.com/ezpublish / http://www.starnab.com/ / http://www.assiki-consulting.com
eZ Publish Freelance developper. Feel free to contact me +33 674 367 057
nabil at assiki d0t fr

Norman Leutner

Friday 17 June 2005 11:09:41 am

Nabil would be nice if you post some more information about your System. (Apache,...)

Mit freundlichen Grüßen
Best regards

Norman Leutner

____________________________________________________________
eZ Publish Platinum Partner - http://www.all2e.com
http://ez.no/partners/worldwide_partners/all2e_gmbh

Mark Marsiglio

Tuesday 21 June 2005 12:50:24 pm

I added Turck MMCache to my RH EL 4 machine (unaccelerated specs above).

The increase was significant.

Cached and compiled, the default page now renders:

Timing points:
Checkpoint	Elapsed	Rel. Elapsed	Memory	Rel. Memory
Module start 'content'	0.0000 sec	0.3472 sec	539.8750KB	872.6953KB
Module end 'content'	0.3472 sec	0.0265 sec	1,412.5703KB	68.0547KB
End	0.3737 sec	 	1,480.6250KB	0.0665KB
Total runtime:	0.3987 sec	
Time accumulators:
 Accumulator	 Elapsed	 Percent	 Count	 Average
ini_load				
Load cache	0.0130 sec	3.0791%	11	0.0012 sec
Mysql Total				
Mysql_queries	0.0184 sec	4.3375%	15	0.0012 sec
Looping result	0.0022 sec	0.5187%	14	0.0002 sec
Template Total	0.3788 sec	89.5%	3	0.1263 sec
Template load	0.0130 sec	3.0724%	3	0.0043 sec
Template processing	0.3650 sec	86.2293%	3	0.1217 sec
override				
Cache load	0.0354 sec	8.3705%	27	0.0013 sec
Sytem overhead				
Fetch class attribute name	0.0000 sec	0.0000%	0	0.0000 sec
class_abstraction				
Instantiating content class attribute	0.0006 sec	0.1491%	10	0.0001 sec
General				
String conversion	0.0300 sec	7.0965%	4	0.0075 sec
String conversion w/ codepage reverse	0.0294 sec	6.9421%	4	0.0073 sec
Total script time:	0.4233 sec	

After clearing all caches, it now runs:

Timing points:
Checkpoint	Elapsed	Rel. Elapsed	Memory	Rel. Memory
Module start 'content'	0.0000 sec	4.1778 sec	628.0391KB	6,109.4141KB
Module end 'content'	4.1778 sec	1.4566 sec	6,737.4531KB	1,332.5156KB
End	5.6344 sec	 	8,069.9688KB	0.0010KB
Total runtime:	6.1459 sec	
Time accumulators:
 Accumulator	 Elapsed	 Percent	 Count	 Average
ini_load				
Load cache	0.3249 sec	5.1964%	15	0.0217 sec
Mysql Total				
Mysql_queries	0.0524 sec	0.8387%	42	0.0012 sec
Looping result	0.0069 sec	0.1108%	41	0.0002 sec
Template Total	6.0940 sec	97.5%	3	2.0313 sec
Template load	1.9189 sec	30.6902%	3	0.6396 sec
Template parser: create text elements	0.2132 sec	3.4102%	161	0.0013 sec
Template parser: remove whitespace	0.0636 sec	1.0177%	161	0.0004 sec
Template parser: construct tree	0.9834 sec	15.7280%	161	0.0061 sec
Template load and register function	0.0124 sec	0.1990%	9	0.0014 sec
Template processing	4.1742 sec	66.7605%	3	1.3914 sec
override				
Cache load	0.3155 sec	5.0467%	27	0.0117 sec
Matching rules	0.0015 sec	0.0244%	4	0.0004 sec
Sytem overhead				
Fetch class attribute name	0.0000 sec	0.0000%	0	0.0000 sec
class_abstraction				
Instantiating content class attribute	0.0006 sec	0.0103%	10	0.0001 sec
XML				
Image XML parsing	0.0082 sec	0.1313%	1	0.0082 sec
General				
INI string conversion	0.1525 sec	2.4387%	393	0.0004 sec
String conversion	0.1432 sec	2.2911%	398	0.0004 sec
String conversion w/ codepage reverse	0.0957 sec	1.5300%	398	0.0002 sec
Total script time:	6.2524 sec	

Much better!

http://www.thinkcreative.com
Turning Ideas Into Strategic Solutions

Ben Devonport

Thursday 07 July 2005 2:54:28 pm

Hi there,

I was running in BIG problems with my provider and eZp can some one tell me how to get the CPU load problems solved ?
He told me:

I was watching our server load and whenever webbellis.co.nz is invoked it attempts to use 100% of the available CPU, if it was on a dedicated server that would be fine but on a shared server that means other sites are affected when it starts using 90%+ of the available CPU for a single apache instance.

Unfortunatly this means we cannot host this script and it must be removed immediatly. Regrettably this is not negotiable.

22796 apache 23 0 42716 41M 7860 R 88.9 4.1 0:22 0 httpd
(The 88.9 is the % CPU usage from process 22796)

And here is the site responsible for the 22796 PID:
11-0 22796 0/42/42 W 12.81 22 0 0.0 0.42 0.42 219.89.194.16 webbellis.co.nz GET /index.php/plain_admin/content/view/full/43 HTTP/1.1

Many Thanks

Ben

pixeltransfer design studio
Auckland
New Zealand
Aotearoa

pixeltransfer (at) yahoo.de

Norman Leutner

Friday 15 July 2005 6:49:36 am

Today I got my new Server hosted by Hosteurope:

Dell Xeon 3,4 Ghz, 2GB RAM,
Red Hat Linux ES 4
Apache 2

Here are my results without any accelerator:

First run:

Timing points:
Checkpoint Elapsed Rel. Elapsed Memory Rel. Memory 
Script start 0.0000 sec 0.1429 sec 1,617.6016KB 4,447.3203KB 
Module start 'content' 0.1429 sec 1.2632 sec 6,064.9219KB 7,872.0547KB 
Module end 'content' 1.4061 sec 1.1357 sec 13,936.9766KB 2,450.6484KB 
End 2.5418 sec   16,387.6250KB 0.0020KB 
Total runtime: 2.9800 sec  

Time accumulators:
 Accumulator  Elapsed  Percent  Count  Average 
ini_load     
Load cache 0.1770 sec 5.1901% 16 0.0111 sec 
Mysql Total     
Mysql_queries 0.0206 sec 0.6030% 26 0.0008 sec 
Looping result 0.0024 sec 0.0691% 22 0.0001 sec 
Template Total 2.7592 sec 80.9% 3 0.9197 sec 
Template load 1.4965 sec 43.8775% 3 0.4988 sec 
Template parser: create text elements 0.1033 sec 3.0293% 64 0.0016 sec 
Template parser: remove whitespace 0.0333 sec 0.9759% 64 0.0005 sec 
Template parser: construct tree 0.5796 sec 16.9926% 64 0.0091 sec 
Template load and register function 0.0157 sec 0.4608% 9 0.0017 sec 
Template processing 1.2618 sec 36.9966% 3 0.4206 sec 
override     
Cache load 0.1150 sec 3.3724% 15 0.0077 sec 
Matching rules 0.0013 sec 0.0384% 4 0.0003 sec 
Sytem overhead     
Fetch class attribute name 0.0000 sec 0.0000% 0 0.0000 sec 
XML     
Image XML parsing 0.0070 sec 0.2066% 1 0.0070 sec 
General     
INI string conversion 0.0073 sec 0.2140% 22 0.0003 sec 
String conversion 0.0356 sec 1.0431% 27 0.0013 sec 
String conversion w/ codepage reverse 0.0327 sec 0.9576% 27 0.0012 sec 
Total script time: 3.4107 sec  

2. run with cache:

Timing points:
Checkpoint Elapsed Rel. Elapsed Memory Rel. Memory 
Script start 0.0000 sec 0.0870 sec 1,532.6484KB 4,212.9688KB 
Module start 'content' 0.0870 sec 0.0366 sec 5,745.6172KB 1,829.0781KB 
Module end 'content' 0.1237 sec 0.0617 sec 7,574.6953KB 1,286.1328KB 
End 0.1854 sec   8,860.8281KB 0.0010KB 
Total runtime: 0.2155 sec  

Time accumulators:
 Accumulator  Elapsed  Percent  Count  Average 
ini_load     
Load cache 0.0220 sec 9.9430% 11 0.0020 sec 
Mysql Total     
Mysql_queries 0.0003 sec 0.1548% 1 0.0003 sec 
Looping result 0.0001 sec 0.0263% 1 0.0001 sec 
Template Total 0.0868 sec 39.3% 2 0.0434 sec 
Template load 0.0179 sec 8.0909% 2 0.0089 sec 
Template processing 0.0685 sec 30.9878% 2 0.0342 sec 
override     
Cache load 0.0125 sec 5.6505% 2 0.0062 sec 
Total script time: 0.2209 sec  

Afer installing eaccelerator (no cache):

Timing points:
Checkpoint Elapsed Rel. Elapsed Memory Rel. Memory 
Script start 0.0000 sec 0.0625 sec 230.4219KB 393.3047KB 
Module start 'content' 0.0625 sec 1.1161 sec 623.7266KB 3,247.1875KB 
Module end 'content' 1.1785 sec 1.0723 sec 3,870.9141KB 1,985.0000KB 
End 2.2508 sec   5,855.9141KB 0.0010KB 
Total runtime: 2.6555 sec  

Time accumulators:
 Accumulator  Elapsed  Percent  Count  Average 
ini_load     
Load cache 0.1493 sec 4.8433% 16 0.0093 sec 
Mysql Total     
Mysql_queries 0.0204 sec 0.6618% 26 0.0008 sec 
Looping result 0.0023 sec 0.0734% 22 0.0001 sec 
Template Total 2.5485 sec 82.7% 3 0.8495 sec 
Template load 1.3225 sec 42.9070% 3 0.4408 sec 
Template parser: create text elements 0.0933 sec 3.0273% 64 0.0015 sec 
Template parser: remove whitespace 0.0276 sec 0.8965% 64 0.0004 sec 
Template parser: construct tree 0.4544 sec 14.7422% 64 0.0071 sec 
Template load and register function 0.0110 sec 0.3559% 9 0.0012 sec 
Template processing 1.2251 sec 39.7493% 3 0.4084 sec 
override     
Cache load 0.1037 sec 3.3647% 15 0.0069 sec 
Matching rules 0.0012 sec 0.0387% 4 0.0003 sec 
Sytem overhead     
Fetch class attribute name 0.0000 sec 0.0000% 0 0.0000 sec 
XML     
Image XML parsing 0.0069 sec 0.2247% 1 0.0069 sec 
General     
INI string conversion 0.0070 sec 0.2260% 22 0.0003 sec 
String conversion 0.0332 sec 1.0757% 27 0.0012 sec 
String conversion w/ codepage reverse 0.0303 sec 0.9833% 27 0.0011 sec 
Total script time: 3.0822 sec  

with cache:

Timing points:
Checkpoint Elapsed Rel. Elapsed Memory Rel. Memory 
Script start 0.0000 sec 0.0160 sec 195.9297KB 340.4922KB 
Module start 'content' 0.0160 sec 0.0077 sec 536.4219KB 141.0859KB 
Module end 'content' 0.0237 sec 0.0223 sec 677.5078KB 354.7578KB 
End 0.0460 sec   1,032.2656KB 0.3464KB 
Total runtime: 0.0633 sec  

Time accumulators:
 Accumulator  Elapsed  Percent  Count  Average 
ini_load     
Load cache 0.0088 sec 13.5882% 11 0.0008 sec 
Mysql Total     
Mysql_queries 0.0003 sec 0.5264% 1 0.0003 sec 
Looping result 0.0001 sec 0.0880% 1 0.0001 sec 
Template Total 0.0371 sec 57.2% 2 0.0185 sec 
Template load 0.0074 sec 11.4317% 2 0.0037 sec 
Template processing 0.0292 sec 45.1102% 2 0.0146 sec 
override     
Cache load 0.0049 sec 7.4994% 2 0.0024 sec 
Total script time: 0.0648 sec  

As you can see with a correctly installed system and eaccelerator performance shouldn`t be a problem.

Mit freundlichen Grüßen
Best regards

Norman Leutner

____________________________________________________________
eZ Publish Platinum Partner - http://www.all2e.com
http://ez.no/partners/worldwide_partners/all2e_gmbh

Gabriel Ambuehl

Saturday 23 July 2005 3:28:22 am

Apache 1.3.33/mod_php 4.3.10/eaccelerator on Debian Sarge (Linux kappa 2.4.27-2-686-smp #1 SMP Mon May 16 16:55:31 JST 2005 i686 GNU/Linux) running on a P4 3.0 Ghz with 1GB RAM and SATA RAID1.

Hitting vanilla ezpublish frontpage (plain setup) after cleaning cache (all caching is active):

Timing points:
Checkpoint	Elapsed	Rel. Elapsed	Memory	Rel. Memory
Script start	0.0000 sec	0.1406 sec	238.7031KB	337.4688KB
Module start 'content'	0.1406 sec	5.8084 sec	576.1719KB	5,724.8047KB
Module end 'content'	5.9489 sec	2.0487 sec	6,300.9766KB	1,187.6094KB
End	7.9976 sec	 	7,488.5859KB	0.0010KB
Total runtime:	8.6938 sec	
Time accumulators:
 Accumulator	 Elapsed	 Percent	 Count	 Average
ini_load				
Load cache	0.3642 sec	4.1878%	18	0.0202 sec
Mysql Total				
Mysql_queries	0.0135 sec	0.1547%	51	0.0003 sec
Looping result	0.0082 sec	0.0949%	48	0.0002 sec
Template Total	8.4197 sec	96.8%	3	2.8066 sec
Template load	3.3687 sec	38.7371%	3	1.1229 sec
Template parser: create text elements	0.2847 sec	3.2737%	161	0.0018 sec
Template parser: remove whitespace	0.0807 sec	0.9277%	161	0.0005 sec
Template parser: construct tree	1.3480 sec	15.5006%	161	0.0084 sec
Template load and register function	0.0200 sec	0.2302%	9	0.0022 sec
Template processing	5.0500 sec	58.0709%	3	1.6833 sec
override				
Cache load	1.0266 sec	11.8054%	27	0.0380 sec
Matching rules	0.0019 sec	0.0221%	4	0.0005 sec
Sytem overhead				
Fetch class attribute name	0.0000 sec	0.0000%	0	0.0000 sec
class_abstraction				
Instantiating content class attribute	0.0007 sec	0.0082%	10	0.0001 sec
XML				
Image XML parsing	0.0007 sec	0.0084%	1	0.0007 sec
General				
INI string conversion	0.0143 sec	0.1643%	43	0.0003 sec
String conversion	0.0098 sec	0.1124%	47	0.0002 sec
String conversion w/ mbstring	0.0035 sec	0.0398%	47	0.0001 sec
Total script time:	8.6962 sec	

First reload:

Timing points:
Checkpoint	Elapsed	Rel. Elapsed	Memory	Rel. Memory
Script start	0.0000 sec	0.0568 sec	213.4297KB	340.1016KB
Module start 'content'	0.0568 sec	0.0150 sec	553.5313KB	146.1406KB
Module end 'content'	0.0718 sec	0.1378 sec	699.6719KB	406.6641KB
End	0.2096 sec	 	1,106.3359KB	0.3971KB
Total runtime:	0.3407 sec	
Time accumulators:
 Accumulator	 Elapsed	 Percent	 Count	 Average
ini_load				
Load cache	0.0783 sec	22.8254%	12	0.0065 sec
Mysql Total				
Mysql_queries	0.0004 sec	0.1110%	1	0.0004 sec
Looping result	0.0001 sec	0.0215%	1	0.0001 sec
Template Total	0.2097 sec	61.1%	2	0.1048 sec
Template load	0.0398 sec	11.5962%	2	0.0199 sec
Template processing	0.1692 sec	49.3159%	2	0.0846 sec
override				
Cache load	0.0359 sec	10.4634%	2	0.0180 sec
Total script time:	0.3432 sec	

Second reload

Timing points:
Checkpoint	Elapsed	Rel. Elapsed	Memory	Rel. Memory
Script start	0.0000 sec	0.0283 sec	206.5703KB	343.1719KB
Module start 'content'	0.0283 sec	0.0124 sec	549.7422KB	146.6172KB
Module end 'content'	0.0407 sec	0.0358 sec	696.3594KB	369.5000KB
End	0.0765 sec	 	1,065.8594KB	0.3608KB
Total runtime:	0.1451 sec	
Time accumulators:
 Accumulator	 Elapsed	 Percent	 Count	 Average
ini_load				
Load cache	0.0197 sec	13.3565%	12	0.0016 sec
Mysql Total				
Mysql_queries	0.0004 sec	0.2526%	1	0.0004 sec
Looping result	0.0001 sec	0.0509%	1	0.0001 sec
Template Total	0.0570 sec	38.6%	2	0.0285 sec
Template load	0.0133 sec	9.0291%	2	0.0067 sec
Template processing	0.0431 sec	29.1682%	2	0.0215 sec
override				
Cache load	0.0095 sec	6.4515%	2	0.0048 sec
Total script time:	0.1476 sec	

Subsequent few hover around .15sec then eventually float between 0.1 and 0.15sec (biased towards the lower values). It probably depends quite a bit on just how well eaccelerator's in memory cache is being hit.

Visit http://triligon.org

Łukasz Serwatka

Friday 12 August 2005 1:36:15 pm

Dell Inspiron 510m
CPU: Pentium M 1.7 Ghz
Memory: 768 MB

Mandriva Linux LE 2005

eZ publish 3.6.1

Apache 1.3.33/PHP 4.3.11 (compiled statically), MySQL 4.1.13, eAccelerator 0.9.3

First run with empty var/cache and var/(site)/cache dirs:

Timing points:
Checkpoint
Elapsed
Rel. Elapsed
Memory
Rel. Memory
Script start  0.0000 sec  0.0747 sec  0.0000KB  0.0000KB
  Module start 'content'  0.0747 sec  2.9272 sec  0.0000KB  0.0000KB
  Module end 'content'  3.0019 sec  1.0767 sec  0.0000KB  0.0000KB
  End  4.0786 sec     0.0000KB  0.0000KB
  Total runtime:  5.2536 sec
  Time accumulators:
 Accumulator
 Elapsed
 Percent
 Count
 Average
ini_load
  Load cache  0.1503 sec  2.8571%  18  0.0083 sec
  Mysql Total
  Mysql_queries  0.0432 sec  0.8213%  41  0.0011 sec
  Looping result  0.0051 sec  0.0966%  40  0.0001 sec
  Template Total  5.1242 sec   97.4%   3   1.7081 sec
  Template load  1.2519 sec  23.8050%  3  0.4173 sec
  Template parser: create text elements  0.1580 sec  3.0038%  160  0.0010 sec
  Template parser: remove whitespace  0.0524 sec  0.9970%  160  0.0003 sec
  Template parser: construct tree  0.7752 sec  14.7408%  160  0.0048 sec
  Template load and register function  0.0013 sec  0.0245%  9  0.0001 sec
  Template processing  3.8715 sec  73.6161%  3  1.2905 sec
  override
  Cache load  0.0988 sec  1.8786%  27  0.0037 sec
  Matching rules  0.0012 sec  0.0226%  4  0.0003 sec
  Sytem overhead
  Fetch class attribute name  0.0034 sec  0.0652%  12  0.0003 sec
  class_abstraction
  Instantiating content class attribute  0.0005 sec  0.0097%  10  0.0001 sec
  XML
  Image XML parsing  0.0007 sec  0.0135%  1  0.0007 sec
  General
  INI string conversion  0.0098 sec  0.1873%  43  0.0002 sec
  String conversion  0.0067 sec  0.1273%  47  0.0001 sec
  String conversion w/ mbstring  0.0023 sec  0.0443%  47  0.0000 sec
  Total script time:  5.2591 sec

With cache:

Timing points:
Checkpoint
Elapsed
Rel. Elapsed
Memory
Rel. Memory
Script start  0.0000 sec  0.0163 sec  0.0000KB  0.0000KB
  Module start 'content'  0.0163 sec  0.0079 sec  0.0000KB  0.0000KB
  Module end 'content'  0.0241 sec  0.0203 sec  0.0000KB  0.0000KB
  End  0.0445 sec     0.0000KB  0.0000KB
  Total runtime:  0.0612 sec
  Time accumulators:
 Accumulator
 Elapsed
 Percent
 Count
 Average
ini_load
  Load cache  0.0113 sec  18.0632%  12  0.0009 sec
  Mysql Total
  Mysql_queries  0.0003 sec  0.5116%  1  0.0003 sec
  Looping result  0.0000 sec  0.0772%  1  0.0000 sec
  Template Total  0.0345 sec   55.3%   2   0.0172 sec
  Template load  0.0079 sec  12.6508%  2  0.0039 sec
  Template processing  0.0262 sec  41.9620%  2  0.0131 sec
  override
  Cache load  0.0052 sec  8.3967%  2  0.0026 sec
  Total script time:  0.0624 sec

Did someone any tests on PostgreSQL databse?

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

Fabricio Guerrero

Friday 04 November 2005 2:50:35 am

Hi,

Its very impressive to see these performance times you guys are having.. they're just awesome... but we're really having huge problems with performance time...

In the worst of the cases load time can vary from 50sec a non cached page down to 8sec a cached page.

Here Output:

NO cache:
Time accumulators:
Accumulator Elapsed Percent Count Average
ini_load
Load cache 0.9164 sec 1.5352% 16 0.0573 sec
Mysql Total
Mysql_queries 4.5133 sec 7.5610% 373 0.0121 sec
Looping result 0.1653 sec 0.2769% 284 0.0006 sec
Template Total 34.6448 sec 58.0% 3 11.5483 sec
Template load 16.2067 sec 27.1509% 3 5.4022 sec
Template parser: create text elements 0.2417 sec 0.4049% 51 0.0047 sec
Template parser: remove whitespace 0.0547 sec 0.0916% 51 0.0011 sec
Template parser: construct tree 1.7457 sec 2.9245% 51 0.0342 sec
Template load and register function 0.2211 sec 0.3704% 10 0.0221 sec
Template processing 18.4369 sec 30.8871% 3 6.1456 sec
override
Cache load 1.0890 sec 1.8243% 5 0.2178 sec
Matching rules 0.0163 sec 0.0273% 12 0.0014 sec
Sytem overhead
Fetch class attribute name 0.0000 sec 0.0000% 0 0.0000 sec
XML
Image XML parsing 0.0979 sec 0.1640% 1 0.0979 sec
class_abstraction
Instantiating content class attribute 0.0003 sec 0.0006% 3 0.0001 sec
eZRSSfeed extension Total 0.1822 sec 0.3% 1 0.1822 sec
RSSfeed load 0.1378 sec 0.2309% 1 0.1378 sec
RSSfeed create DOM 0.0440 sec 0.0737% 1 0.0440 sec
General
String conversion 0.0318 sec 0.0532% 3 0.0106 sec
String conversion w/ codepage reverse 0.0106 sec 0.0178% 2 0.0053 sec
String conversion w/ codepage 0.0204 sec 0.0342% 1 0.0204 sec
Total script time: 59.6913 sec

WITH cache:

Time accumulators:
Accumulator Elapsed Percent Count Average
ini_load
Load cache 0.3950 sec 3.7188% 15 0.0263 sec
Mysql Total
Mysql_queries 0.0351 sec 0.3308% 31 0.0011 sec
Looping result 0.0028 sec 0.0260% 26 0.0001 sec
Template Total 1.9333 sec 18.2% 3 0.6444 sec
Template load 0.1864 sec 1.7543% 3 0.0621 sec
Template processing 1.7458 sec 16.4341% 3 0.5819 sec
override
Cache load 0.1425 sec 1.3419% 5 0.0285 sec
Sytem overhead
Fetch class attribute name 0.0000 sec 0.0000% 0 0.0000 sec
XML
Image XML parsing 0.0987 sec 0.9291% 1 0.0987 sec
class_abstraction
Instantiating content class attribute 0.0001 sec 0.0009% 1 0.0001 sec
General
String conversion 0.0112 sec 0.1054% 2 0.0056 sec
String conversion w/ codepage reverse 0.0108 sec 0.1016% 2 0.0054 sec
Total script time: 10.6230 sec

As you can see this is not what the client wants.. :(.. I'm not too sure on HW specs but its something like:
Dual Pentium Processors
1GB RAM
NT + IIS

Does anybody have any clue??¿¿

Thanks,
Fabricio

http://www.solobromasychistes.com <<Joomla Site :P
http://www.recipesforhealthyfood.com/ <<Drupal Site :P
http://www.ezforge.com/ <<future ezCommunity, Articles, forums and more...

Kåre Køhler Høvik

Friday 04 November 2005 5:28:51 am

Hi Fabricio

I see your cached page is doing 31 queries. Thats too much. This probably means your pagelayout is missing some cache blocks. An optimized pagelayout will reduce this to a minimum 3 queries.

When optimizing, watch out for number of queries. Remember a query will also include template processing, SQL generation, etc. Even if the actual query takes very little time, the overhead for it is substansial.

Kåre Høvik

Frederik Holljen

Friday 04 November 2005 5:28:54 am

>NT + IIS
Here lies at least a great deal of the problem. NT + IIS is not an officially supported platform mainly due to performance issues with IIS and PHP.
Edit: As Kåre noticed, the 31 queries are not optimal either :)

Powered by eZ Publish™ CMS Open Source Web Content Management. Copyright © 1999-2014 eZ Systems AS (except where otherwise noted). All rights reserved.