Thanks Frank and Paul<br><br>Basically I guess we'll get everything setup here to link in FastCGI on Windows with IIS.<br><br>I'll get on to this quite soon but have one additional question for the guys who put together the MS4W binaries (as these are what we've used so far and worked very nicley) - is there anything special done when compiling MS4W?
<br><br>Is there a standard set of config / make files for MS4W that we could get to use?<br>Also we'd be using in a couple of scenarios - standard MS4W and also compiling against ArcSDE / Oracle.<br><br>If anyone can help with the config / make files it would be appreciated. We'll post back our findings in January
<br><br>Thanks in advance<br>Mike<br><br><div><span class="gmail_quote"> On 16/12/06, <b class="gmail_sendername">Frank Warmerdam</b> <<a href="mailto:warmerdam@pobox.com">warmerdam@pobox.com</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
On 12/15/06, Mike Saunt <<a href="mailto:mikesaunt@gmail.com">mikesaunt@gmail.com</a>> wrote:<br>> Hi All<br>><br>> I have an installation that is using ArcSDE (8.3) in Oracle running on a Sun<br>> box with MapServer CGI running on Windows. I've seen a lot of previous
<br>> discussions regarding the authentication time impact of Oracle / ArcSDE and<br>> in our case this is about 1 - 1.5 seconds per transaction i.e. map redraw,<br>> spatial query etc.<br>><br>> I'm wondering about options that would be available in the long term to try
<br>> to speed this up.<br>> I'm not an Oracle guru but can the authentication be set as a priority<br>> within there?<br>> Is the only way to connection pool to ArcSDE for MapServer CGI via FastCGI<br>> on Windows?
<br><br>Mike,<br><br>Yes, I believe that MapServer SDE connections are pooled<br>if you use MapServer in FastCGI mode, and if you add the<br>PROCESSING "CLOSE_CONNECTION=DEFER" line<br>to your SDE layer(s).<br><br>
Setting up FastCGI can be quite an effort. There is a<br>FastCGI howto on the mapserver site you should read<br>over for some details.<br><br>Best regards,<br>--<br>---------------------------------------+--------------------------------------
<br>I set the clouds in motion - turn up | Frank Warmerdam, <a href="mailto:warmerdam@pobox.com">warmerdam@pobox.com</a><br>light and sound - activate the windows | <a href="http://pobox.com/~warmerdam">http://pobox.com/~warmerdam
</a><br>and watch the world go round - Rush | Geospatial Programmer for Rent<br></blockquote></div><br>