2010/3/31 Jan Horák <horak.honza_at_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
Received on 2010-04-01 20:57:26 CEST