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.