[mapserver-users] Problem with postgis layer

[Paul Ramsey]

Dave might correct me, but my tendency is to think that using a view
would ALWAYS be preferable to a complex SQL query embedded in the map
file. PostgreSQL has an opportunity to cache the query plan for a view,
so it does not have to re-evaluate for each mapserver request. 

Tyler Mitchell wrote:
> 
> Would it be more appropriate then to create a view that represents the data
> in a simpler format in postgis and reference it directly instead?

-- 
      __
     /
     | Paul Ramsey
     | Refractions Research
     | Email: pramsey at refractions.net
     | Phone: (250) 885-0632
     \_