First I would like to say that I am very impressed with the improvements that Mapnik has made since the last time I looked into using it. I think that there is a lot of potential to get some great looking maps. I am currently trying to use Mapnik to render road data for the entire US. The data is stored in three different PostGIS tables. Major highways, secondary highways, and streets. Each table has a func_class associated with it that seems to cross between major and secondary highways (1-5). At first I tried to render all major highways in the US and got very slow performance (30 seconds). I then tried to create a rule that filtered the major highways on the class '1'. This query seemed to perform just as slow, and returned the same number of records. My questions are:
How should I best organize my data to get the best performance? Does Mapnik do SQL queries on column values contained in the filters? Does the performance that I am seeing make sense. My major highway table has 1,124,813 rows for the entire US? Thank you, Aron Bierbaum _______________________________________________ Mapnik-users mailing list [email protected] https://lists.berlios.de/mailman/listinfo/mapnik-users
