[OSM-dev] Usual rendering time for Mapnik on World Db

[Oliver Tonnhofer]

On 10.06.2011, at 17:44, Stefan Menzel wrote:
> as you might have noticed on my former questions I’m setting up a tileserver. This tileserver is part of my diploma thesis for loadbalancing in p2p Networks. Its running on an VM at my university. So I’m not aware of the HDD specs. But it has a  CPU 8 Core an 8GB Ram. I’m surprised by the rendering time.  Rendering tiles on low toom levels  takes a long time. Up to 600 sec so I get a timeout on tirex. Is This normal. Could a single pc handle rendering on demand without any caching?

Some hints:

- display less data in low scales
- add indices for columns you filter on
- create generalized geometries
- cluster your database on the spatial index

The database created by osm2pgsql is not optimized, so rendering will always take a long time if you don't tune it. You should take a look at http://imposm.org if you need on demand rendering.

Regards,
Oliver

-- 
Oliver Tonnhofer    | Omniscale GmbH & Co KG    | http://omniscale.de
http://mapproxy.org | https://bitbucket.org/olt | @oltonn