[OSM-dev] GPS track db may be locked shortly
nick at nickhill.co.uk
Sat Sep 16 03:13:35 BST 2006
All services back on-line. The GPS tracks are now internally represented
by a 32 bit signed int to an accuracy of 0.1uD. Currently, the DB is
converting to/from float via the SQL queries. I hope that eventually the
int representation will be available through the API.
The new schema will reduce the index size held in memory, and improve
the comparison times in the DB.
GPS track downloads should be considerably faster, and free up some
I aborted a slow attempt to sort the GPS data. Perhaps another time.
Nick Hill wrote:
> I am running some tests on an integer based GPS tracklog database.
> If these tests are successful, I will lock, backup, convert the GPS
> database from around midnight. The API will be unavailable temporarily
> whilst procedures are modified for the new schema.
> I don't expect to lock other parts of the database.
> dev mailing list
> dev at openstreetmap.org
More information about the dev