Hi, When you create a full text query view in Couchbase Lite, a single FTS virtual table is created as well as a "maps" view table. I thought if I were to create multiple full text query views I would get multiple FTS virtual tables in the SQLite database. I still only get one FTS table (called "fulltext"), but with multiple "maps" tables. I'm wondering that since I only seem to get one FTS table, is there really any advantage to creating multiple full text query views in order to get those multiple maps tables? Or is it just as good to create a single big full text query view for all the searchable values in my database?
I'm not really sure what the relationship to all the entries in the maps table are to the FTS table. It seems that all the keys are "null" and all the values are NULL in the maps table. How does the maps table get used in an FTS query? I would think the query would go directly to the FTS table and get the array of docids which can be used to get the documents. I guess I'm just looking for a best practice to get the best performance. One full text query view or multiple full text query views broken up by some logical grouping within my app (in my case a set of records for a specific form). Thanks, Brendan -- You received this message because you are subscribed to the Google Groups "Couchbase Mobile" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/mobile-couchbase/41f96e6f-f5a8-475f-b9b5-066f6f2c1ede%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
