Reduce Number of Version and clean DB?

Previous topic

Next topic

Author	Message
Peter Schnuerer	Thursday 29 December 2005 7:47:39 am Hi, I reduced DefaultVersionHistoryLimit in content.ini to "3" So the number of versions should be reduced to 3 But there are still up to 10 versions in my database. I think I have to run some script to delete all old versions. Is there such a script? Thanx Peter
Xavier Dutoit	Thursday 29 December 2005 8:19:27 am ./bin/php/flatten.php --help eZ publish database flattening. Will remove data that is not considered currently in use to minimize the amount of database data it consumes I think that's going to delete all the archived versions, not only those > 3. I only used it as a tool to clean the database at the end of my dev before launching the site. X+ http://www.sydesy.com

Author

Message

Thursday 29 December 2005 7:47:39 am

Hi,

I reduced

DefaultVersionHistoryLimit

in content.ini to "3"

So the number of versions should be reduced to 3

But there are still up to 10 versions in my database. I think I have to run some script to delete all old versions. Is there such a script?

Thanx
Peter

Thursday 29 December 2005 8:19:27 am

./bin/php/flatten.php --help

eZ publish database flattening.

Will remove data that is not considered currently in use to minimize the amount of database data it consumes

I think that's going to delete all the archived versions, not only those > 3.

I only used it as a tool to clean the database at the end of my dev before launching the site.

X+

eZ debug

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0052	588.0156	152.6250
Module start 'layout'	0.0052	0.0026	740.6406	39.4453
Module start 'content'	0.0079	0.6776	780.0859	528.0625
Module end 'content'	0.6855	0.0014	1,308.1484	8.1563
Script end	0.6869		1,316.3047

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0035	0.5052	16	0.0002
Check MTime	0.0013	0.1940	16	0.0001
Mysql Total
Database connection	0.0008	0.1202	1	0.0008
Mysqli_queries	0.6382	92.9000	54	0.0118
Looping result	0.0006	0.0824	52	0.0000
Template Total	0.6568	95.6	2	0.3284
Template load	0.0020	0.2887	2	0.0010
Template processing	0.6548	95.3266	2	0.3274
Template load and register function	0.0001	0.0149	1	0.0001
states
state_id_array	0.0009	0.1332	1	0.0009
state_identifier_array	0.0010	0.1451	2	0.0005
Override
Cache load	0.0016	0.2356	20	0.0001
Sytem overhead
Fetch class attribute can translate value	0.0005	0.0731	2	0.0003
Fetch class attribute name	0.0013	0.1918	4	0.0003
XML
Image XML parsing	0.0011	0.1570	2	0.0005
class_abstraction
Instantiating content class attribute	0.0000	0.0011	4	0.0000
General
dbfile	0.0010	0.1438	22	0.0000
String conversion	0.0000	0.0013	4	0.0000
Note: percentages do not add up to 100% because some accumulators overlap

Usage	Requested template	Template	Template loaded
1	node/view/full.tpl	full/forum_topic.tpl	extension/sevenx/design/simple/override/templates/full/forum_topic.tpl
2	content/datatype/view/ezimage.tpl	<No override>	extension/sevenx/design/simple/templates/content/datatype/view/ezimage.tpl
2	content/datatype/view/ezxmltext.tpl	<No override>	extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tpl
4	content/datatype/view/ezxmltags/paragraph.tpl	<No override>	extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tpl
1	content/datatype/view/ezxmltags/literal.tpl	<No override>	extension/community/design/standard/templates/content/datatype/view/ezxmltags/literal.tpl
1	content/datatype/view/ezxmltags/line.tpl	<No override>	design/standard/templates/content/datatype/view/ezxmltags/line.tpl
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 12 Number of unique templates used: 7

Time used to render debug report: 0.0001 secs