I have posted the complete View/Query log here (including a few similar 
lines for other views related to 'reservation' that seem normal) just to be 
sure:
https://gist.github.com/wbison/a4a90abc4475e2423bb8398efe01b65d

The queries appear to be exactly the same.

On Saturday, 3 February 2018 18:55:33 UTC+1, wbi...@attic.nl wrote:
>
> I have a view with the following map function:
>
> self.viewReservation = [_database viewNamed: @"reservation"];
> [self.viewReservation setMapBlock: MAPBLOCK({
>   if ([doc[@"doctype"] isEqualToStringCaseInsensitive: "reservation"]) {
>     id date = doc[@"startsOn"];
>     if (date) emit(date, nil);
>     }
>   }) version: @"5.0"];
>
> When a reservation (i.e. document with doctype='reservation') is updated, 
> with the field 'startsOn' remaining unchanged, a very large number (100's) 
> of queries are executed by Couchbase, taking up a considerable amount of 
> time:
>
> 2018-02-03 17:44:33.560334+0100 Nappkin[964:899162] Couch Query: 
> CBLQuery[reservation]: running...
> 2018-02-03 17:44:33.561043+0100 Nappkin[964:899162] Couch View: Checking 
> indexes of (reservation) for reservation
> 2018-02-03 17:44:33.562430+0100 Nappkin[964:899162] Couch View: Updating 
> indexes of (reservation) from #356 to #357 ...
> 2018-02-03 17:44:33.564358+0100 Nappkin[964:899162] Couch View: 
> ...Finished re-indexing (reservation) to #357 (deleted 1, added 1)
> 2018-02-03 17:44:33.566567+0100 Nappkin[964:899162] Couch Query: Query 
> reservation: SELECT key, value, docid, revs.sequence, revid, json FROM 
> 'maps_14', revs, docs WHERE 1 AND key >= ? AND key <= ? AND revs.sequence = 
> 'maps_14'.sequence AND docs.doc_id = revs.doc_id ORDER BY key, docid LIMIT 
> ? OFFSET ?
> Arguments: (
>     <22323031 382d3032 2d303354 30303a30 303a3030 2b303130 3022>,
>     <22323031 382d3032 2d303454 30303a30 303a3030 2b303130 3022>,
>     "-1",
>     0
> )
> 2018-02-03 17:44:33.568991+0100 Nappkin[964:899162] Couch Query: Query 
> reservation: Returning iterator
> 2018-02-03 17:44:33.583188+0100 Nappkin[964:899162] Couch Query: 
> CBLQuery[reservation]: running...
> 2018-02-03 17:44:33.584727+0100 Nappkin[964:899162] Couch View: Checking 
> indexes of (reservation) for reservation
> 2018-02-03 17:44:33.585985+0100 Nappkin[964:899162] Couch Query: Query 
> reservation: SELECT key, value, docid, revs.sequence, revid, json FROM 
> 'maps_14', revs, docs WHERE 1 AND key >= ? AND key <= ? AND revs.sequence = 
> 'maps_14'.sequence AND docs.doc_id = revs.doc_id ORDER BY key, docid LIMIT 
> ? OFFSET ?
> Arguments: (
>     <22323031 382d3032 2d303354 30303a30 303a3030 2b303130 3022>,
>     <22323031 382d3032 2d303454 30303a30 303a3030 2b303130 3022>,
>     "-1",
>     0
> )
> [etc...]
>
> What is causing these queries? 
>
> Thanks,
> Willem
> (Couchbase-lite 1.4.1)
>
>

-- 
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 mobile-couchbase+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/mobile-couchbase/ccbc60f6-4c64-48d3-8c0d-9855dea7c901%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Reply via email to