>> 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