Forums / Developer / Reduce ezcontentobject_attribute table size
Paul Etienney
Monday 28 March 2011 6:40:48 pm
Hello,
I am working on small website (600 objects, two languages) and my ezcontentobject_attribute is getting bigger and bigger (around 60 Mo).
I would like to make this table lighter. What would be your choice to achieve this ?
Thank you for your help.
Bye
-- Good websites creation -- My site : http://www.pauletienney.com Twitter : http://www.twitter.com/p_etienney
Ivo Lukac
Tuesday 29 March 2011 12:28:32 am
Simplest thing you can do is execute flatten.php to remove all archived versions. Additionally you can reduce number of archived versions so they get disposed quicker.
More advanced would be to revise attributes number in your classes with most objects. Maybe there are some attributes which are not used, or they can be squeezed in less number, or you can extract them into separate objects.
http://www.linkedin.com/in/ivolukac http://www.netgen.hr/eng/blog http://twitter.com/ilukac
Tuesday 29 March 2011 1:22:03 am
Thanks for your reply. I will use flatten.php and reduce number of archived versions.
Script start
Module start 'content'
Module end 'content'
Script end
Time used to render debug report: 0.0002 secs