Storing GPS data
I need to store GPS data in the MySQL database (database is expected to have about 1.000.000 inserts daily). A colleague proposed RANGE partitioning - so I tried to apply that. However, problem is that one of the fields (position - intended to store latitude and longitude) is spatial type POINT. Tables with spatial type can not use partitioning. So now I have a kind of dilemma:
1. If I wanna use partitioning I need to store lat & long as FLOAT or DOUBLE. Which is better?
2. Using spatial data type without partitioning or using partitioning? What to choose?
Subject
Written By
Posted
Storing GPS data
October 16, 2016 12:58PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.