<br><font size=2 face="sans-serif">Thanks Alan, I didn't know that.</font>
<br><font size=2 face="sans-serif">Steve</font>
<br><font size=2 face="sans-serif"><br>
</font><font size=3 color=#0066ff><i>Steve Toutant, M. Sc.</i></font><font size=3><br>
Analyste en géomatique<br>
Secteur environnement<br>
Direction de la santé environnementale et de la toxicologie<br>
Institut national de santé publique du Québec<br>
945, avenue Wolfe<br>
Québec, Qc G1V 5B3 </font>
<p><font size=3>Tél.: (418) 650-5115 #5281<br>
Fax.: (418) 654-3144</font><font size=3 color=blue><u><br>
</u></font><a href=mailto:steve.toutant@inspq.qc.ca><font size=3 color=blue><u>steve.toutant@inspq.qc.ca</u></font></a><font size=3 color=blue><u><br>
</u></font><a href=http://www.inspq.qc.ca/><font size=3 color=blue><u>http://www.inspq.qc.ca</u></font></a>
<p><font size=3> </font>
<p>
<br>
<br>
<br>
<table width=100%>
<tr valign=top>
<td width=40%><font size=1 face="sans-serif"><b>Alan Boudreault <aboudreault@mapgears.com>@lists.osgeo.org</b>
</font>
<br><font size=1 face="sans-serif">Envoyé par : mapserver-users-bounces@lists.osgeo.org</font>
<p><font size=1 face="sans-serif">08/12/2009 09:39 AM</font>
<td width=59%>
<table width=100%>
<tr valign=top>
<td>
<div align=right><font size=1 face="sans-serif">A</font></div>
<td><font size=1 face="sans-serif">mapserver-users@lists.osgeo.org</font>
<tr valign=top>
<td>
<div align=right><font size=1 face="sans-serif">cc</font></div>
<td><font size=1 face="sans-serif">Steve.Toutant@inspq.qc.ca, Daniel Morissette
<dmorissette@mapgears.com>, mapserver-users-bounces@lists.osgeo.org</font>
<tr valign=top>
<td>
<div align=right><font size=1 face="sans-serif">Objet</font></div>
<td><font size=1 face="sans-serif">Re: [mapserver-users] Layer based on
a view renders faster than if
based on a table</font></table>
<br>
<table>
<tr valign=top>
<td>
<td></table>
<br></table>
<br>
<br>
<br>
<br>
<br><tt><font size=2>Steve, Have you put the "DEBUG 5" directive
at the layer level too ?<br>
<br>
Alan<br>
<br>
On December 8, 2009 09:36:27 am Steve.Toutant@inspq.qc.ca wrote:<br>
> Daniel,<br>
> I already set this in the mapfile<br>
> DEBUG 5<br>
> CONFIG MS_ERRORFILE "/ms4w/logs/mapserver.log"<br>
> <br>
> I don't get the SQL query in the log though.<br>
> <br>
> [Tue Dec 08 09:33:56 2009].961000 msDrawMap(): Layer 17 (RSSincidCumul),<br>
> 0.390s<br>
> [Tue Dec 08 09:33:56 2009].992000 msDrawMap(): Drawing Label Cache,
0.031s<br>
> [Tue Dec 08 09:33:56 2009].992000 msDrawMap() total time: 0.421s<br>
> [Tue Dec 08 09:33:57 2009].8000 msSaveImage() total time: 0.016s<br>
> [Tue Dec 08 09:33:57 2009].24000 mapserv request processing time<br>
> (msLoadMap not incl.): 0.453s<br>
> [Tue Dec 08 09:33:57 2009].24000 msFreeMap(): freeing map at 01516C50.<br>
> <br>
> Steve Toutant, M. Sc.<br>
> Analyste en géomatique<br>
> Secteur environnement<br>
> Direction de la santé environnementale et de la toxicologie<br>
> Institut national de santé publique du Québec<br>
> 945, avenue Wolfe<br>
> Québec, Qc G1V 5B3<br>
> Tél.: (418) 650-5115 #5281<br>
> Fax.: (418) 654-3144<br>
> steve.toutant@inspq.qc.ca<br>
> http://www.inspq.qc.ca<br>
> <br>
> <br>
> <br>
> <br>
> <br>
> Daniel Morissette <dmorissette@mapgears.com>@lists.osgeo.org<br>
> Envoyé par : mapserver-users-bounces@lists.osgeo.org<br>
> 04/12/2009 05:05 PM<br>
> <br>
> A<br>
> mapserver-users@lists.osgeo.org<br>
> cc<br>
> <br>
> Objet<br>
> Re: [mapserver-users] Layer based on a view renders faster than if
based<br>
> on a table<br>
> <br>
> Steve.Toutant@inspq.qc.ca wrote:<br>
> > I thought that a layer definition based on a table would be much
faster<br>
> > than on a view.<br>
> > What should be the expected behavior please?<br>
> ><br>
> > Please tell me is this should be asked to postgis forum.<br>
> <br>
> I'd suggest you capture the exact SQL query that is run in each case<br>
> (using DEBUG/MS_ERRORFILE) and check that the difference in time indeed<br>
> comes form the PostGIS queries.<br>
> <br>
> If that's the case then you could submit a question to the postgis
list<br>
> based on that, taking MapServer out of the equation.<br>
> <br>
> If on the other hand the queries take about the same time and the
time<br>
> difference is in MapServer's code (which I doubt) then we'd need more<br>
> details (ideally a testcase) to be able to reproduce and troubleshoot<br>
> the issue.<br>
> <br>
> Daniel<br>
> <br>
<br>
-- <br>
Alan Boudreault<br>
Mapgears<br>
http://www.mapgears.com<br>
_______________________________________________<br>
mapserver-users mailing list<br>
mapserver-users@lists.osgeo.org<br>
http://lists.osgeo.org/mailman/listinfo/mapserver-users<br>
</font></tt>
<br>
<br>
<br>