In my test table there are 1 million rows, column id is auto generated number from 1 to one million and id column is unique index, timestore column storing insertion time, when execute select query between id range Ex:
select * from test where id > 345673 and id < 453267
Execution time - 0.379s
if execute select query between two dates
select * from test where timestore between '2014-12-28 16:59:50' and '2014-12-28 17:1:50'
Execution time - 1.478s
Why second query takes more than first ?