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

Powered by eZ Publish™ CMS Open Source Web Content Management. Copyright © 1999-2014 eZ Systems AS (except where otherwise noted). All rights reserved.

eZ debug

Timing: Jan 30 2025 16:39:26
Script start
Timing: Jan 30 2025 16:39:26
Module start 'layout'
Timing: Jan 30 2025 16:39:26
Module start 'content'
Timing: Jan 30 2025 16:39:26
Module end 'content'
Timing: Jan 30 2025 16:39:26
Script end

Main resources:

Total runtime0.0227 sec
Peak memory usage4,096.0000 KB
Database Queries3

Timing points:

CheckpointStart (sec)Duration (sec)Memory at start (KB)Memory used (KB)
Script start 0.00000.0044 588.0078151.1953
Module start 'layout' 0.00440.0036 739.2031220.6719
Module start 'content' 0.00800.0135 959.87501,001.7422
Module end 'content' 0.02140.0012 1,961.617237.9922
Script end 0.0227  1,999.6094 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.002410.6948140.0002
Check MTime0.00104.4163140.0001
Mysql Total
Database connection0.00073.029610.0007
Mysqli_queries0.00208.660430.0007
Looping result0.00000.038810.0000
Template Total0.00093.810.0009
Template load0.00072.999110.0007
Template processing0.00020.756910.0002
Override
Cache load0.00052.042810.0005
General
dbfile0.00156.600880.0002
String conversion0.00000.023140.0000
Note: percentages do not add up to 100% because some accumulators overlap

Templates used to render the page:

UsageRequested templateTemplateTemplate loadedEditOverride
1print_pagelayout.tpl<No override>extension/community/design/community/templates/print_pagelayout.tplEdit templateOverride template
 Number of times templates used: 1
 Number of unique templates used: 1

Time used to render debug report: 0.0001 secs