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
|