[Spam: 3.72] RE: [mapguide-users] PostGIS - what iswrongwhitthat?- my todo list

[Traian Stanev]

I just tried it with a layer with 100K polygons. It takes about 70 seconds for the layer to preview in MapGuide. I was watching the CPU usage during that time and about 70% of the time was spent in the postgres process (the rest was in the mgserver process, which includes the provider logic and OGR itself, and the rendering of the layer). So I place the blame on Postgres. I verified that the spatial indexing works -- once I zoom in things get much faster.

Traian
 

-----Original Message-----
From: mapguide-users-bounces at lists.osgeo.org [mailto:mapguide-users-bounces at lists.osgeo.org] On Behalf Of Maciej Skorczewski
Sent: Thursday, February 01, 2007 10:18 AM
To: MapGuide Users Mail List
Subject: Re: [Spam: 3.72] RE: [mapguide-users] PostGIS - what iswrongwhitthat?- my todo list


street table have about 15.000 rows - polylines

...but

when i use second test page whit  2 layers

firs layer have 900 row (forest area) polygons second 2000 row (see area) polygons

it works a lite faster but i see only one layer (this who is on top in Base layer group - i use ajax viewer).

I create gist index on the_geom column in both table.

Can you send a xml of your provider.xml file in FDO directory?
did you use this providers?
http://download.osgeo.org/fdo/3.2.0/

did you use one Data Connection to all layer? or one to one.


maciek




Traian Stanev napisał(a):
> The logic in the provider is the same for PostGIS and SHP -- so I think the slowness is not due to the provider itself but either due to the database being slower or the OGR driver doing more work in the case of PostGis. For example there may not be a spatial index for the features in the database -- but that's a wild guess. I'm curious though, how many street features do you have?
> 
> 
> Traian
>  
> 
> -----Original Message-----
> From: mapguide-users-bounces at lists.osgeo.org 
> [mailto:mapguide-users-bounces at lists.osgeo.org] On Behalf Of Maciej 
> Skorczewski
> Sent: Thursday, February 01, 2007 3:54 AM
> To: MapGuide Users Mail List
> Subject: Re: [Spam: 3.72] RE: [mapguide-users] PostGIS - what is 
> wrongwhitthat? - my todo list
> 
> Traian !
> 
> it works! BUT...veeery slow...for. ex layer whith streets load about 5 minuts...this same in shp load about 10sek.
> 
> so how can i make it faster. add index on table?
> 
> any sugestion?
> 
> 
> Maciej Skorczewski napisał(a):
>> hi Traian !
>>
>> it is still noting...i see that my web browser load some data but i 
>> can't see it. even after on/off layer in task pane.
>>
>> i add layer to map...
>>
>> I use ogr2ogr tool to convert shp files into PostgreSQL database.
>>
>> I use MG 1.1.0 and OGR 3.2.0
>>
>>
> _______________________________________________
> mapguide-users mailing list
> mapguide-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapguide-users
> 
> 
> _______________________________________________
> mapguide-users mailing list
> mapguide-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapguide-users
> 
_______________________________________________
mapguide-users mailing list
mapguide-users at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapguide-users