MySQL和CouchDB各插入5000条记录的速度对比

yxixi

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******************



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******************