开发者

RavenDB or SQL Server 2008 Filestream

A project I am working on at the minute involves taking a massive set of results stored in a file and doing calculations based on those results. I have been looking at using either RavenDB or using the SQL2008 with the Filestream as the storage for the results. I am not sure which technology would be best suited to my problem.

Has anyone any 开发者_如何学编程views on which of these approaches is best for massive storage and possible searching of results?


I tried to insert a lot of data to Raven and was also disappointed in the first place, because I did it all form one thread. It turned out that inserting to SQL Server was faster (without doing much configuration on both servers).

Then I realized that I probably misused Raven, which is - as far as I understand it - designed to handle massive parallelism. So I played a bit with TPL opening a lot of threads / processes doing inserts in parallel. Raven handled this very well - but keep the "eventual consistency" in mind - not all the results showed up in the database immediatly but with a short delay.

I think a direct comparrison is hard unless you adjust your architecture to fit the choosen storage technology.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜