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