AW: AW: AW: [mapserver-dev] speed up layer
displayingpostgis-mapserver
BrainDrain
paulborodaev at gmail.com
Wed Sep 3 01:24:02 EDT 2008
Yes )) it's related to bug1730
I spend hour investigating which dll hangs mapserv after updateing yo 2.2.8
well I found that it is mysql
and the next day I saw that version 2.2.9 relesed with just replaced dll
with older version))
SUSANNE wrote:
>
> I am using ms4w 2.2.8.
> Thanks a lot for your reply.
> Greetings from Austria, Susanne Kalliany
>
>
>
> BrainDrain wrote:
>>
>> I think I know what is your problem. What version of ms4w you're using?
>>
>> SUSANNE wrote:
>>>
>>> 120 tiles are 4*30 tiles (30 tiles for covering the screen, 4 layers).
>>> These tiles are empty at the beginning of the project because there are
>>> no
>>> data. During mapping I have a routine only to update changed tiles.
>>> Do you have a better idea?
>>> Thanks for helping, Susanne Kalliany
>>>
>>> -----Ursprüngliche Nachricht-----
>>> Von: mapserver-dev-bounces at lists.osgeo.org
>>> [mailto:mapserver-dev-bounces at lists.osgeo.org] Im Auftrag von BrainDrain
>>> Gesendet: Donnerstag, 21. August 2008 13:46
>>> An: mapserver-dev at lists.osgeo.org
>>> Betreff: Re: AW: AW: [mapserver-dev] speed up layer
>>> displayingpostgis-mapserver
>>>
>>>
>>> why you need 120 tiles at once? for what? 120... it will take a time,
>>> but it
>>> needless in most cases to generate so many in one operation.
>>> and why empty?
>>> try to use Proj4 projection string instead of epsg code.
>>>
>>> SUSANNE wrote:
>>>>
>>>> Excuse me; I sent my previous mail unintentionally!
>>>>
>>>> I am really afraid I am doing something basically wrong; but don't know
>>>> how
>>>> to go on.
>>>>
>>>> Thanks a lot for your help, Susanne Kalliany
>>>>
>>>>
>>>> -----Ursprüngliche Nachricht-----
>>>> Von: mapserver-dev-bounces at lists.osgeo.org
>>>> [mailto:mapserver-dev-bounces at lists.osgeo.org] Im Auftrag von Susanne
>>>> Kalliany
>>>> Gesendet: Donnerstag, 21. August 2008 12:50
>>>> An: 'BrainDrain'; mapserver-dev at lists.osgeo.org
>>>> Betreff: AW: AW: [mapserver-dev] speed up layer displaying
>>>> postgis-mapserver
>>>>
>>>> Sorry for being so nasty.
>>>> I did like you told:
>>>>
>>>> LAYER
>>>> NAME zobject1
>>>> GROUP zobject1
>>>> STATUS ON
>>>> MAXSCALE 30000
>>>> TYPE POLYGON
>>>> CONNECTIONTYPE postgis
>>>> CONNECTION 'user=postgres password=susi dbname=tefisdb
>>>> host=localhost
>>>> port=5432'
>>>> DATA 'the_geom FROM zobject1 USING UNIQUE gid1 USING SRID=31282'
>>>> PROCESSING 'CLOSE_CONNECTION=DEFER'
>>>> PROJECTION
>>>> 'init=epsg:31282'
>>>> END
>>>>
>>>> But nevertheless for drawing 4 (empty) postgis layers -120 tiles
>>>> 256*256 I
>>>> need 3.5 minutes.
>>>>
>>>>
>>>> -----Ursprüngliche Nachricht-----
>>>> Von: mapserver-dev-bounces at lists.osgeo.org
>>>> [mailto:mapserver-dev-bounces at lists.osgeo.org] Im Auftrag von
>>>> BrainDrain
>>>> Gesendet: Mittwoch, 20. August 2008 21:15
>>>> An: mapserver-dev at lists.osgeo.org
>>>> Betreff: Re: AW: [mapserver-dev] speed up layer displaying
>>>> postgis-mapserver
>>>>
>>>>
>>>> -how did you import your layer data into postgres table? did you use
>>>> GIST
>>>> indexing?
>>>> did you use PROCESSING "CLOSE_CONNECTION=DEFER" for your layer?
>>>> did you reproject your data?
>>>>
>>>> cluster <gindexname> on <tablename> - just a sql command which you can
>>>> run
>>>> in context of postgis database using psql console app or pgAgmin utils
>>>> or
>>>> other software that helps pgsql developers. This command creates
>>>> "physically-allocated" gindex which can boost perfomance for large
>>>> layers.
>>>>
>>>> I have some layers with 180000-190000 polygons and mapserv draws
>>>> 256x256
>>>> tiles pretty fast for my ajax powered webapp.
>>>>
>>>>
>>>> SUSANNE wrote:
>>>>>
>>>>> Thanks a lot for reply!
>>>>> I inserted following line and now postgis query works fine.
>>>>> "DATA 'the_geom FROM zobject1 USING UNIQUE gid USING SRID=31282'"
>>>>>
>>>>> But I don't get on with optimization.
>>>>> On which place do I have to insert: "cluster gindexname on tablename"
>>>>> ?
>>>>> I inserted in postgresql.conf:
>>>>> # AUTOVACUUM PARAMETERS
>>>>> #---------------------------------------------------------
>>>>> vacuum full
>>>>>
>>>>> For me it didn't make any effort.
>>>>> And I am worried because there is only one feature in postgis table,
>>>>> nevertheless one redraw from database needs more than 2 minute (I
>>>>> created
>>>>> 30
>>>>> png tiles 256*256 RGB 24bit).
>>>>> I am afraid I am doing something basically wrong!?
>>>>> Many thanks in advance for your kind efforts
>>>>> Susanne Kalliany
>>>>>
>>>>> ----Ursprüngliche Nachricht-----
>>>>> Von: mapserver-dev-bounces at lists.osgeo.org
>>>>> [mailto:mapserver-dev-bounces at lists.osgeo.org] Im Auftrag von
>>>>> BrainDrain
>>>>> Gesendet: Dienstag, 19. August 2008 12:31
>>>>> An: mapserver-dev at lists.osgeo.org
>>>>> Betreff: Re: [mapserver-dev] speed up layer displaying
>>>>> postgis-mapserver
>>>>>
>>>>>
>>>>> 1. DATA "geom from public.construct >>>>USING UNIQUE [id field name]
>>>>> USING
>>>>> SRID=[your srid or -1 (not recom.)]<<<<" for all postgis layers
>>>>> this solves problem with msPOSTGISLayerRetrievePGVersion
>>>>> 2. I use cluster gindexname on tablename & vacuum full. +
>>>>> http://www.powerpostgresql.com/Downloads/annotated_conf_80.html
>>>>>
>>>>>
>>>>>
>>>>> SUSANNE wrote:
>>>>>>
>>>>>> Dear Mapserver List!
>>>>>>
>>>>>> I am developing Mapserver-application (ms4w 2.2.7, postgres 1.8.2)
>>>>>> since
>>>>>> half a year. Now some debugging and optimization work has to be done.
>>>>>> I am doing quite well with programming, but I am not very experienced
>>>>>> in
>>>>>> installation - optimization issues.
>>>>>>
>>>>>> I would be very grateful for some hints to answer the follwing
>>>>>> questions
>>>>>> or how to improve performance generally.
>>>>>>
>>>>>> 1. How can I get rid of following error:
>>>>>> msPOSTGISLayerRetrievePGVersion(): Query error. Error executing
>>>>>> POSTGIS
>>>>>> statement (msPOSTGISLayerRetrievePGVersion():select
>>>>>> substring(version()
>>>>>> from 12 for (position('on' in version()) - 13))
>>>>>> I did some in internet searches but I could'nt take head or tale of
>>>>>> it.
>>>>>>
>>>>>> 2. Should I increase max_buffer in postgresql.conf?
>>>>>> I found the tip
>>>>>> (http://mapserver.gis.umn.edu/docs/howto/optimizevector/html2pdf),
>>>>>> but I
>>>>>> don't have such an item in my postgres.conf file and also don't know
>>>>>> which
>>>>>> value I have to set.
>>>>>>
>>>>>> 3. How to improve displaying of 5 postgres-supported editable layer.
>>>>>> It
>>>>>> takes some time even when these layers are empty!?
>>>>>> (Installation uses kaMap in javascript-php enviroment)
>>>>>>
>>>>>> thanks a lot, Susanne Kalliany
>>>>>>
>>>>>
>>>>> --
>>>>> View this message in context:
>>>>>
>>>>
>>> http://www.nabble.com/speed-up-layer-displaying-postgis-mapserver-tp19032703
>>>>> p19047825.html
>>>>> Sent from the Mapserver - Dev mailing list archive at Nabble.com.
>>>>>
>>>>> _______________________________________________
>>>>> mapserver-dev mailing list
>>>>> mapserver-dev at lists.osgeo.org
>>>>> http://lists.osgeo.org/mailman/listinfo/mapserver-dev
>>>>>
>>>>> _______________________________________________
>>>>> mapserver-dev mailing list
>>>>> mapserver-dev at lists.osgeo.org
>>>>> http://lists.osgeo.org/mailman/listinfo/mapserver-dev
>>>>>
>>>>>
>>>>
>>>> --
>>>> View this message in context:
>>>>
>>> http://www.nabble.com/speed-up-layer-displaying-postgis-mapserver-tp19032703
>>>> p19076195.html
>>>> Sent from the Mapserver - Dev mailing list archive at Nabble.com.
>>>>
>>>> _______________________________________________
>>>> mapserver-dev mailing list
>>>> mapserver-dev at lists.osgeo.org
>>>> http://lists.osgeo.org/mailman/listinfo/mapserver-dev
>>>>
>>>> _______________________________________________
>>>> mapserver-dev mailing list
>>>> mapserver-dev at lists.osgeo.org
>>>> http://lists.osgeo.org/mailman/listinfo/mapserver-dev
>>>>
>>>> _______________________________________________
>>>> mapserver-dev mailing list
>>>> mapserver-dev at lists.osgeo.org
>>>> http://lists.osgeo.org/mailman/listinfo/mapserver-dev
>>>>
>>>>
>>>
>>> --
>>> View this message in context:
>>> http://www.nabble.com/speed-up-layer-displaying-postgis-mapserver-tp19032703
>>> p19087077.html
>>> Sent from the Mapserver - Dev mailing list archive at Nabble.com.
>>>
>>> _______________________________________________
>>> mapserver-dev mailing list
>>> mapserver-dev at lists.osgeo.org
>>> http://lists.osgeo.org/mailman/listinfo/mapserver-dev
>>>
>>> _______________________________________________
>>> mapserver-dev mailing list
>>> mapserver-dev at lists.osgeo.org
>>> http://lists.osgeo.org/mailman/listinfo/mapserver-dev
>>>
>>>
>>
>>
>
>
--
View this message in context: http://www.nabble.com/speed-up-layer-displaying-postgis-mapserver-tp19032703p19283092.html
Sent from the Mapserver - Dev mailing list archive at Nabble.com.
More information about the mapserver-dev
mailing list