PostGIS vs. Shapefile

[Daniele Margotti]

Yes, Mapserver is in the same computer of PostGIS: a Linux Red Hat 9.
Computer is rather fast: I can dump a 33000-row table (14 Mb dumped to
file) in about 3 seconds.

And also when I connect from a Windows XP (via Lan) using ODBC drivers,
data are read very fast.

Only Mapserver is slow...

        Daniele


>-----Original Message-----
>From: UMN MapServer Users List [mailto:MAPSERVER-USERS at LISTS.UMN.EDU]
On Behalf Of Lyndon Tiu
>Sent: Thursday, February 10, 2005 4:36 PM
>To: MAPSERVER-USERS at LISTS.UMN.EDU
>Subject: Re: [UMN_MAPSERVER-USERS] PostGIS vs. Shapefile
>
>
>On February 10, 2005 02:03 am, Daniele Margotti wrote:
>> 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?
>>
>
>Is Postgis in the same computer as mapserver?
>
>--
>Lyndon Tiu
>