Cacheing and performce

[Fernando S.]

Hi Lyndon,
    I believe that this problem can exist, I don't know if exist a cache
for data but in 4.4.X and lastest versions exist a little cache for the
connections.
    Compiling mapserver with fatscgi support you can create a little
"cache" for your connections.(am I right?) So, one process of mapserver
remains in the memory of webserver, and every request for the mapserver
the fastcgi checks if don't exist any connection  in the memory if yes
the mapserver reuse this conection. It's very fast.
    If you didn't compile mapserver with fastcgi support the mapserver
create a little "cache" for your connection, but after to draw all of
the layers that you  selected the mapserver don't remains in memory.
    I don't know if this helped you, but fastcgi can be the best solution.
    Thanks.

------------------------------------------------------------------------
Fernando Simon
Mapserver and Oracle Spatial developer
G10 - Laboratorio de Computacao Aplicada - Brazil
http://g10.cttmar.univali.br - UNIVALI/CTTMAR
------------------------------------------------------------------------



Lyndon Tiu wrote:

> Hello,
>
> I just realized that if running mapserver on a machine and
> postgis/oraclespatial (whatever spatial db you may have) on another
> different machine, performance can be bad due to heavy network traffic.
>
> I notice that every map request I make, mapserver queries the db and the
> data (all of it) has to go through the network again and again.
>
> Any thought on this matter? Is there a cacheing machanism I can make use
> of to minimize network traffic.
>
> Thanks.
>
> --
> Lyndon Tiu
>