<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<TITLE>Messaggio</TITLE>
<META content="MSHTML 6.00.2900.2604" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT face=Arial size=2><SPAN class=076185409-10022005>Hi
all,</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=076185409-10022005>I have made
some spatial queries (with cgi-bin Mapserver 4.2.3) alternately with data
stored in shapefiles and PostGIS (imported from these
shapefiles).</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=076185409-10022005></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=076185409-10022005>My query (304
elements on 5 layers) takes 5 seconds (elaboration, and then output on browser)
if data are read from shapefiles, and about 50 seconds if data are read from
PostGIS.</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=076185409-10022005></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=076185409-10022005>The query is the
same: I simply press "reload" on my browser (after manually changed .map file
and query template files) to be sure of it...</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=076185409-10022005></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=076185409-10022005>Is it
normal?</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=076185409-10022005></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=076185409-10022005>
Daniele</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=076185409-10022005></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN
class=076185409-10022005></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN
class=076185409-10022005>P.S.:</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=076185409-10022005>My system is a Linux
Red Hat 9.</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=076185409-10022005></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=076185409-10022005>My mapserver
is:</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=076185409-10022005>$ ./mapserv
-v<BR>MapServer version 4.2.3 OUTPUT=GIF OUTPUT=PNG OUTPUT=JPEG OUTPUT=WBMP
OUTPUT=PDF SUPPORTS=PROJ SUPPORTS=FREETYPE SUPPORTS=WMS_SERVER
SUPPORTS=WMS_CLIENT SUPPORTS=WFS_CLIENT INPUT=EPPL7 INPUT=POSTGIS INPUT=OGR
INPUT=GDAL INPUT=SHAPEFILE</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=076185409-10022005></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=076185409-10022005>Postgresql and
PostGIS are installed from RPMs (the version is:
postgresql-postgis-7.3.4-3.rri1.i386.rpm).</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=076185409-10022005></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN
class=076185409-10022005></SPAN></FONT> </DIV></BODY></HTML>