Couchbase Questions: Couchbase views

Have a Question? Get it answered by our community

Hao Liu's picture
Asked 1 week 1 day ago
Latest activity 1 day 4 min ago

Does CouchbaseClient.Query take a snapshot of the data?

Say I have a view with a reduce function that gives count of documents, and I get a ViewResponse by calling client.Query() with includeDocs set to true. Then I iterate the ViewResponse and use the count got from the view. Can I iterate the same ViewResponse object again sometime later to stamp a...

opic's picture
Asked 1 week 1 day ago
Latest activity 1 week 1 day ago

Building views in the background with Couchbase Lite


When you have a large database (let's say 10 000 documents) building views can be very long. Could we use a type of background view build mechanism ? Would this be available for the PhoneGap connector ?

The CouchDB REST Api specifies that on a query you could use the :...

ohassidi's picture
Asked 1 month 6 days ago

Creating Views using command line

Is that possible?

jasonmartens's picture
Asked 1 month 1 week ago

View ordering with range

I would like to create a view that is returned in a specific order (for example, by the doc id or a datetime field), but can be filtered by a key range. For example, suppose I had a lot of documents like this:

jbroughton's picture
Asked 1 month 3 weeks ago

Querying a view count issue


I have a query I am running and its returning some strange results:

In my view the key is set up as [identifier, type]

in my query I am passing:
keys: [[identifier, 'receipt'],
[identifier, 'open'],
[identifier, 'help'],...

levonio99's picture
Asked 2 months 3 weeks ago
Latest activity 2 months 2 weeks ago

Sorting asc vs. desc performance in views and N1QL


We know that the views sort data in ascending order. Since N1QL uses views behind the scenes, we assume that ORDER BY in asc is performant. How does N1QL handle ORDER BY desc? Is there a difference in performance?

For example in SQL relational database when an index is...

zbintliff's picture
Asked 3 months 1 week ago
Latest activity 3 months 2 days ago

Multiple Views on Design Document

I'm using couchbase for proof of concepts and such. I am reading about views and design documents and understand them (I think). So far whenever I wanted to create a new view I created a new document as well. Is there any benefit or drawback for putting multiple views on the same design...

mlipovits's picture
Asked 3 months 1 week ago
Latest activity 3 months 1 week ago

Issues returning unique values

We are having some performance issues with our ongoing project because we get back lots of values from our views and cannot group them because we don't use any reduce function.
Here, we want all gpi - values which share the came cell_id back. problem here is that lots of document share the same gpi and the same cell_id. The group function is no option since we found no reduce to perform here. Since we get back so many duplicate values we have to put in a set in python so they are unique we lose a lot of performance due to iterating through all values couichbase returns.

An example doc and view are in the full description.
Does anyone have any idea how we could solve this problem?

jasonfill's picture
Asked 3 months 4 weeks ago

Getting Most Updated/Reliable Data Back From A View

I am looking for best practices for getting updated and reliable data back from a view. I have read a bit about the stale parameter and I understand that sending stale=false will force a reindex prior to returning the results - however it is clear there is a performance hit for this. (...

vakoroteev's picture
Asked 3 months 4 weeks ago

Strange behavior with paginated query.

I get a strange behavior with paginated query. While I paginate on the result set, I get duplicates of some documents. I'm doing the following in my code: