ArcSDE on Oracle authentication times

[Mike Saunt]

Thanks Frank and Paul

Basically I guess we'll get everything setup here to link in FastCGI on
Windows with IIS.

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?

Is there a standard set of config / make files for MS4W that we could get to
use?
Also we'd be using in a couple of scenarios - standard MS4W and also
compiling against ArcSDE / Oracle.

If anyone can help with the config / make files it would be appreciated.
We'll post back our findings in January

Thanks in advance
Mike

 On 16/12/06, Frank Warmerdam <warmerdam at pobox.com> wrote:
>
> On 12/15/06, Mike Saunt <mikesaunt at gmail.com> wrote:
> > Hi All
> >
> > I have an installation that is using ArcSDE (8.3) in Oracle running on a
> Sun
> > box with MapServer CGI running on Windows.  I've seen a lot of previous
> > discussions regarding the authentication time impact of Oracle / ArcSDE
> and
> > in our case this is about 1 - 1.5 seconds per transaction i.e. map
> redraw,
> > spatial query etc.
> >
> > I'm wondering about options that would be available in the long term to
> try
> > to speed this up.
> > I'm not an Oracle guru but can the authentication be set as a priority
> > within there?
> > Is the only way to connection pool to ArcSDE for MapServer CGI via
> FastCGI
> > on Windows?
>
> Mike,
>
> Yes, I believe that MapServer SDE connections are pooled
> if you use MapServer in FastCGI mode, and if you add the
> PROCESSING "CLOSE_CONNECTION=DEFER" line
> to your SDE layer(s).
>
> Setting up FastCGI can be quite an effort.  There is a
> FastCGI howto on the mapserver site you should read
> over for some details.
>
> Best regards,
> --
>
> ---------------------------------------+--------------------------------------
> I set the clouds in motion - turn up   | Frank Warmerdam,
> warmerdam at pobox.com
> light and sound - activate the windows | http://pobox.com/~warmerdam
> and watch the world go round - Rush    | Geospatial Programmer for Rent
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapserver-users/attachments/20061217/068a8076/attachment.html