Reduce ezcontentobject_attribute table size

Previous topic

Developer

Next topic

Author	Message
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
Paul Etienney	Tuesday 29 March 2011 1:22:03 am Thanks for your reply. I will use flatten.php and reduce number of archived versions. Bye -- Good websites creation -- My site : http://www.pauletienney.com Twitter : http://www.twitter.com/p_etienney

Author

Message

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

Paul Etienney

Tuesday 29 March 2011 1:22:03 am

Thanks for your reply. I will use flatten.php and reduce number of archived versions.

Bye

-- Good websites creation --
My site : http://www.pauletienney.com
Twitter : http://www.twitter.com/p_etienney