Please accept my apology for doing my example incorrectly. The new example below is 12.3 times the amount of checked out data:
[r...@dadbcu09 logs]# ls -lh /misc_sourcectrl01/svnrepositories/qcfusion/db/revs/167/167755 -rw-r--r-- 1 apache apache 2.5M Feb 11 06:05 /misc_sourcectrl01/svnrepositories/qcfusion/db/revs/167/167755 [r...@dadbcu09 logs]# [klong...@klongfel-ovs3 Test_160121]$ svn log -v -r 167755 http://hostname/qcfusion ------------------------------------------------------------------------ r167755 | | 2010-02-11 09:05:43 -0500 (Thu, 11 Feb 2010) | 1 line Changed paths: A /PROJECTS/QC_PRODUCTION_FUSION_5_FusionQA/Test_124936 A /PROJECTS/QC_PRODUCTION_FUSION_5_FusionQA/Test_124936/Test_124936.zip A /PROJECTS/QC_PRODUCTION_FUSION_5_FusionQA/Test_124936/_AttachRep A /PROJECTS/QC_PRODUCTION_FUSION_5_FusionQA/Test_124936/_AttachRep/_DesAttach.Rcd A /PROJECTS/QC_PRODUCTION_FUSION_5_FusionQA/Test_124936/_AttachRep/_TestAttach.Rcd A /PROJECTS/QC_PRODUCTION_FUSION_5_FusionQA/Test_124936/_TestInfo A /PROJECTS/QC_PRODUCTION_FUSION_5_FusionQA/Test_124936/_TestInfo/_DesStep.Rcd A /PROJECTS/QC_PRODUCTION_FUSION_5_FusionQA/Test_124936/_TestInfo/_Params.Rcd A /PROJECTS/QC_PRODUCTION_FUSION_5_FusionQA/Test_124936/_TestInfo/_Test.Rcd 1.1.1: [klong...@klongfel-ovs3 Test_160121]$ svn co -r 167755 http://hostname/qcfusion/PROJECTS/QC_PRODUCTION_FUSION_5_FusionQA/Test_124936 A Test_124936/Test_124936.zip A Test_124936/_AttachRep A Test_124936/_AttachRep/_DesAttach.Rcd A Test_124936/_AttachRep/_TestAttach.Rcd A Test_124936/_TestInfo A Test_124936/_TestInfo/_Test.Rcd A Test_124936/_TestInfo/_Params.Rcd A Test_124936/_TestInfo/_DesStep.Rcd Checked out revision 167755. [klong...@klongfel-ovs3 Test_160121]$ du -sk Test_124936/ 208 Test_124936/ [klong...@klongfel-ovs3 Test_160121]$ [klong...@klongfel-ovs3 Test_160121]$ bc bc 1.06 Copyright 1991-1994, 1997, 1998, 2000 Free Software Foundation, Inc. This is free software with ABSOLUTELY NO WARRANTY. For details type `warranty'. scale=2 2.5*1024/208 12.30 Thanks, Kevin --- On Thu, 2/11/10, Konstantin Kolinko <knst.koli...@gmail.com> wrote: > From: Konstantin Kolinko <knst.koli...@gmail.com> > Subject: Re: very large revision file - very small amount of data > To: "Kevin Longfellow" <klong...@yahoo.com> > Cc: dev@subversion.apache.org > Date: Thursday, February 11, 2010, 8:39 AM > 2010/2/11 Kevin Longfellow <klong...@yahoo.com>: > > > > 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: > > > > [r...@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 > > [r...@dadbcu09 logs]# > > > > What changed: > > > > [klong...@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: > > > > [klong...@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? > > 1. This is a question for the users@ list > 2. You are committing Test_99820 but checking out > Test_174313 > 3. There was Test_99820.zip >
