On 23/10/09 18:05, 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.
Well in theory maybe, just like in theory everybody would have their databases fully normalised. In the real world we don't all have infinite CPU time and I/O bandwidth so sometimes we have to do some pre-computation to get the data in a form where the queries we want to use can be efficiently processed. In the case of OSM data for example it may often be advantageous to create proper PostGIS geometries for objects so that spatial queries can be efficiently resolved. I'm not sure it would be possible to write a view to do that even if you wanted to - if you could it would be pretty horrible and mind-blowing inefficient. Tom -- Tom Hughes ([email protected]) http://www.compton.nu/ _______________________________________________ Geocoding mailing list [email protected] http://lists.openstreetmap.org/listinfo/geocoding
