Mapserver & SDE 9.1 performance

[Emmanuel BELO]

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)