From: Martijn Tonies
Date: February 15 2010 9:51am
Subject: Re: how things get messed up
List-Archive: http://lists.mysql.com/mysql/220691
Message-Id: <006c01caae24$6b4dffd0$6101a8c0@martijnws>
MIME-Version: 1.0
Content-Type: text/plain;
	format=flowed;
	charset="iso-8859-1";
	reply-type=original
Content-Transfer-Encoding: 7bit

>> Sounds logical, what's also nice to see, is that even though people here
>> tend to say "don't put binaries in the database", apparently Facebook
>> thought it would be nice to do so (for all sorts of reasons) and even 
>> took
>> the time to write their own blob storage mechanism ;-)
>
>
> The whole point is that they *aren't*' putting blobs in their database -
> that has way too much overhead. They're using a custom service that does
> nothing but "read from byte X to byte Y". No concepts of tablespaces,
> integrity, indices, whatever.
>
> The only thing they store in their database, is the start- and end-byte of
> each image.
>
> I doubt they even took it as far as to write a plugin engine - that would
> again bring too much overhead.

Right, not the actual files, indeed. But not "just" on the file system 
either,
interesting approach.

With regards,

Martijn Tonies
Upscene Productions
http://www.upscene.com

Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!

Database questions? Check the forum:
http://www.databasedevelopmentforum.com