Mapserver & SDE 9.1 performance

[Hong]

I am also using MapServer 4.10 compiled with SDE 9.1. From my own observation,
compared to ArcIMS also connecting with SDE 9.1, the performance is about the
same. I would not say the performance is good, with neither of them, but in my
case, it is acceptable. Performance seems to depend on the complexity of the
geometry features as well.

I think performance on SDE layer stored on a remote database is always going
to be inferior compared to the performance on a shapefile stored on the local
environment.

I'm also using a custom compiled MapServer 4.10, a highly trimmed down version
with only the capabilities relevant in my project.

Hong

On Thu, Feb 01, 2007 at 08:19:36PM +0100, 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
> 
> -- 
> ATTENTION nous avons chang? de num?ros de t?l?phones
> PLEASE pay attention to our new phone numbers
> 
> Camptocamp SA
> Emmanuel BELO
> PSE A
> CH-1015 Lausanne
> 
> +41 21 619 10 25 (direct)
> +41 21 619 10 10 (centrale)
> +41 21 619 10 00 (fax)