ArcSDE on Oracle authentication times

[Mike Saunt]

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?

I'm obviously trying to maximize speed.

Thanks in advance

Mike
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20061215/0d35ce81/attachment.htm>