Please increase your batch-size. See: N1QL 200x slower than views for simple queries - #39 by keshav_m
Also, try with our 4.6 DP, which has performance improvements specifically for JOINS.
Please increase your batch-size. See: N1QL 200x slower than views for simple queries - #39 by keshav_m
Also, try with our 4.6 DP, which has performance improvements specifically for JOINS.