[postgis-users] Are views slow ing down my wms?

[Robert Buckley]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20120712/69b1e6ad/attachment.html>