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.
- What's the best database software to use for storing coordinate data?
- What's the best schema/structure to use for storing coordinate data?
When I say best, I mean the fastest and most effecient method.