ArcSDE on Oracle authentication times

[Frank Warmerdam]

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