DUPLICATE: Couchbase 4 beta “ORDER BY” performance
与问题 Headers 显示一样,对于使用Couchbase 4(N1QL) ORDER BY
子句的一次调用,我面临着13s的巨大响应延迟 . 如果我不使用 ORDER BY
条款,那么每件事都可以 .
我的主要指数是
Definition: CREATE PRIMARY INDEX `#primary` ON `default` USING GSI
和二级指数是
Definition: CREATE INDEX `index_location_name` ON `default`(`name`) USING GSI
N1QL查询
req.params.filter
可以是位置文档中的任何键 .
SELECT _id AS id FROM default WHERE type ='location'ORDER BY“req.params.filter(req.query.descending?'DESC':'')”LIMIT“limit”OFFSET“skip
我的水桶中的位置文件是
{
"_id": "location::370794",
"name": "Kenai Riverside Fishing",
"avgRating": 0,
"city": "Cooper Landing",
"state": "Alaska",
"country": "USA",
"zipCode": "99572",
"created": "2013-07-10T17:30:00.000Z",
"lastModified": "2015-02-13T12:34:36.923Z",
"type": "location",
}
任何人都可以说出为什么 ORDER BY
条款如此拖延?