I find couchbase spatial query it very slow for the amount of data I have.
I have an amazon ec2 xlarge instance, with 16gb RAM and 4 vCores.
I use two buckets:
cold_storage keeps all the documents
location documents epire after 12 hours. It’s used as a cache bucket, should be small & fast
Number of documents in each bucket:
top in ubuntu
CPU ussage in the last minute:
The following stats are measured DAILY:
cold_storage bucket (big one)
location bucket (smaller one)
I have the following view file in both buckets.
I would appreciate any insight I get. Moving forward I wanted to move our entire infrastructure to couchbase, but I first want tot make sure I completly understand it’s performance.