<br><font size=2 face="sans-serif">Daniel,</font>
<br><font size=2 face="sans-serif">I already set this in the mapfile</font>
<br><font size=2 face="sans-serif"> DEBUG 5
</font>
<br><font size=2 face="sans-serif"> CONFIG MS_ERRORFILE "/ms4w/logs/mapserver.log"</font>
<br>
<br><font size=2 face="sans-serif">I don't get the SQL query in the log
though.</font>
<br>
<br><font size=2 face="sans-serif">[Tue Dec 08 09:33:56 2009].961000 msDrawMap():
Layer 17 (RSSincidCumul), 0.390s</font>
<br><font size=2 face="sans-serif">[Tue Dec 08 09:33:56 2009].992000 msDrawMap():
Drawing Label Cache, 0.031s</font>
<br><font size=2 face="sans-serif">[Tue Dec 08 09:33:56 2009].992000 msDrawMap()
total time: 0.421s</font>
<br><font size=2 face="sans-serif">[Tue Dec 08 09:33:57 2009].8000 msSaveImage()
total time: 0.016s</font>
<br><font size=2 face="sans-serif">[Tue Dec 08 09:33:57 2009].24000 mapserv
request processing time (msLoadMap not incl.): 0.453s</font>
<br><font size=2 face="sans-serif">[Tue Dec 08 09:33:57 2009].24000 msFreeMap():
freeing map at 01516C50.</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>Daniel Morissette <dmorissette@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">04/12/2009 05:05 PM</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>
<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.Toutant@inspq.qc.ca wrote:<br>
> <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>
<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>
Daniel Morissette<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>