PostGIS vs. Shapefile

[Umberto Nicoletti]

Ciao Daniele,
Could be a name resolution problem. Are you using an ip address or a
host name to specify the postgres connection string?
If you are using a name please make sure that it can be resolved
correctly by registering it in dns and/or in the /etc/hosts file.

Did you try localhost in the connection string?
Also have a look at the log files in /var/lib/postgres/data.

HTH,
Umberto

On Thu, 2005-02-10 at 17:01 +0100, Daniele Margotti wrote:
> 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
> >
--
Umberto Nicoletti <unicoletti at prometeo.it>
Prometeo SRL