Hello,
It will take sometimes to retrieve the set of data from the view relative to its complexity. Is the request which define the view simple or does it have complex and / or spatial operator ? Does your spatial data have a lot of points ? Did you make indexes on the columns used by your views ? Hugues. ________________________________ De : postgis-users-boun...@postgis.refractions.net [mailto:postgis-users-boun...@postgis.refractions.net] De la part de Robert Buckley Envoyé : jeudi 12 juillet 2012 07:30 À : Post GIS Users Discussion Objet : [postgis-users] Are views slow ing down my wms? Hi, I have created a database structure which has 3 main postgis tables (1 for lines,polygones, and points) which each contain between 5-10,000 features. These tables then feed views which split the geometries into understandable groups which are then served through geoserver in Tomcat6, linux-Ubuntu 10.04. I have noticed that the performance of the wms is getting considerably worse. Is this to do with the views or simply the amount of data being served? Should I in hindsight have split the table into separate tables instead of creating views? thanks for any help, Robert
_______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
