I’m developing a project where I need to store and manage a large amount of location data from devices sending their positions to a server. Currently, I’m using a MariaDB SQL database, where each data entry includes fields like user_id, run_id, latitude, longitude, and accuracy.

Although this setup works, I’m concerned about its performance and scalability as data volume continues to grow. Especially, querying for specific routes (based on run_id) is becoming slower.

I’m open to trying out new systems or technologies that might handle large-scale location data more efficiently. My main requirement is that the system should efficiently manage massive amounts of data and support operations like retrieving all points around a specific location.

What are some recommended technologies or systems that can handle these needs effectively? I’m looking for options that ensure scalability and quick data retrieval.