Re: [mapserver-users] Layer based on a view renders faster than if based on a table

et Re: [mapserver-users] Layer based on a view renders faster than if based on a table Steve, Have you put the "DEBUG 5" directive at the layer level too ? Alan On December 8, 2009 09:36:27 am steve.tout...@inspq.qc.ca wrote: > Daniel, > I already set this in th

Re: [mapserver-users] Layer based on a view renders faster than if based on a table

://www.inspq.qc.ca > > > > > > Daniel Morissette @lists.osgeo.org > Envoyé par : mapserver-users-boun...@lists.osgeo.org > 04/12/2009 05:05 PM > > A > mapserver-users@lists.osgeo.org > cc > > Objet > Re: [mapserver-users] Layer based on a view renders faste

Re: [mapserver-users] Layer based on a view renders faster than if based on a table

nspq.qc.ca http://www.inspq.qc.ca Daniel Morissette @lists.osgeo.org Envoyé par : mapserver-users-boun...@lists.osgeo.org 04/12/2009 05:05 PM A mapserver-users@lists.osgeo.org cc Objet Re: [mapserver-users] Layer based on a view renders faster than if based on a table steve.tout...@in

Re: [mapserver-users] Layer based on a view renders faster than if based on a table

steve.tout...@inspq.qc.ca wrote: I thought that a layer definition based on a table would be much faster than on a view. What should be the expected behavior please? Please tell me is this should be asked to postgis forum. I'd suggest you capture the exact SQL query that is run in each cas

[mapserver-users] Layer based on a view renders faster than if based on a table

Hi, I have a layer that renders faster when DATA is defined on a view than on a table with a clustered index. Here is the layer definition CONNECTIONTYPE postgis CONNECTION "host= dbname=xx user=xx password=xx port=5432" DATA "geom900913 FROM prevalence using unique id using srid=900913