两款数据库性能对比测试的维度
针对下面的内容,可以区分单线程和多线程的测试,同时针对每个维度的测试,建议执行3次,并取测试结果的平均值作为对比维度。
测试维度 测试SQL
- '='等于查询(根据主键) | SELECT * from test WHERE id='菜鸟教程'; |
- '='等于查询(根据根据唯一键) | SELECT * from test WHERE score='30'; |
- <>不等于查询 | SELECT * from test WHERE score <> 40 |
- >大于查询 | SELECT * from test WHERE score > 40 |
- >= AND <=大于等于且小于等于查询 | SELECT * from test WHERE score>=40 and score<=90 |
- BETWEEN 范围内查询 | select * from test where sorce between 10 and 60 |
- IN 包含查询 | select * from test where score in(23,47,68) |
- NOT IN 不包含查询 | select * from test where score not in(47,68) |
- IS NULL 为空查询 | select name from test where name is null |
- LIKE 模糊查询 | select name from test like '%lisa%' |
- DISTINCT 去重查询 | select distinct(score) from test |
- COUNT 统计查询 | select count(1) from test |
- AVG 平均值查询 | select avg(score) from test |
- SUM 求和查询 | select sum(score) from test |
- MAX 最大值查询 | select min(score) from test |
- MIN 最小值查询 | select min(score) from test |
- ORDER BY 排序查询 | Text |
- EXISTS 子查询的查询 | Text |
- INNER JOIN 内连接查询 | Text |
- LEFT JOIN 外连接查询 | Text |
- SIMPLE_RANGES 简单范围查询(主键range) | SELECT c FROM test WHERE id BETWEEN ? AND ? |
- SUM_RANGES 范围求和 | SELECT SUM(k) FROM test WHERE id BETWEEN ? AND ? |
- ORDER_RANGES 简单范围查询(排序) | SELECT c FROM test WHERE id BETWEEN ? AND ? ORDER BY c |
- DISTINCT_RANGES 去重范围查询(主键range + 排序 + 去重) | SELECT DISTINCT c FROM test WHERE id BETWEEN ? AND ? ORDER BY c|
- INSERT INTO...VALUES(value1) 单条插入数据 | INSERT INTO test VALUES(value1) |
- INSERT INTO...VALUES(value1,value1) 多条插入数据 | INSERT INTO test VALUES(value1,value1) |
- INSERT INTO..SELECT.... 写入数据 | INSERT INTO test SELECT * from a; |
- UPDATE 更新数据 | UPDATE name SET id=99 WHERE id=?; |
- DELETE 删除数据 | DELETE FROM CUSTOMER WHERE id=?; |
1.作者:Syw 2.出处:http://www.cnblogs.com/syw20170419/ 3.本文版权归作者和博客园共有,欢迎转载,但未经作者同意必须保留此段声明,且在文章页面明显位置给出原文连接,否则保留追究法律责任的权利。 4.如果文中有什么错误,欢迎指出。以免更多的人被误导。 |