PostGIS vs. Shapefile

[Daniele Margotti]

Hi all,
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).

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.

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...

Is it normal?

    Daniele


P.S.:
My system is a Linux Red Hat 9.

My mapserver is:
$ ./mapserv -v
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

Postgresql and PostGIS are installed from RPMs (the version is:
postgresql-postgis-7.3.4-3.rri1.i386.rpm).


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20050210/d634336b/attachment.htm>