On 12/15/06, Mike Saunt <[EMAIL PROTECTED]> 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, [EMAIL PROTECTED]
light and sound - activate the windows | http://pobox.com/~warmerdam
and watch the world go round - Rush | Geospatial Programmer for Rent
