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

[Bart van den Eijnden]

Hi Paul,

this is my DATA statement:

DATA "the_geom from top50"

I have created the following index:
CREATE INDEX top50_geom_idx ON top50 USING GIST (the_geom 
GIST_GEOMETRY_OPS);

Data was loaded through shp2pgsql.

Best regards,
Bart

On Tue, 01 Jun 2004 13:59:19 -0700, Paul Ramsey <pramsey at refractions.net> 
wrote:

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



--