Tobias Wendorff wrote:

> This means: Whenever you zoom out of a map, there's lot of details,
> you don't need at all. The SQL-query grabs all this data of course.

Mapnik does an explicit && with the bbox of the area to be rendered. 
That may still amount to a lot of geometries returned when you are 
rendering low zoom tiles, but it by no means grabs *all* the data.

> The result will be: Smoothed lines (or curves) with less nodes.
> These will be faster to grab from DB and the data will be faster
> to render.

Are you factoring in the time it takes to do the simplification?


Another trick used in osm2pgsql + osm.xml is to put all ways into a 
table (planet_osm_line) and parallel to that place only those ways which 
are interesting for low zoom tiles into a separate table (planet_osm_roads).

This means that for low zooms it only has to query the much smaller 
_roads table, which is faster to scan.

-- 
Lennard
_______________________________________________
Mapnik-users mailing list
[email protected]
https://lists.berlios.de/mailman/listinfo/mapnik-users

Reply via email to