I would suggest you chunk them down into small pieces (~ 10-50MB) and just fetch all the parts you need. A problem might be that if fetching one fails, the whole blob is useless.
Keep them where?
From: Mohit Anchlia <firstname.lastname@example.org>
Sent: Wednesday, February 22, 2012 3:44 PM
Subject: Re: Please advise -- 750MB object possible?
In my opinion if you are busy site or application keep blobs out of the database.
On Wed, Feb 22, 2012 at 9:37 AM, Dan Retzlaff <email@example.com> wrote:
Chunking is a good idea, but you'll have to do it yourself. A few of the columns in our application got quite large (maybe ~150MB) and the failure mode was RPC timeout exceptions. Nodes couldn't always move that much data across our data center interconnect in the default 10 seconds. With enough heap and a faster network you could probably get by without chunking, but it's not ideal.
On Wed, Feb 22, 2012 at 9:04 AM, Maxim Potekhin <firstname.lastname@example.org> wrote:
I'm being asked whether we can serve an "object", which I assume is a blob, of 750MB size?
I guess the real question is of how to chunk it and/or even it's possible to chunk it.