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

Topic		Replies	Views
N1QL queries slower on M1 mac (16gb) than a free tier ec2 returning similar results in mysql Couchbase Server n1ql	8	485	March 17, 2024
How to query with Curl in couchbase SQL++ query	44	11314	August 26, 2022
Need to know about performance mysql vs Cocuhbase SQL++ n1ql	2	2047	January 1, 2017
How to increase couchbase performance Couchbase Server	3	2090	January 13, 2016
Is couchbase server fast enough Couchbase Server	0	1734	November 15, 2014