Forums / General / Delete Old Versions

Delete Old Versions

Author Message

Aldo Bucchi

Thursday 01 May 2003 3:04:18 pm

How can I delete old object versions (the ones I know I won't use anymore) to lighten up the db a little?

Thx,
Aldo

Aldo Bucchi

Saturday 03 May 2003 12:39:52 pm

Is it possible at all?

Paul Borgermans

Saturday 03 May 2003 2:42:19 pm

No (for the interface)

Yes (in the database), but difficult and dangerous (dependencies between recordds and tables).

Lighten up the db is not relevant for ez publish performance, db operations are only a few percent of processing time. The bulk goes to templates where the need for optimisation is obvious.

Paul

 

eZ Publish, eZ Find, Solr expert consulting and training
http://twitter.com/paulborgermans

Marco Zinn

Saturday 03 May 2003 3:27:02 pm

Hi,
I was asking Bard about this (removing old versions, archiving concept) some months ago.
While the database might not be a huge problem, files are.
I'm not talking about performance, but disc space.

Let's say, we have one object with a 5 MB file attached and have lots of versions of this object. The versioning system MUST keep copies of the old text/integer/whatsoever data in the DB and MUST keep copies of the old versions of the file (or image). I guess, this is working.
Now, when i've got 20 version x 5 MB x number of similar objects.... I see a need to mark old version for archiving and providing some way to archive the binaries with the data from the DB. A good versioning system must provide this.
As archiving needs a way to restore the archived data (would be more difficult than archiving, I guess), what about a "Delete" button for old versions for the beginning?

Yes, _we_ have a setup like this, as we have one installation of ezP2, which has a big "document management" part in it. As ezP2 does not handle versions, we don't have this problem at the moment (we just have the current version on the web server)

Marco
http://www.hyperroad-design.com

Tonny Laursen

Wednesday 10 September 2003 3:34:08 am

Is there a solution for this?, im currently using EZ3.1

Tonny

Paul Forsyth

Wednesday 10 September 2003 3:35:55 am

Unfortunately this is a 3.2 feature. Can you upgrade?

Paul

Tonny Laursen

Wednesday 10 September 2003 3:40:27 am

I will upgrade on next wednesday.

Thanks,
Tonny

eZ debug

Timing: Jan 18 2025 14:50:51
Script start
Timing: Jan 18 2025 14:50:51
Module start 'content'
Timing: Jan 18 2025 14:50:53
Module end 'content'
Timing: Jan 18 2025 14:50:53
Script end

Main resources:

Total runtime1.2351 sec
Peak memory usage4,096.0000 KB
Database Queries212

Timing points:

CheckpointStart (sec)Duration (sec)Memory at start (KB)Memory used (KB)
Script start 0.00000.0057 587.6016180.8516
Module start 'content' 0.00571.0948 768.4531691.5469
Module end 'content' 1.10050.1345 1,460.0000336.4531
Script end 1.2350  1,796.4531 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.00390.3141210.0002
Check MTime0.00140.1156210.0001
Mysql Total
Database connection0.00080.068510.0008
Mysqli_queries1.158493.78842120.0055
Looping result0.00210.17092100.0000
Template Total1.210198.020.6051
Template load0.00190.155820.0010
Template processing1.208297.821920.6041
Template load and register function0.00010.011810.0001
states
state_id_array0.00110.087410.0011
state_identifier_array0.00130.107420.0007
Override
Cache load0.00160.1292350.0000
Sytem overhead
Fetch class attribute can translate value0.00170.139060.0003
Fetch class attribute name0.00120.095290.0001
XML
Image XML parsing0.00200.163360.0003
class_abstraction
Instantiating content class attribute0.00000.001390.0000
General
dbfile0.00510.4161340.0002
String conversion0.00000.000530.0000
Note: percentages do not add up to 100% because some accumulators overlap

CSS/JS files loaded with "ezjscPacker" during request:

CacheTypePacklevelSourceFiles
CSS0extension/community/design/community/stylesheets/ext/jquery.autocomplete.css
extension/community_design/design/suncana/stylesheets/scrollbars.css
extension/community_design/design/suncana/stylesheets/tabs.css
extension/community_design/design/suncana/stylesheets/roadmap.css
extension/community_design/design/suncana/stylesheets/content.css
extension/community_design/design/suncana/stylesheets/star-rating.css
extension/community_design/design/suncana/stylesheets/syntax_and_custom_tags.css
extension/community_design/design/suncana/stylesheets/buttons.css
extension/community_design/design/suncana/stylesheets/tweetbox.css
extension/community_design/design/suncana/stylesheets/jquery.fancybox-1.3.4.css
extension/bcsmoothgallery/design/standard/stylesheets/magnific-popup.css
extension/sevenx/design/simple/stylesheets/star_rating.css
extension/sevenx/design/simple/stylesheets/libs/fontawesome/css/all.min.css
extension/sevenx/design/simple/stylesheets/main.v02.css
extension/sevenx/design/simple/stylesheets/main.v02.res.css
JS0extension/ezjscore/design/standard/lib/yui/3.17.2/build/yui/yui-min.js
extension/ezjscore/design/standard/javascript/jquery-3.7.0.min.js
extension/community_design/design/suncana/javascript/jquery.ui.core.min.js
extension/community_design/design/suncana/javascript/jquery.ui.widget.min.js
extension/community_design/design/suncana/javascript/jquery.easing.1.3.js
extension/community_design/design/suncana/javascript/jquery.ui.tabs.js
extension/community_design/design/suncana/javascript/jquery.hoverIntent.min.js
extension/community_design/design/suncana/javascript/jquery.popmenu.js
extension/community_design/design/suncana/javascript/jScrollPane.js
extension/community_design/design/suncana/javascript/jquery.mousewheel.js
extension/community_design/design/suncana/javascript/jquery.cycle.all.js
extension/sevenx/design/simple/javascript/jquery.scrollTo.js
extension/community_design/design/suncana/javascript/jquery.cookie.js
extension/community_design/design/suncana/javascript/ezstarrating_jquery.js
extension/community_design/design/suncana/javascript/jquery.initboxes.js
extension/community_design/design/suncana/javascript/app.js
extension/community_design/design/suncana/javascript/twitterwidget.js
extension/community_design/design/suncana/javascript/community.js
extension/community_design/design/suncana/javascript/roadmap.js
extension/community_design/design/suncana/javascript/ez.js
extension/community_design/design/suncana/javascript/ezshareevents.js
extension/sevenx/design/simple/javascript/main.js

Templates used to render the page:

UsageRequested templateTemplateTemplate loadedEditOverride
1node/view/full.tplfull/forum_topic.tplextension/sevenx/design/simple/override/templates/full/forum_topic.tplEdit templateOverride template
7content/datatype/view/ezxmltext.tpl<No override>extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tplEdit templateOverride template
10content/datatype/view/ezxmltags/paragraph.tpl<No override>extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tplEdit templateOverride template
4content/datatype/view/ezxmltags/line.tpl<No override>design/standard/templates/content/datatype/view/ezxmltags/line.tplEdit templateOverride template
2content/datatype/view/ezimage.tpl<No override>extension/sevenx/design/simple/templates/content/datatype/view/ezimage.tplEdit templateOverride template
1pagelayout.tpl<No override>extension/sevenx/design/simple/templates/pagelayout.tplEdit templateOverride template
 Number of times templates used: 25
 Number of unique templates used: 6

Time used to render debug report: 0.0002 secs