File store: CouchDB vs SQL Server + file system

Posted by Andrey on Server Fault See other posts from Server Fault or by Andrey
Published on 2010-11-23T19:15:46Z Indexed on 2011/01/11 10:55 UTC
Read the original article Hit count: 269

Filed under:
|

I'm exploring different ways of storing user-uploaded files (all are MS Office documents or alikes) on our high load web site. It's currently designed to store documents as files and have a SQL database store all metadata for those files. I'm concerned about growing out of the storage server and SQL server performance when number of documents reaches hundreds of millions. I was reading a lot of good information about CouchDB including its built-in scalability and performance, but I'm not sure how storing files as attachments in CouchDB would compare to storing files on a file system in terms of performance.

Anybody used CouchDB clusters for storing LARGE amounts of documents and in high load environment?

© Server Fault or respective owner

Related posts about sql-server

Related posts about couchdb