TE
科技回声
首页24小时热榜最新最佳问答展示工作
GitHubTwitter
首页

科技回声

基于 Next.js 构建的科技新闻平台,提供全球科技新闻和讨论内容。

GitHubTwitter

首页

首页最新最佳问答展示工作

资源链接

HackerNews API原版 HackerNewsNext.js

© 2025 科技回声. 版权所有。

Comparing Non-Relational Databases: CouchDB, MongoDB, Tokyo Tyrant

50 点作者 spahl超过 15 年前

9 条评论

javery超过 15 年前
The performance tests here seem about useless. When memcache is slower than all your databases its a good indicator that after your first call all the databases just cached the request, to get meaningful performance metrics you would need to use sizable databases and more realistic use cases. It's not enough to just publisher a disclaimer, why not just do it right in the first place?<p>It also states transactions as a benefit of MYSQL then shows the performance tests against the MyISAM engine which doesn't support transactions. This also explains why the MyuSQL inserts might be faster than any others.
评论 #943337 未加载
mattlanger超过 15 年前
These "NoSQL" comparisons are a tricky thing, inasmuch as this is a very volatile space with a lot of really interesting development happening. Furthermore, benchmarking a handful of storage options that are really only alike in that they share the same thing which they are not (relational, SQL) is a lot like running road tests on a handful of cars that are not Honda Civics.<p>I made the foolish decision a while back to choose a data storage option based on benchmarks and hype, and I'm currently paying for it by having achieved spectacular launch failure and now completely rearchitecting my backend.<p>NoSQL emerged only after a decade or so of webscale challenges helped us finally realize that everything only <i>looked</i> like relational nails because the only tool we had was SQL hammer, and that tackling every data warehousing problem with SQL was coming at the cost of money, engineering hours, and headaches. Now that viable, production-ready alternatives have become available it's important that design decisions to go beyond seeing problems as not-nails and seeing them instead for what they are.<p>Are you looking for reliable, versioned master-master replication for embedded devices? Might want to consider Couch. An obscenely fast caching tier that need not persist to disk? Sure, check out Scalaris. A fully distributed and pluggable map-reduce architecture capable of storing a metric fucktonne of data? Hbase might be for you. And, it should go without saying, there are still and there will always be problems for which SQL is the best solution.<p>In any event, an invaluable starting point is Richard Jones' post at Metabrew discussing research on a number of options for Lastfm: <a href="http://www.metabrew.com/article/anti-rdbms-a-list-of-distributed-key-value-stores/" rel="nofollow">http://www.metabrew.com/article/anti-rdbms-a-list-of-distrib...</a>
评论 #943392 未加载
swannodette超过 15 年前
One thing I see people rarely mention in these discussion is that since CouchDB is master&#60;-&#62;master, you can design applications completely differently: peer-to-peer.
评论 #943538 未加载
bayareaguy超过 15 年前
The title is slightly misleading since they also include PostgreSQL, MySQL and Memcached in their tests. They conclude:<p>* MongoDB and Tokyo Tyrant are useful now. CouchDB has promise, but is too slow currently.<p>* Non-relational databases have shown their worth at larger sites when used cleverly.<p>* Non-relational databases will continue to improve performance, stability &#38; features.<p>* Relational databases are still a great choice: fast, powerful and proven. With caching, denormalization, rework (e.g. Drizzle) &#38; better replication, they will continue to be competitive.
dlsspy超过 15 年前
I'm calling total bullshit on those performance graphs. Neither Tokyo Tyrant nor MySQL is anywhere nearly as fast as memcached unless you have a <i>really</i> bad memcached client (and they do exist).<p>I got somewhere over 90k stores per second on my macbook localhost with my java client. If he's only getting around 3k, he must be doing them by hand.
mark_l_watson超过 15 年前
Nice writeup. My current favorite is MongoDB (I blogged a few days ago on an easy way to index and search text in MongoDB docs), but I still also use CouchDB (and covered CouchDB in my last APress book).<p>I have played a little with Tokyo Cabinet/Tyrant but find it a little too 'low level' - would probably be great if you only need a fast hash. Cassandra is also worth a good look: if you are a Ruby developer, the Cassandra gem can auto-install all of Cassandra and manage it for you - very elegant, really.<p>I admit that one reason I like MongoDB is that it is so simple to use, and the documentation is good.
suhail超过 15 年前
I know little about couchdb but the documentation score seems wrong: <a href="http://books.couchdb.org/relax/" rel="nofollow">http://books.couchdb.org/relax/</a>
adrinavarro超过 15 年前
Graphs don't seem accurate for real-life situations. And I miss Redis in the comparison chart (IMHO memcache shouldn't be there)
va_coder超过 15 年前
Is CouchDB really that slow?
评论 #943042 未加载
评论 #943197 未加载