Performance Enhancement Hint

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

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