[fdo-users] postgis and performance

[alucas]

Hello Mateusz,

In order to understand the problem, you need to read the entire post. In
summary, I'm testing the fdo provider with mapguide enterprise 2009 and I've
problems about the performance for reading large volumes of data (i.e layer
with aprox 500.000 records). Zac, told me that the problem could be in the
string matching that the provider need to do for column name in the "select
*" query. 

I've a question for you, if I create a spatial index in postgis (gist
index), the provider uses it?

Another problems occurs when I've a database with aprox 240 tables. From
Autocad Map 2009, the operation for reading the schemas is very expensive in
time. It takes aprox. 5 minutes for reading the schemas in this case, is
normal?

Thanks.



Mateusz Loskot wrote:
> 
> alucas pisze:
>> Hi zac,
>> 
>> But... Views are more slowly than tables. The best choice would be to
>> change
>> the provider to avoid this string matching.
> 
> I'm sorry but I couldn't follow the discussion very since the beginning,
> so I probably don't see the problem well.
> But could you specify what string matching you mean, in PostGIS provider?
> 
> I'm interested in implementing any optimization, but first I'd need to 
> see the idea well.
> 
> Here is SQL query used to retrieve all spatial tables in current
> datastore:
> 
> http://trac.osgeo.org/fdo/browser/trunk/Providers/PostGIS/Src/Provider/PgTablesReader.cpp#L261
> 
> Greetings
> -- 
> Mateusz Loskot, http://mateusz.loskot.net
> Charter Member of OSGeo, http://osgeo.org
> _______________________________________________
> fdo-users mailing list
> fdo-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/fdo-users
> 
> 
> -----
> -- 
> Mateusz Loskot
> http://mateusz.loskot.net
> 

-- 
View this message in context: http://www.nabble.com/postgis-and-performance-tp18653591p18698896.html
Sent from the FDO Users mailing list archive at Nabble.com.