couchbase index for variable array in query

Question

I tried to make and run some N1QL query that find document some field is matched with element of variable array in query. but speed of the query is too slow. The query is like below.

select * from bucket where tp='type' and tm between 1484618520 and 1484618615 and nm='name' and checked=false and (bucket.gm in ["TEST","TEST2"])

["TEST","TEST2"] part is variable depend on condition.

I want to speedup this query.

How can I create index for this query including variable array?

Thanks.

Byunggoo Kim · Accepted Answer · 2017-01-17 05:07:08Z

1

I solved this problem by using below command.

create index new_index on bucket(gm,tp,tm,nm,checked) using gsi;

I set the "gm" field as leading key of new index.

Then the query speed was totally improved.

answered Jan 17, 2017 at 5:07

Byunggoo Kim

216 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

couchbase index for variable array in query

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related