Performance Enhancement Hint

Next topic

Author	Message
Willie Seabrook	Friday 27 February 2004 11:37:02 pm Hi, I just thought I'd add a note about improving your ezpublish mysql database performance. As I understand, most of ezpublish's performance problems arise from very intensive use of the database. I have made a number of customisations that involve among other things, querying the ez tables directly rather than through the API because in a number of situations the performance using the API was just ridiculous. The ez tables are very much free of indexes. I added a couple of indexes to the eznode_assignment and ezcontentobject_attribute tables and reduced one of my very database intensive pages initial load time from over 80 seconds to about under 6 seconds. Still horrible but doable. So the hint is, have a poke around inside the ez code, and your own and seek out columns to index. Probably quite obvious to most but I had always assumed it had already been done. Dummy me eh? Regards, Willie
Georg Franz	Saturday 28 February 2004 6:23:49 am Hi Willie, thanx for the tip! Which indexes did you add? Do you have the sql code? Kind regards, Emil. Best wishes, Georg. -- http://www.schicksal.com Horoskop website which uses eZ Publish since 2004
Kåre Køhler Høvik	Monday 01 March 2004 2:08:59 am We are aware of missing indexes and have started adding indexes to to the database ( 3.4a1 DB update contains new index for ezuser_role.role_id ) Please post new indexes you find to increase eZ publish performance. -- Kåre Høvik Kåre Høvik

Author

Message

Friday 27 February 2004 11:37:02 pm

Hi,

I just thought I'd add a note about improving your ezpublish mysql database performance. As I understand, most of ezpublish's performance problems arise from very intensive use of the database. I have made a number of customisations that involve among other things, querying the ez tables directly rather than through the API because in a number of situations the performance using the API was just ridiculous.

The ez tables are very much free of indexes. I added a couple of indexes to the eznode_assignment and ezcontentobject_attribute tables and reduced one of my very database intensive pages initial load time from over 80 seconds to about under 6 seconds. Still horrible but doable.

So the hint is, have a poke around inside the ez code, and your own and seek out columns to index. Probably quite obvious to most but I had always assumed it had already been done. Dummy me eh?

Regards,
Willie

Georg Franz

Saturday 28 February 2004 6:23:49 am

Hi Willie,

thanx for the tip!

Which indexes did you add? Do you have the sql code?

Kind regards,
Emil.

Best wishes,
Georg.

--
http://www.schicksal.com Horoskop website which uses eZ Publish since 2004

Kåre Køhler Høvik

Monday 01 March 2004 2:08:59 am

We are aware of missing indexes and have started adding indexes to to the database ( 3.4a1 DB update contains new index for ezuser_role.role_id )

Please post new indexes you find to increase eZ publish performance.

--
Kåre Høvik

Kåre Høvik

eZ debug

Timing:	Jan 18 2025 22:26:49
Script start
Timing:	Jan 18 2025 22:26:49
Module start 'layout'
Timing:	Jan 18 2025 22:26:49
Module start 'content'
Timing:	Jan 18 2025 22:26:49
Module end 'content'
Timing:	Jan 18 2025 22:26:49
Script end

Main resources:

Total runtime	0.0143 sec
Peak memory usage	2,048.0000 KB
Database Queries	3

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0049	587.9063	152.6250
Module start 'layout'	0.0049	0.0030	740.5313	39.4453
Module start 'content'	0.0079	0.0043	779.9766	89.2891
Module end 'content'	0.0123	0.0021	869.2656	34.3047
Script end	0.0143		903.5703

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0024	16.6545	14	0.0002
Check MTime	0.0011	7.7324	14	0.0001
Mysql Total
Database connection	0.0006	4.4112	1	0.0006
Mysqli_queries	0.0029	20.3961	3	0.0010
Looping result	0.0000	0.0781	1	0.0000
Template Total	0.0016	11.1	1	0.0016
Template load	0.0009	5.9430	1	0.0009
Template processing	0.0007	5.1638	1	0.0007
Override
Cache load	0.0006	4.0490	1	0.0006
General
dbfile	0.0002	1.4621	8	0.0000
String conversion	0.0000	0.0415	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	Edit	Override
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 1 Number of unique templates used: 1

Time used to render debug report: 0.0001 secs