From: Johan De Meersman Date: February 12 2010 7:39am Subject: Re: how things get messed up List-Archive: http://lists.mysql.com/mysql/220676 Message-Id: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary=0016364d31074dc980047f625e5a --0016364d31074dc980047f625e5a Content-Type: text/plain; charset=ISO-8859-1 On Fri, Feb 12, 2010 at 8:27 AM, Martijn Tonies wrote: > 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. -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel --0016364d31074dc980047f625e5a--