Hi, we installed MonetDB on a Linux box, and did some comparison between MySQL and MonetDB. The result seems off by a large magnitude. Has anyone encountered similar problem please? Thanks.
For MonetDB:
ql>select count(ins_key) from bigtable where ins_key = 15012;
+---------+
| L1 |
+=========+
| 1931541 |
+---------+
1 tuple
Timer 260771.478 msec 1 rows
For MySQL:
select count(ins_key) from
bigtable where ins_key=15012;
+----------------+
| count(ins_key) |
+----------------+
| 1931548 |
+----------------+
real 0m0.989s
user 0m0.002s
sys 0m0.003s
Indices:
MonetDB: None
MySQL: index on ins_key
Thanks.