In MySQL and Couchbase I read data of 1 day and 1 month by using query. 1- day query is SELECT Temp.Col.001, FROM kami_file1_dat WHERE META().id BETWEEN “1430438400” AND “1430524800”; 30 - days data read query is SELECT temp.Col.001 FROM kami_file1_dat WHERE META().id BETWEEN “1430438400” AND …

Only optimization I can think of is Memory Optimized Index.

Why Couchbase query performs slower than MySQL?

vsr1 August 20, 2017, 12:35am 2

1 Like