MySQL和CouchDB各插入5000条记录的速度对比 博客分类： 数据库 CouchDBMySQLperformancejsonSQL
程序员文章站
2024-03-23 17:21:22
...
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******************
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******************