Help! How to improve performance (eZ = slow)

Next topic

Author	Message
Andreas Widerøe Andersen	Friday 17 December 2004 4:56:33 am Hi, I set up an eZ site a few months back. The site runs on a FreeBSD 4.7 Stable 800mhz/512mb server with plenty of diskspace. I use Apache 1.3.27, MySQL 3.23.54 and PHP 4.3. eZ version 3.3-2 (3.3). My problem is that the site is extremly (!) slow. When I make a request for a page, the response comes first after perhaps 6-7 seconds. Try it here: http://www.stoff.tv/ I was hoping someone could give me some help here. Suggestions on how to improve performance is highly appreciated. Thanks! /Andreas
Hans Melis	Friday 17 December 2004 6:14:00 am Hi Andreas, From what I've read in the past, slow performance on *BSD systems is caused by stat() calls whenever a file is accessed. Since one eZ publish page has quite a lot of include, a lot of stat() calls take place. The number of stat calls depends on the "depth" of your eZ publish installation in the directory tree. There is a stat call for every level in the directory tree (or for every directory if you wish). Example: /opt/software/web/ezpublish/sites/www.stoff.tv/ That makes at least 7 stat calls (6 directories + the file itself) for a file, and even more for files in subdirectories. The best thing you can do is put your eZ publish installation directly under the root (Example: /www.stoff.tv ). This will reduce the number of stat calls for any file. hth Hans http://blog.hansmelis.be

Author

Message

Friday 17 December 2004 4:56:33 am

Hi,
I set up an eZ site a few months back. The site runs on a FreeBSD 4.7 Stable 800mhz/512mb server with plenty of diskspace. I use Apache 1.3.27, MySQL 3.23.54 and PHP 4.3. eZ version 3.3-2 (3.3).

My problem is that the site is extremly (!) slow. When I make a request for a page, the response comes first after perhaps 6-7 seconds.

Try it here: http://www.stoff.tv/

I was hoping someone could give me some help here. Suggestions on how to improve performance is highly appreciated.

Thanks!
/Andreas

Hans Melis

Friday 17 December 2004 6:14:00 am

Hi Andreas,

From what I've read in the past, slow performance on *BSD systems is caused by stat() calls whenever a file is accessed. Since one eZ publish page has quite a lot of include, a lot of stat() calls take place.

The number of stat calls depends on the "depth" of your eZ publish installation in the directory tree. There is a stat call for every level in the directory tree (or for every directory if you wish). Example: /opt/software/web/ezpublish/sites/www.stoff.tv/

That makes at least 7 stat calls (6 directories + the file itself) for a file, and even more for files in subdirectories.

The best thing you can do is put your eZ publish installation directly under the root (Example: /www.stoff.tv ). This will reduce the number of stat calls for any file.

hth

Hans
http://blog.hansmelis.be

eZ debug

Timing:	Jan 19 2025 04:24:45
Script start
Timing:	Jan 19 2025 04:24:45
Module start 'layout'
Timing:	Jan 19 2025 04:24:45
Module start 'content'
Timing:	Jan 19 2025 04:24:46
Module end 'content'
Timing:	Jan 19 2025 04:24:46
Script end

Main resources:

Total runtime	0.9008 sec
Peak memory usage	4,096.0000 KB
Database Queries	54

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0053	590.4453	152.6406
Module start 'layout'	0.0053	0.0026	743.0859	39.4766
Module start 'content'	0.0078	0.8900	782.5625	521.3750
Module end 'content'	0.8979	0.0029	1,303.9375	8.1250
Script end	0.9007		1,312.0625

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0031	0.3440	16	0.0002
Check MTime	0.0013	0.1469	16	0.0001
Mysql Total
Database connection	0.0008	0.0876	1	0.0008
Mysqli_queries	0.8515	94.5214	54	0.0158
Looping result	0.0006	0.0671	52	0.0000
Template Total	0.8658	96.1	2	0.4329
Template load	0.0022	0.2411	2	0.0011
Template processing	0.8636	95.8641	2	0.4318
Template load and register function	0.0002	0.0256	1	0.0002
states
state_id_array	0.0010	0.1104	1	0.0010
state_identifier_array	0.0027	0.2994	2	0.0013
Override
Cache load	0.0017	0.1870	18	0.0001
Sytem overhead
Fetch class attribute can translate value	0.0006	0.0665	2	0.0003
Fetch class attribute name	0.0014	0.1557	3	0.0005
XML
Image XML parsing	0.0011	0.1233	2	0.0006
class_abstraction
Instantiating content class attribute	0.0000	0.0009	3	0.0000
General
dbfile	0.0019	0.2111	15	0.0001
String conversion	0.0000	0.0009	4	0.0000
Note: percentages do not add up to 100% because some accumulators overlap

Templates used to render the page:

Usage	Requested template	Template	Template loaded
1	node/view/full.tpl	full/forum_topic.tpl	extension/sevenx/design/simple/override/templates/full/forum_topic.tpl
2	content/datatype/view/ezxmltext.tpl	<No override>	extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tpl
2	content/datatype/view/ezxmltags/line.tpl	<No override>	design/standard/templates/content/datatype/view/ezxmltags/line.tpl
3	content/datatype/view/ezxmltags/paragraph.tpl	<No override>	extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tpl
1	content/datatype/view/ezimage.tpl	<No override>	extension/sevenx/design/simple/templates/content/datatype/view/ezimage.tpl
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 10 Number of unique templates used: 6

Time used to render debug report: 0.0002 secs