eZ publish performance
eZ publish performance
Wednesday 18 May 2005 2:25:08 pm - 66 replies
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?
Modified on Wednesday 18 May 2005 2:32:28 pm by Łukasz Serwatka
Wednesday 18 May 2005 2:57:41 pm
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
Modified on Wednesday 18 May 2005 3:01:01 pm by Bård Farstad
Wednesday 18 May 2005 5:50:17 pm
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 
Wednesday 18 May 2005 10: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
Modified on Wednesday 18 May 2005 10:34:47 pm by bisk
Thursday 19 May 2005 12:07:11 pm
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?
Modified on Thursday 19 May 2005 12:38:05 pm by Łukasz Serwatka
Thursday 19 May 2005 2:46:49 pm
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
Monday 06 June 2005 4:34:46 pm
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
Thursday 09 June 2005 6:59:20 pm
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.
Tuesday 14 June 2005 2:56:38 pm
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
Modified on Tuesday 14 June 2005 3:28:15 pm by Norman Leutner
Wednesday 15 June 2005 10: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>
....
Tuesday 21 June 2005 9: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!
Thursday 07 July 2005 11: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
Friday 15 July 2005 3:49:36 pm
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.
Modified on Friday 15 July 2005 4:26:50 pm by Norman Leutner
Saturday 23 July 2005 12:28:22 pm
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.
Friday 12 August 2005 10: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?
Modified on Friday 12 August 2005 10:44:42 pm by Łukasz Serwatka
Friday 04 November 2005 11: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
Friday 04 November 2005 2:28:51 pm
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.
Modified on Friday 04 November 2005 2:29:33 pm by Kåre Køhler Høvik
Friday 04 November 2005 2:28:54 pm
>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
Modified on Friday 04 November 2005 3:09:05 pm by Frederik Holljen
You must be logged in to post messages in this topic!