performance: mysql + add. index

Saturday 06 March 2004 10:41:22 am - 3 replies

3 replies

Author	Message
Paul Borgermans	Sunday 07 March 2004 4:40:54 am Hi Emil, I suppose read access is faster (but how much, given most of the processing time is spent inside templates?). Do you see a degradation in updating content? regards -paul eZ Publish, eZ Find, Solr expert consulting and training http://twitter.com/paulborgermans
Georg Franz	Sunday 07 March 2004 7:20:04 am Hi Paul, the very strange thing: Inserting or updating content is a bit faster too (1 up to 2 seconds). But I don't have tested that a lot. My db has 300 MB, the largest tables are ezcontentobject_atribute (around 300.000 entries) and ezsearch_object_word_link (1.7 mio. entries). I am using mysql 4.1 and have turned the query cache on. In the other case (if inserting is slowing down the system) I would also accept more indexes because over 90% of the queries are select queries. Kind regards, Emil. Best wishes, Georg. -- http://www.schicksal.com Horoskop website which uses eZ Publish since 2004
kevin wei	Friday 06 January 2006 7:37:48 pm is this tips still useful under EZ 3.7.2?

Author

Message

Sunday 07 March 2004 4:40:54 am

Hi Emil,

I suppose read access is faster (but how much, given most of the processing time is spent inside templates?). Do you see a degradation in updating content?

regards

-paul

eZ Publish, eZ Find, Solr expert consulting and training
http://twitter.com/paulborgermans

Georg Franz

Sunday 07 March 2004 7:20:04 am

Hi Paul,

the very strange thing: Inserting or updating content is a bit faster too (1 up to 2 seconds). But I don't have tested that a lot. My db has 300 MB, the largest tables are ezcontentobject_atribute (around 300.000 entries) and ezsearch_object_word_link (1.7 mio. entries). I am using mysql 4.1 and have turned the query cache on.

In the other case (if inserting is slowing down the system) I would also accept more indexes because over 90% of the queries are select queries.

Kind regards,
Emil.

Best wishes,
Georg.

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

kevin wei

Friday 06 January 2006 7:37:48 pm

is this tips still useful under EZ 3.7.2?

You must be logged in to post messages in this topic!