30.3.2010 13:55, Philipp Marek wrote:
Hello Jan!
On Montag, 29. März 2010, Jan Horák wrote:
I've prepared a database scheme of the upcoming MySQL backend, it is
avaible at:
http://www.stud.fit.vutbr.cz/~xhorak50/diplomathesis/files/100329_mysql_des
ign_v1.png
I looked at that, and I'd like to post two wishes:
* Please provide representations with a SHA1 (or similar) field;
then it's possible to split blocks on manber-borders, to save
space.
Thank you for respond, this is definitely a good point, I will involve it.
* Furthermore, how about allowing the plain data to reside in files?
Would make the database much smaller, and then these data blocks
could possibly be shared among multiple repositories.
(Really easy, too, if they're named by their SHA1, for example).
That should allow for zero-copy IO, too (at least for sending data).
The question is, how much faster it would be.. I would like to make a
simple test to simulate this soon and estimate the percentage difference..
Another point is a simple backup of the SQL database, using an existed
global backup system in a company, which is one of the main benefits of
the SQL backend. Would the external plain data be a problem for global
backup or not?
Regards,
Phil