[OSM-dev] Database Schema (was Re: [OSM-talk] Oh dear - planet has duplicate id's)

[Steve Coast]

On 25 Jun 2007, at 06:38, Raphaël Jacquot wrote:

> Tom Hughes wrote:
>
>> Now ideally I want to do a keyed read on 2+2 then next to 2+3, then
>> do a keyed read on 3+2 and next to 3+3. But I don't actually know
>> what values will match in the first column before I start (and there
>> might be a very large number in a real world case).
>>
>> The alternative (and what will happen now) is that I start at 2+2 and
>> next to 3+3, but that is only marginally better than dropping the  
>> second
>> column and effectively starting at 2+1 and nexting to 3+4 as I am  
>> only
>> saving a little bit on the first and last latitudes.
>>
>> Tom
>>
>
> ideally, this should use
> http://dev.mysql.com/doc/refman/4.1/en/spatial-extensions.html

Ideally you should back up your points and refute others

http://lists.openstreetmap.org/pipermail/talk/2007-January/010129.html

>
> and that
> http://dev.mysql.com/doc/refman/4.1/en/optimizing-spatial- 
> analysis.html
> for the indexes...
>
> _______________________________________________
> dev mailing list
> dev at openstreetmap.org
> http://lists.openstreetmap.org/cgi-bin/mailman/listinfo/dev
>

have fun,

SteveC | steve at asklater.com | http://www.asklater.com/steve/


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/dev/attachments/20070625/980aaa0c/attachment.html>