Mysql和Postgresql性能对比
通过spring jpa hibernate代码测试
| action | rows | mysql(s) | postgresql(s) | comment |
|---|---|---|---|---|
| insert | 10000 | 82 | 3 | spring jpa hibernate |
| delete | 10000 | 0.053 | 0.005 | delete all |
| update | 1/10000 | 0.005 | 0.002 | by key |
| select | 1/10000 | 0.007 | 0.001 | not by key |
正文到此结束
通过spring jpa hibernate代码测试
| action | rows | mysql(s) | postgresql(s) | comment |
|---|---|---|---|---|
| insert | 10000 | 82 | 3 | spring jpa hibernate |
| delete | 10000 | 0.053 | 0.005 | delete all |
| update | 1/10000 | 0.005 | 0.002 | by key |
| select | 1/10000 | 0.007 | 0.001 | not by key |