How fast is indexing?

Couchbase Server
1

Hi,

I’m wondering if I can use a view for a use case that requires near realtime querying.

One use case I can think of is a comment system.

When a user submit a comment and refreshes the page, is it considered OKAY to use a view?

I’m aware of using stale() method in SDK to wait for the indexing, but how fast is it? If 100 concurrent users submit comments at the same time, am I going to slow down the whole system or is it fast enough?

2

Hi, for your example, the fastest thing would be to stick with key/value and do the data modeling accordingly. @matthew started a great blog post series about data modeling and key design that should interest you in that regard: Data modelling: manual secondary indexes - The Couchbase Blog Couchbase key design and data modeling - The Couchbase Blog

3

Thank you @ldoguin. I will read the blog posts :smile: