[Geocoding] Local Mirror of OSM Data...

[Frederik Ramm]

Hi,

Anthony wrote:
> By the way, I highly disagree with that statement.  Maybe it's true if
> you're using MyISAM, but with any modern database with views, and
> triggers, and stored procedures, your core schema should be
> independent of implementation.

Sure you can always think of a nice general schema but the original 
poster was worried about performance not after building his application, 
but before even starting to. So of course it is true that he should 
select a schema that works best for his application.

If you want to make GIS-type queries but don't care for topology (like 
e.g. a renderer does), then it makes sense to have the GIS structures 
ready in the database and ignore unimportant things like whether or not 
two linestrings really share a node or just happen to intersect at a 
certain location. This is the schema generated by osm2pgsql but it would 
be unsuitable for editing or routing. Other schemas are well suited for 
topology questions but rubbish at "please give me everything in this 
area" and so on.

Of course a good database will give you anything you ask for, no matter 
how many indirections and table scans your schema requires - it is just 
a question of how quickly.

Bye
Frederik