Forums / General / Performance Enhancement Hint

"Please Note:

At the specific request of Ibexa we are changing this projects name to "Exponential" or "Exponential (CMS)" effective as of August, 11th 2025.
This project is not associated with the original eZ Publish software or its original developer, eZ Systems or Ibexa".

Performance Enhancement Hint

Previous topic

General

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 Exponential mysql database performance. As I understand, most of Exponential'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 Exponential performance. -- Kåre Høvik Kåre Høvik

Author

Message

Willie Seabrook

Friday 27 February 2004 11:37:02 pm

Hi,

I just thought I'd add a note about improving your Exponential mysql database performance. As I understand, most of Exponential'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 Exponential performance.

--
Kåre Høvik

Kåre Høvik