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

[Paul Ramsey]

What is your DATA statement, and what indexes do you have on your table?

Bart van den Eijnden wrote:
> 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
>>
> 
> 
> 


-- 
       __
      /
      | Paul Ramsey
      | Refractions Research
      | Email: pramsey at refractions.net
      | Phone: (250) 885-0632
      \_