Guys,
I have the following requirement:
-Every time the user clicks on a location on a mobile App, I have to show him all events (categorized point data) in 1 km buffer.
-I have over 10 Million records of those events
-Data is currently stored in a SQL server database
-What I am after is PERFORMANCE PERFORMANCE and PERFORMANCE
If you faced a similar requirement how did you approach it? How did you stream the data? Where did you store it?
