[OSM-dev] GPS track db may be locked shortly

[Andy Robinson]

Nice work Nick. gpx downloads now seem to be twice as fast. A big benefit
for a decent size area.

Cheers

Andy

Andy Robinson
Andy_J_Robinson at blueyonder.co.uk 

>-----Original Message-----
>From: dev-bounces at openstreetmap.org [mailto:dev-bounces at openstreetmap.org]
>On Behalf Of Nick Hill
>Sent: 16 September 2006 3:14 AM
>To: Nick Hill
>Cc: Talk Openstreetmap; dev at openstreetmap.org
>Subject: Re: [OSM-dev] GPS track db may be locked shortly
>
>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
>server memory.
>
>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
>> http://lists.openstreetmap.org/cgi-bin/mailman/listinfo/dev
>>
>
>_______________________________________________
>dev mailing list
>dev at openstreetmap.org
>http://lists.openstreetmap.org/cgi-bin/mailman/listinfo/dev
>
>--
>No virus found in this incoming message.
>Checked by AVG Free Edition.
>Version: 7.1.405 / Virus Database: 268.12.4/449 - Release Date: 15/09/2006
>

-- 
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.405 / Virus Database: 268.12.4/449 - Release Date: 15/09/2006