Let's be more precise in saying that this all depends on the expected size of the documents. If you know that the documents will be on the few hundreds kilobytes mark on average and no more than a few megabytes (say < 5MB, even though there is no magic number), then storing them as blob will work perfectly fine (which is not saying storing them externally with metadata in Cassandra won't, but using blobs can be simpler in some cases).
I've very successfully stored tons of images as blobs in Cassandra. I just knew they couldn't get super big because the system wasn't allowing it. The point with the size being that each time you will get a document, Cassandra will have to load it (entirely) in memory to return it. -- Sylvain On Wed, Jun 22, 2011 at 9:22 AM, Sasha Dolgy <sdo...@gmail.com> wrote: > http://cassandra-user-incubator-apache-org.3065146.n2.nabble.com/Storing-photos-images-docs-etc-td6078278.html > > Of significance from that link (which was great until feeling lucky > was removed...): > > Google of terms cassandra large files + feeling lucky > http://www.google.com/search?q=cassandra+large+files&ie=utf-8&oe=utf-8&aq=t&rls=org.mozilla:en-US:official&client=firefox-a > > Yields: > http://wiki.apache.org/cassandra/FAQ#large_file_and_blob_storage > > > --- store your images / documents / etc. somewhere and reference them > in Cassandra. That's the consensus that's been bandied about on this > list quite frequently. we employ a solution that uses Amazon S3 for > storage and Cassandra as the reference to the meta data and location > of the files. works a treat > > > On Wed, Jun 22, 2011 at 9:07 AM, Damien Picard <picard.dam...@gmail.com> > wrote: >> Hi, >> >> I have to store some files (Images, documents, etc.) for my users in a >> webapp. I use Cassandra for all of my data and I would like to know if this >> is a good idea to store these files into blob on a Cassandra CF ? >> Is there some contraindications, or special things to know to achieve this ? >> >> Thank you >
