very large revision file - very small amount of data

Hi,

Just wondering if someone can shed some light on why a revision file is 18 times greater than the amount of checked out data for that revision? I'm using Subversion 1.6.5 but not an upgraded and packed repository. I'm currently testing that to see if it will make any difference and so far it looks like the savings is minimal.

The issue here could be misuse of source control, and I am trying to find out more about their use. This group has an automated test application that will create 1400+ revisions of around 3MB revision files per day. With the inability to delete this can't go on for to long.

Here is the space difference:

The revision from the OS perspective:

[root_at_dadbcu09 logs]# ls -lh /misc_sourcectrl01/svnrepositories/qcfusion/db/revs/167/167649
-rw-r--r-- 1 apache apache 3.0M Feb 11 04:43 /misc_sourcectrl01/svnrepositories/qcfusion/db/revs/167/167649
[root_at_dadbcu09 logs]#

What changed:

[klongfel@klongfel-ovs3 qcfusion]$ svn log -v -r 167649 http://devprodsvn.us.oracle.com/qcfusion
------------------------------------------------------------------------
r167649 | | 2010-02-11 07:43:43 -0500 (Thu, 11 Feb 2010) | 1 line
Changed paths:
   M /PROJECTS/QC_PRODUCTION_FUSION_5_FusionQA/Test_99820/Test_99820.zip
   M /PROJECTS/QC_PRODUCTION_FUSION_5_FusionQA/Test_99820/_AttachRep/_DesAttach.Rcd
   M /PROJECTS/QC_PRODUCTION_FUSION_5_FusionQA/Test_99820/_AttachRep/_TestAttach.Rcd
   M /PROJECTS/QC_PRODUCTION_FUSION_5_FusionQA/Test_99820/_TestInfo/_DesStep.Rcd
   M /PROJECTS/QC_PRODUCTION_FUSION_5_FusionQA/Test_99820/_TestInfo/_Params.Rcd
   M /PROJECTS/QC_PRODUCTION_FUSION_5_FusionQA/Test_99820/_TestInfo/_Test.Rcd

1.1.8:
------------------------------------------------------------------------

Check it out:

[klongfel@klongfel-ovs3 qcfusion]$ svn co -r 167649 http://hostname/qcfusion/PROJECTS/QC_PRODUCTION_FUSION_5_FusionQA/Test_174313
A Test_174313/_AttachRep
A Test_174313/_AttachRep/_DesAttach.Rcd
A Test_174313/_AttachRep/_TestAttach.Rcd
A Test_174313/_TestInfo
A Test_174313/_TestInfo/_Test.Rcd
A Test_174313/_TestInfo/_Params.Rcd
A Test_174313/_TestInfo/_DesStep.Rcd
Checked out revision 167649.

There is 164 KB of data in the checkout but the revision is 3.0MB?

[klongfel_at_klongfel-ovs3 qcfusion]$ du -sk Test_174313
164 Test_174313
[klongfel_at_klongfel-ovs3 qcfusion]$

Thanks for taking a look and any assistance you can provide.

Kevin

      
Received on 2010-02-11 14:33:24 CET