[OSM-dev] Proposal: Database accelerator and dirty tile marker based on simple algorithm.

[Nigel Magnay]

>
>
>
> how about using this first ?
>
> http://dev.mysql.com/doc/refman/5.1/en/creating-spatial-indexes.html



According to the docs there : "A B-tree index on spatial values will be
useful for exact-value lookups, but not for range scans." - so using that
for lat/lon addressing is likely to be bad.

If you query for 1 tile at the same resolution as that tile is stored (If
you see what I mean) it may give a marginal improvement. This depends on
whether you use it just to index the tile location, or the whole node
address itself (See the "sidenote" section on
http://wiki.openstreetmap.org/index.php/QuadTiles)
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/dev/attachments/20060920/6571dead/attachment.html>