[postgis-users] Fwd: [Mapserver-users] WMS GetFeatureInfo on PostGIS slow?

[Bart van den Eijnden]

Hi,

I got no answer on the Mapserver list, maybe somebody here knows the 
answer. I am using the Win32 snapshot from Mark in combination with 
Mapserver 4.2 b3.

Is the performance problem caused by the fact that the cursor is not used 
for some reason?

Thanks in advance.

Best regards,
Bart

------- Forwarded message -------
From: Bart van den Eijnden <bartvde at xs4all.nl>
To: "mapserver-users at lists.gis.umn.edu" <mapserver-users at lists.gis.umn.edu>
Subject: [Mapserver-users] WMS GetFeatureInfo on PostGIS slow?
Date: Sun, 30 May 2004 14:53:37 +0200

> Hi list,
>
> I have started my first adventures with PostGIS and I am quite impressed 
> by the speed with which the map is drawn.
>
> I have a polygon layer with 1,5 million records.
>
> As I said, map performance is good. But when I use GetFeatureInfo on the 
> PostGIS layer, it takes more than 5 seconds for Mapserver to come back 
> with the result. In the PostgreSQL console I see:
>
> ERROR:  cursor "mycursor" does not exist
>
> Is this normal performance for GetFeatureInfo on PostGIS, or can I tweak 
> something to speed this up? I am using Mapserver 4.2 beta 3, as this is 
> the latest Win binary available.
>
> Thanks in advance.
>
> Best regards,
> Bart
> _______________________________________________
> Mapserver-users mailing list
> Mapserver-users at lists.gis.umn.edu
> http://lists.gis.umn.edu/mailman/listinfo/mapserver-users
>



--