Mapserver & SDE 9.1 performance

[Brock Anderson]

Emmanuel,

I have no idea why SDE is sending two responses, but...

are you using FastCGI?  I've found the ArcSDE connection overhead can 
take 1-2 seconds (per layer, per request).  Mapserver can use connection 
pooling to ease that problem, but only if you're running with FastCGI.

    http://mapserver.gis.umn.edu/docs/howto/fastcgi

Brock

Emmanuel BELO wrote:
> Dear list,
>
> we have installed Mapserver 4.10 compiled with SDE 9.1 support on a
> windows OS (IIS and PHP5 ISAPI). The application is working, but with
> poor performances: 9 to 64 times slower performances when rendering
> vector data from SDE than from an indexed shapefile exported from SDE
> (same dataset).
>
> We investigated and found:
>
> - mapserver renders data as fast with SDE than with SHP data, the
> difference is made between mapserver query to SDE and the end of SDE
> response.
>
> - after a mapserver query (for a point layer, without queries nor
> labels) SDE sends sequentially two responses with nearly the same size.
> In our case, each response is about 3 sec.
>
> So, we have two questions:
>
> - first: why does SDE answers twice?
> - is somebody using Mapserver/SDE with good performances?
>
> Best regards,
>
> Emmanuel BELO
>
>