How to clean all the old objects versions

Next topic

Author	Message
Jean Gaudel	Thursday 07 December 2006 9:52:21 am Hi, My web site has more than 6000 objects and some of objects in the content subtree have more than 20 versions ! The size of the database increase dramaticly ! I'de like to know, if there's a script to delete all the old objects versions included image files. Thx
kracker (the)	Friday 08 December 2006 4:56:48 am My first suggestion would be to checkout the 'flatten.php' script (requires php-cli to run) <i>bin/php/flatten.php</i> If you do not have php-cli enabled in your php installation you can get it very quickly, <i>http://ezpedia.org/wiki/en/ez/solution_building_php_cli_for_ez_publish_command_line_scripts http://ezpedia.org/wiki/en/ez/solution_building_php_cli_php_4_4_4_for_ez_publish</i> This solution, the combination of php-cli and the flatten.php script should meet your needs. Any other suggestions from the community on this topic? I have created a node in eZpedia on this subject, please feel free to add to it! <i>http://ezpedia.org/wiki/en/ez/solution_how_to_clean_all_the_old_objects_versions</i> Cheers, //kracker Member since: 2001.07.13 \|\| http://ezpedia.se7enx.com/

Author

Message

Thursday 07 December 2006 9:52:21 am

Hi,

My web site has more than 6000 objects and some of objects in the content subtree have more than 20 versions ! The size of the database increase dramaticly !

I'de like to know, if there's a script to delete all the old objects versions included image files.

Thx

kracker (the)

Friday 08 December 2006 4:56:48 am

My first suggestion would be to checkout the 'flatten.php' script (requires php-cli to run) bin/php/flatten.php

If you do not have php-cli enabled in your php installation you can get it very quickly,
http://ezpedia.org/wiki/en/ez/solution_building_php_cli_for_ez_publish_command_line_scripts
http://ezpedia.org/wiki/en/ez/solution_building_php_cli_php_4_4_4_for_ez_publish

This solution, the combination of php-cli and the flatten.php script should meet your needs.

Any other suggestions from the community on this topic?

I have created a node in eZpedia on this subject, please feel free to add to it!
http://ezpedia.org/wiki/en/ez/solution_how_to_clean_all_the_old_objects_versions

Cheers,
//kracker

Member since: 2001.07.13 || http://ezpedia.se7enx.com/

eZ debug

Timing:	Jan 18 2025 05:20:20
Script start
Timing:	Jan 18 2025 05:20:20
Module start 'layout'
Timing:	Jan 18 2025 05:20:20
Module start 'content'
Timing:	Jan 18 2025 05:20:21
Module end 'content'
Timing:	Jan 18 2025 05:20:21
Script end

Main resources:

Total runtime	0.9089 sec
Peak memory usage	4,096.0000 KB
Database Queries	54

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0073	588.0469	152.6406
Module start 'layout'	0.0073	0.0031	740.6875	39.4766
Module start 'content'	0.0104	0.8972	780.1641	527.7109
Module end 'content'	0.9076	0.0012	1,307.8750	8.1250
Script end	0.9088		1,316.0000

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0032	0.3476	16	0.0002
Check MTime	0.0013	0.1418	16	0.0001
Mysql Total
Database connection	0.0016	0.1812	1	0.0016
Mysqli_queries	0.8647	95.1432	54	0.0160
Looping result	0.0005	0.0536	52	0.0000
Template Total	0.8766	96.5	2	0.4383
Template load	0.0020	0.2192	2	0.0010
Template processing	0.8746	96.2302	2	0.4373
Template load and register function	0.0002	0.0186	1	0.0002
states
state_id_array	0.0013	0.1443	1	0.0013
state_identifier_array	0.0010	0.1117	2	0.0005
Override
Cache load	0.0017	0.1830	19	0.0001
Sytem overhead
Fetch class attribute can translate value	0.0006	0.0620	2	0.0003
Fetch class attribute name	0.0009	0.1031	3	0.0003
XML
Image XML parsing	0.0009	0.0971	2	0.0004
class_abstraction
Instantiating content class attribute	0.0000	0.0008	3	0.0000
General
dbfile	0.0008	0.0911	18	0.0000
String conversion	0.0000	0.0010	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
1	node/view/full.tpl	full/forum_topic.tpl	extension/sevenx/design/simple/override/templates/full/forum_topic.tpl
2	content/datatype/view/ezxmltext.tpl	<No override>	extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tpl
5	content/datatype/view/ezxmltags/paragraph.tpl	<No override>	extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tpl
1	content/datatype/view/ezimage.tpl	<No override>	extension/sevenx/design/simple/templates/content/datatype/view/ezimage.tpl
3	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: 13 Number of unique templates used: 6

Time used to render debug report: 0.0001 secs