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

eZ debug

Timing:	Jan 30 2025 00:54:05
Script start
Timing:	Jan 30 2025 00:54:05
Module start 'layout'
Timing:	Jan 30 2025 00:54:05
Module start 'content'
Timing:	Jan 30 2025 00:54:05
Module end 'content'
Timing:	Jan 30 2025 00:54:05
Script end

Main resources:

Total runtime	0.0187 sec
Peak memory usage	2,048.0000 KB
Database Queries	3

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0061	588.2656	151.2266
Module start 'layout'	0.0061	0.0028	739.4922	36.6875
Module start 'content'	0.0089	0.0083	776.1797	90.1094
Module end 'content'	0.0173	0.0014	866.2891	33.9766
Script end	0.0187		900.2656

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0025	13.6158	14	0.0002
Check MTime	0.0012	6.2606	14	0.0001
Mysql Total
Database connection	0.0008	4.4524	1	0.0008
Mysqli_queries	0.0031	16.6970	3	0.0010
Looping result	0.0000	0.0599	1	0.0000
Template Total	0.0010	5.5	1	0.0010
Template load	0.0008	4.1478	1	0.0008
Template processing	0.0002	1.3304	1	0.0002
Override
Cache load	0.0006	2.9653	1	0.0006
General
dbfile	0.0038	20.1389	8	0.0005
String conversion	0.0000	0.0217	4	0.0000
Note: percentages do not add up to 100% because some accumulators overlap

Templates used to render the page:

Usage	Requested template	Template	Template loaded	Edit	Override
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 1 Number of unique templates used: 1

Time used to render debug report: 0.0001 secs