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

[Traian Stanev]

Yes this is where the provider is posted. The dll dated from yesterday (Jan 31) is the latest one. When I tried it with PostGIS, it was 6 months ago, so it wasn't the same dll. This is what I have in providers.xml

  <FeatureProvider>
    <Name>OSGeo.OGR.0.1</Name>
    <DisplayName>FDO Provider for OGR </DisplayName>
    <Description>Read access to various file formats. </Description>
    <IsManaged>False</IsManaged>
    <Version>3.2.0.0</Version>
    <FeatureDataObjectsVersion>3.2.0.0</FeatureDataObjectsVersion>
    <LibraryPath>OGRProvider.dll</LibraryPath>
  </FeatureProvider>



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