[Mapserver-users] WMS GetFeatureInfo on PostGIS slow?

[Bart van den Eijnden]

Just reporting back to the list, Paul Ramsey solved my problem on the 
PostGIS user list (thanks again).

I missed an index on my table:

create index top50_oid_idx on top50 (oid);

Best regards,
Bart

On Sun, 30 May 2004 14:53:37 +0200, Bart van den Eijnden 
<bartvde at xs4all.nl> wrote:

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



--