On Mon, Sep 1, 2008 at 8:29 AM, spaetz <[EMAIL PROTECTED]> wrote: > > I don't know if Ian Dees is implementing an API solution or whether he > works on the database side of things... > > My current work is here: http://svn.yellowbkpk.com/geo/
I'm using http://svn.yellowbkpk.com/geo/osm_to_mysql.py to do the planet -> MySQL import, the http://svn.yellowbkpk.com/geo/planet.sql schema is what I'm importing into, and http://svn.yellowbkpk.com/geo/bbox.php is what performs the map HTTP request. The minutely diff import is a missing piece, and should be fairly easy to augment into my osm_to_mysql.py script. The most important part is the spatial indexes on both the node and way data types. This significantly improves the bbox.php MySQL calls, but it takes more storage in the DB and longer to import. Also, I'm thinking about getting rid of the username/userid tracking in the database. This would save several gigabytes of storage in the database and I don't think [EMAIL PROTECTED] uses it for rendering at this point, right? -Ian
_______________________________________________ Tilesathome mailing list [email protected] http://lists.openstreetmap.org/listinfo/tilesathome
