- Latitude (partition key)
- Longitude (clustering key)
- Location info
My doubt is that is it good to make above design. Latitude and Longitude are high cardinality data. I don’t need any range queries on Latitude and Longitude.
Or should I go for Mongodb and geospatial index ?
I am a beginner in database design, I don’t know if lookup speed will reduce if data is growing bigger in the above table.
Thanks for Spending time on this!