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

[Maciej Skorczewski]

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
>