2010/3/31 Jan Horák <horak.ho...@gmail.com>: > 30.3.2010 13:55, Philipp Marek wrote: >... >> * 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..
My gut says "not that much faster". In most scenarios, the network bandwidth between the client/server will be the bottleneck. Reading the data off a disk (rather than from a DB) is not going to make the WAN connection any faster. On a LAN, you might have enough network bandwidth to see bottlenecks on the server's I/O channel, but really... I remain somewhat doubtful. I'd go with the "store content in the database" until performance figures (or a DBA) demonstrates it is a problem. Cheers, -g
