Android Application adding Index to collection

Mobile Couchbase Lite
1

Can someone please help me? I’m working on an Android application and trying to add an index to a Couchbase Lite collection. However, when I run a query, it seems like the query actually takes slightly longer with the index compared to when there’s no index. Has anyone encountered this before or know what might be causing it?

2

What query and what index are we talking about?

3

The query is a standard search query.
I am trying to index on a meta property.

4

meta.id() is the key of the b-tree that holds the documents; is the primary key. So an index on it will be created at the time you create the collection in question, no need to do it manually.

Can you please provide more information about the slightly longer time you are observing. What is the query.explain() looking like in both scenario? Maybe an example of such?

5

What query?

What meta property?

6

Apologies for the confusion the meta I’m referring to is just a regular property within our JSON document, not the Couchbase metadata.

Query:
SELECT fl_result(fl_root(hotel.body)) FROM kv_default AS hotel WHERE
((fl_value(hotel.body, ‘meta.type’) = ‘hotel_booking’ AND
fl_value(hotel.body, ‘payload.hotelId’) = ‘hotel_18hqslnd3cdnk’)
AND fl_value(hotel.body, ‘payload.status’) = ‘PLANNED’) AND (hotel.flags & 1 = 0)

3|0|0| SEARCH hotel USING INDEX TestIndex (=?)

{“FROM”:[{“COLLECTION”:“_default._default”,“AS”:“hotel”}],“WHAT”:[[“.”]],
“WHERE”:[“AND”,[“AND”,[“=”,[“.meta.type”],“hotel_booking”],[“=”,[“.payload.hotelId”],
“hotel_18hqslnd3cdnk”]],[“=”,[“.payload.status”],“PLANNED”]]}

7

Apologies for the confusion the meta I’m referring to is just a regular property within our JSON document, not the Couchbase metadata.

Query:
SELECT fl_result(fl_root(hotel.body)) FROM kv_default AS hotel WHERE
((fl_value(hotel.body, ‘meta.type’) = ‘hotel_booking’ AND
fl_value(hotel.body, ‘payload.hotelId’) = ‘hotel_18hqslnd3cdnk’)
AND fl_value(hotel.body, ‘payload.status’) = ‘PLANNED’) AND (hotel.flags & 1 = 0)

3|0|0| SEARCH hotel USING INDEX TestIndex (=?)

{“FROM”:[{“COLLECTION”:“_default._default”,“AS”:“hotel”}],“WHAT”:[[“.”]],
“WHERE”:[“AND”,[“AND”,[“=”,[“.meta.type”],“hotel_booking”],[“=”,[“.payload.hotelId”],
“hotel_18hqslnd3cdnk”]],[“=”,[“.payload.status”],“PLANNED”]]}