Need to know about performance mysql vs Cocuhbase

SQL++
1

I have three table in mysql
user(1K)
Campaign(6K)
CamapaignDailyUSes(70K)

If I get data of all user by

Select User.column1,User.column2,Campaign.column1 ,Campaign.column2 ,
DailyUSes.* from User Join Campaign join CamapaignDailyUSes

it will give result in few secounds may be.

But in Couchbase N1ql it will take more then 1 minute

what should Do fot it ?? even create some proper index.

How can i structure my Couchbase data ??

2

@krishn can you share the plan (EXPLAIN SELECT …) as well as the index definition you are using?

3

@krishn,

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.