I am quite new over here and gone through almost every white paper and benchmarks available about CouchBase and MongoDB I need help in terms of opinion to decide a right backend for the platform we are building. I hope this is the right place to ask!
We are basically building structured messaging app. i.e. each message is structured (like poll) along with responses stored for all users in a (big) group. We also need to store status for each message (not sent, broadcasted, delivered, seen). Each document will be small but too many documents for just one message. (e.g. 1 poll with group of 5000 people = 1 (main message) + 5000 (status records) + 5000 (responses)).
Do you think its right use case for CouchBase? I am heavily inspired by Viber case study. As we simply can’t store these many messages in longer run to MongoDB. So looking for fast, modern and compressed database solution.
We are already running prototype on CouchBase but simple query (select *) having ~8000 records takes ~300ms. Is it normal or we misconfigured the production machine? (4 cores 6G single node).