[mapserver-users] about Obtaing high performance in the map server response

[Stephen Woodbridge]

Do you have spatial index on all you geometry columns

create index <table>_gidx on <table> using gist(the_geom);

do this for each table and replace <table> wit the table name.
then do:

vacuum analyze;

If you are zoomed all the way out and displaying all the data, then this 
is the worse case and it may be slow. Does it speed up as you zoom in? 
Is the speed acceptable as you zoom in?

Do not display so much data as you zoom out and it will be faster. There 
you can generalize the data for when you zoom out. and then use 
MINSCALEDENOM and MAXSCALEDENOM to turn off the detail data layer and 
turn on the generalized data layer.

-Steve W.

fsalas wrote:
> Stephen,
> I Attached the map file
> I working with postgres/postgis with mapserver 5.2.0
> 
> best regards
> Francisco Salas
> 
> 
> ----- Original Message ----- From: "Stephen Woodbridge" 
> <woodbri at swoodbridge.com>
> To: "fsalas" <fsalas at geocuba.cu>
> Cc: "mapserver" <mapserver-users at lists.osgeo.org>
> Sent: Thursday, November 06, 2008 6:54 PM
> Subject: Re: [mapserver-users] about Obtaing high performance in the map 
> server response
> 
> 
>> fsalas wrote:
>>>
>>>
>>> I Have the following question, in this moment i have been working 
>>> with three layers but when i use the zoom or other tools , this 
>>> operation is very slow, my computer have a high performance
>>>
>>> What can i do for Obtaining high performance in the map server response
>>
>> There is a FAQ on performance IIRC.
>>
>> You need to explain more about your configuration.
>>
>> Show your mapfile.
>> Are you working with shapefiles, postgres, raster, vector, etc ...
>> How big are your files?
>> Have you turned on
>>
>> DEBUG 5
>> CONFIG MS_ERRORFILE "stderr"
>>
>> and looked at your apache error_log for each request? This should tell 
>> you how much time each layer takes to draw so you can see WHAT is slow?
>>
>> Give us some more info and we might be able to help you.
>>
>> -Stephen Woodbridge
>>  http://imaptools.com/
>>
> 
> 
> ___________________________________
> Dpto de Sistemas Informáticos
> Oficina Central Grupo Empresarial GEOCUBA
> Este mensaje esta libre de virus. Revisado por Kaspersky Antivirus
> ----------------------------------------------------------------------
> Engine version:  4.0.1.14
> Engine date:  2002/06/25
> Definition count:  1230006
> Definition date:  2008/11/06
> MDAV version: 2.2.8
>