Couchbase Questions: N1QL

Have a Question? Get it answered by our community

canagey's picture
Asked 4 months 2 weeks ago
Latest activity 4 months 2 weeks ago

With N1QL queries being executed on the Couchbase server, what is the cost (on performance) of running such queries?

Appreciate if the cost can be defined for example with 100GB of data in one bucket if we run a query what the performance cost is??

levonio99's picture
Asked 4 months 2 weeks ago
Latest activity 4 months 1 week ago

Sorting asc vs. desc performance in views and N1QL

Hello,

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...

gustavo.leivapiedra's picture
Asked 4 months 2 weeks ago
Latest activity 4 months 2 weeks ago

How would a N1QL join statement behave in a sharded environment?

How would it be executed so that it's performant?

avyaktha's picture
Asked 4 months 2 weeks ago
Latest activity 4 months 2 weeks ago

For N1QL should we create an index for each search and filter predicate for n1ql to be performant?

How does this work with a sharded couchbase? which will be slow performing queries which ones will be fast

nkavian's picture
Asked 4 months 2 weeks ago
Latest activity 4 months 2 weeks ago

Should I be using multiple buckets?

I watched the Nickel webinar today. All examples, tutorials, and documentation are using multiple buckets, are multiple buckets the preferred way?

I had read other Couchbase documentation that advocated using as few possible buckets & views.

Please clarify.

nkavian's picture
Asked 4 months 2 weeks ago
Latest activity 4 months 2 weeks ago

Is Nickel eventually-consistent or realtime?

Is Nickel eventually-consistent or realtime? How is it positioned: as a analogous to views were we expect a certain performance or as a common/primary feature such as reading and writing documents?

carlosM's picture
Asked 4 months 3 weeks ago
Latest activity 4 months 1 week ago

I don't know if I understand collated views right (and N1QL would be am option?)

Hi everybody..I'm not pretty sure if I understand well collated views, I only could found a couple of articles about it...I was trying this in the last night...my idea: create documents which are related to messages, every essage has an author and could have many destinataries (which are saved...

ahurt's picture
Asked 5 months 3 days ago
Latest activity 4 months 6 days ago

Better way to split a string?

I have a document element that looks like this ...

"ip": "123.12.11.4"

I need to be able to get each 'octet' out of that value (split it on the '.') I can get the first portion with a case statement:

case
when
substr(ws.ip, 1, 1) == '.'
...

Emilio G.'s picture
Asked 5 months 1 week ago
Latest activity 5 months 1 week ago

N1QL Golang

Hello,
It is possible use N1QL with the Golang SDK?

P.D.: out of curiosity, when will release final version?

Thanks

Best,
Emilio

arik@peerkamp.com's picture
Asked 5 months 1 week ago
Latest activity 5 months 1 week ago

N1QL with Ruby client

Is there any documentation of using N1QL with the RUby client SDK?

If not - can anyone give a example of how to query the Couchbase server using N1QL via the Ruby client?

Thanks

Pages