expected database growth when versioning binary data
Hello,
does anyone knows how the database size of an RTC database will be affected when uploading binary data sources. We are concerned about database growth. Will it be likely that each uploaded version consumes up the size of the file or is there some kind of delta-storing-procedures in place.
To be more precise, we plan to do some document storage in RTC and fear that the database size will grow by the document size of the document every time we load up a new version of it.
Can anybody share his thoughts about this with me?
Thanks in advance,
michl
does anyone knows how the database size of an RTC database will be affected when uploading binary data sources. We are concerned about database growth. Will it be likely that each uploaded version consumes up the size of the file or is there some kind of delta-storing-procedures in place.
To be more precise, we plan to do some document storage in RTC and fear that the database size will grow by the document size of the document every time we load up a new version of it.
Can anybody share his thoughts about this with me?
Thanks in advance,
michl
6 answers
Hi Michl,
there are no deltas for binaries as far as I know. This means binaries have a big footprint, I think this is true for every SCM system. However data is compressed on the server (advanced properties) based on several advanced server propertie settings. I haven't seen an exception for binaries.
there are no deltas for binaries as far as I know. This means binaries have a big footprint, I think this is true for every SCM system. However data is compressed on the server (advanced properties) based on several advanced server propertie settings. I haven't seen an exception for binaries.
ClearCase comes with both compressed and binary delta type managers for
binary files. But as Ralph says, RTC uses the "compression" approach to
decrease the data size of versioned binaries.
Cheers,
Geoff
On 8/15/2011 1:53 PM, rschoon wrote:
binary files. But as Ralph says, RTC uses the "compression" approach to
decrease the data size of versioned binaries.
Cheers,
Geoff
On 8/15/2011 1:53 PM, rschoon wrote:
Hi Michl,
there are no deltas for binaries as far as I know. This means binaries
have a big footprint, I think this is true for every SCM system.
However data is compressed on the server (advanced properties) based
on several advanced server propertie settings. I haven't seen an
exception for binaries.
To avoid binaries being added to the RTC DB we have implemented a file limit of 10MB. I have never been a fan of using SCM tools to store binaries. With the increased availablity of tools like Nexus the need to store binaries in the SCM tool really has decreased. If you could some how segrate binaries and source into unique DB it might be ok, but combining binaries/source into a single DB is a recipe for trouble.
To avoid binaries being added to the RTC DB we have implemented a file limit of 10MB. I have never been a fan of using SCM tools to store binaries. With the increased availablity of tools like Nexus the need to store binaries in the SCM tool really has decreased. If you could some how segrate binaries and source into unique DB it might be ok, but combining binaries/source into a single DB is a recipe for trouble.
Hi Daniel,
I completely agree if we are talking about source code and binaries generated from source. However, there are a lot more files considered being "binaries" that are not generated from code. Documents, drawings, layouts, etc.
Also, sometimes there are binaries that are required where there is no source code available.
Hi Michl,
there are no deltas for binaries as far as I know. This means binaries have a big footprint, I think this is true for every SCM system. However data is compressed on the server (advanced properties) based on several advanced server propertie settings. I haven't seen an exception for binaries.
That's not true, SCM supports delta compression of files, including binary files. In fact 1 of the properties you can change in advanced properties is whether to enable or disable delta compression. If delta compression results in larger gains than other compression types it will be used to compress a given binary.
- Dmitry