Hey, I wonder about the query speed of elasticsearch and relational
database. So I perform an experiment:
Cpu: Intel(R) Core(TM) i5-3450
Memory: 32g
Linux 2.6.32
ElasticSearch doc:
{"id":"9864599","createTime":"1337706360000","category":"1","tos":"965169
965183 965203 965204 ","from":"1079665","type":"R RA16","corpID":"269228"}
Mysql record:
+----+------------+--------+--------+---------+---------+------+---------------+---------------+------------+
| id | ap_id | status | archiv | user_id | dept_id | type |
create_time | update_time | company_id |
+----+------------+--------+--------+---------+---------+------+---------------+---------------+------------+
| 1 | 1 | -1 | 1 | 9098 | 0 | 1 |
1287769309973 | 1287772542536 | 10 |
+----+------------+--------+--------+---------+---------+------+---------------+---------------+------------+
Similar queries:
select count(approve_id) CountResult from approve_ids where user_id=?;
select approve_id from approve_ids where user_id=? order by update_time
desc limit {CountResult - 100}, 100;
both elasticsearch and mysql have 1800w records, and corresponding index;
After preloadng the data, execut concurrenttly the queries in 10 threads.
Query params and resultset are same in elasticsearch and mysql.
I got the test results:
Elasticsearch: 461 queries / s, system load: 1+
Mysql : 949 queries / s, system load: 0.1
Can someboy tell me is this result right, and why?
Thanks.
--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.