Hi i have a general question.
So when building your app you can either introduce another moving part (db) or create it in your primary db (Couchbase). Without having done any tests can you say something about how efficient
n1ql would handle an activity feed where a json field is the ”key” for retrieval and has been indexed, so the feed should be fan out on read. The documents should be sorted according to a timestamp, i guess there is no such thing in couchbase that store the index according to timestamp so it has to resort it for every request ?
Also this feed has to have some relevance to the user so it should contain post from who i am following, meaning i am looking at using the IN clause. If you have many followers (hundreds or maybe thousand) and perform the above mentioned operation. Is this a scalable solution ?
Or should i looking into other ordered sets data structures ?