MySQL和CouchDB各插入5000条记录的速度对比-优快云博客

本文通过虚拟用户执行相同数量的操作，对比了CouchDB与MySQL两种数据库系统的性能。测试结果显示，在总执行时间和每秒交易数（TPS）方面，MySQL表现出更高的效率，但单个操作的最大耗时较长。

[quote="couchdb"]
***************Performance Reports****************
user system total real
3.430000 8.350000 11.780000 ( 41.945267)
----------------------------------------------------------------
The Virtual User is 1.
Total Execute 5000 Action(s).
Total Cost 41.9452669620514 Second(s).
This Scenario's TPS : 119.202960479989.
The longest action cost 0.114742040634155 seconds.
----------------------------------------------------------------
User defined params as below:
{:seq=>5001, :json=>#<Proc:0xb7ca02d0@./couchdbvsmysql2.rb:27>}
******************End of Reports******************[/quote]

[quote="mysql"]***************Performance Reports****************
user system total real
0.130000 0.820000 0.950000 ( 3.099526)
----------------------------------------------------------------
The Virtual User is 1.
Total Execute 5000 Action(s).
Total Cost 3.09952592849731 Second(s).
This Scenario's TPS : 1613.14991884067.
The longest action cost 0.315670967102051 seconds.
----------------------------------------------------------------
User defined params as below:
{:sql=>#<Proc:0xb7c9f7a4@./couchdbvsmysql2.rb:46>, :seq=>5001}
******************End of Reports******************[/quote]