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"
<[EMAIL PROTECTED]>
To: "fsalas" <[EMAIL PROTECTED]>
Cc: "mapserver" <[email protected]>
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
_______________________________________________
mapserver-users mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/mapserver-users
