FastCGI , ArcSDE, mapserver testing performance

[Frank Warmerdam]

Ruben Pardo wrote:
> uhmm, thank very much, i see some tests that encorouge the use of fastcgi +
> mapserver + sde , for example ,
> 
> http://www.google.es/url?sa=t&ct=res&cd=1&url=http%3A%2F%2Fmapserver.gis.umn.edu%2Fcommunity%2Fconferences%2FMUM3%2Fpresent%2Fsession10%2Fmsvsarcims%2Fdownload&ei=H2zpRvvaLIWcxAGBjsnPBQ&usg=AFQjCNEyr-9v7X3rWR1OCBaqOsZNKSZ20w&sig2=LH3kWGSPeMXACXsO6m4Nqg 
> <http://www.google.es/url?sa=t&ct=res&cd=1&url=http%3A%2F%2Fmapserver.gis.umn.edu%2Fcommunity%2Fconferences%2FMUM3%2Fpresent%2Fsession10%2Fmsvsarcims%2Fdownload&ei=H2zpRvvaLIWcxAGBjsnPBQ&usg=AFQjCNEyr-9v7X3rWR1OCBaqOsZNKSZ20w&sig2=LH3kWGSPeMXACXsO6m4Nqg>
> 
> but i really don't know if  recently versions of mapserver doesn't need 
> fastcgi for increase performance.

Folks,

It is still my opinion that FastCGI can be very helpful for situations
where there are very high connection costs to a database.  The most
obvious examples of this are (I believe) Oracle Spatial and especially
SDE.  By contrast, disk files, and low connection cost databases like
postgres and mysql do not benefit significantly.

But I would also advise people to avoid it unless performance is killing
them and they believe it is due to high connection costs as FastCGI is
pretty darn tricky to setup and may be flakey/buggy.

Best regards,

> 2007/9/13, Gregor Mosheh < gregor at hostgis.com <mailto:gregor at hostgis.com>>:
> 
>     The last time I used Mapserver with FastCGI, I was informed that
>     there's
>     nothing in Mapserver that really benefits from FastCGI, and that support
>     was really just there for compatibility in case you're already using
>     FastCGI.
> 
>     --
>     Gregor Mosheh / Greg Allensworth
>     System Administrator, HostGIS cartographic development & hosting
>     services
>     http://www.HostGIS.com/
> 
>     "Remember that no one cares if you can back up,
>       only if you can restore." - AMANDA
> 
> 


-- 
---------------------------------------+--------------------------------------
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    | President OSGeo, http://osgeo.org