I am trying to process and store location information of about 30k vehicles in DynamoDB.
- The Live information will be stored every 10 seconds for each vehicle.
- It will be processed to Live track single vehicle
- The info will also be used to get nearby vehicles given a point and radius.
- I will use python code
I am following following strategy:
Hist table keeps device historical information
- Data will be: deviceid (partition key), lat, lon, timestamp (sortkey), geohash
Live table keeps live info
Data will be: deviceid (partition key), lat, lon, timestamp, geohash(sortkey)
geo hash helps in searching nearby vehicles
- the table information will be updated such that only 30k data will present, one for each vehicle at a given time.
How can I improve on scaling of the Hist and Live table read and write given write is done every 10 seconds?