[mapserver-users] Problem with postgis layer

[Twan Kogels]

I agree with you, but the sql query will not be embedded in the map file. 
It will be generated by a php mapscript with dynamic user input. To 
simplify my question i had "hidden" the mapscript aspect of my question.

-twan

At 09:48 4-6-2002 -0700, you wrote:
>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
>      \_

-- 
http://www.twansoft.com