I was wondering what the best way to store linear data (x & y) in a database would be. The idea is to be able to store millions of these points, then retrieve them all at once in a fast and effecient manner.


  1. What's the best database software to use for storing coordinate data?
  2. What's the best schema/structure to use for storing coordinate data?

When I say best, I mean the fastest and most effecient method.

closed as too broad by mustaccio, LowlyDBA, Michael Green, Paul White Feb 11 at 23:04

Please edit the question to limit it to a specific problem with enough detail to identify an adequate answer. Avoid asking multiple distinct questions at once. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.