[fdo-users] postgis and performance

[alucas]

Hi zac,

But... Views are more slowly than tables. The best choice would be to change
the provider to avoid this string matching.

Regards.


zspitzer wrote:
> 
> For better performance, try using views on your tables which only
> expose the minimal
> set of columns you require.
> 
> Mapguide does "select * from table" which slows things down a lot,
> because each column
> is accessed via name rather than index and that's a lot of string
> matching..
> 
> http://trac.osgeo.org/mapguide/ticket/272
> 
> i.e. with a 500k row table, each additional column is now involved in
> another 500k of string matches
> 
> Regards
> 
> Zac
> 
> On Sat, Jul 26, 2008 at 1:09 AM, alucas <alucas at srtec.com> wrote:
>>
>> Hello List,
>>
>> I'm testing postgis to store some Gregraphic layers and publish this data
>> to
>> the internet via Mapguide Enterprise 2009. I've performance problems to
>> publish some large volumes of vector data. For example, mapguide can't
>> preview (with Autodesk Mapguide Studio) one layer with 140.000 records. I
>> need to publish some layers with aprox 500.000 records
>>
>> So, I need to manage large volume data sets with postgis and mapguide and
>> I've some questions:
>>
>> - In the unit tests for the postgis provider, what are the volumes of
>> data
>> tested?
>> - I've loaded the data into postgis via shp2pgsql. I don't know if the
>> default database created via shp2pgsql is the best for the postgis
>> provider
>> performance. It's possible to improve the database performance for
>> example
>> creating some gist indexes? If yes, how can I create the optimal index to
>> achieve the best performance in queries?
>>
>> To summarize, I need some help for optimize my postgis datastore...
>>
>> Some useful information about the system:
>>
>> MGE 2009
>> Autodesk Mapguide Studio 2009
>> Postgis 8.2.9
>> Postgis 1.3.3
>> FDO provider for postgis: 3.3.0 (Downloaded from GeoMap web page)
>>
>> Thanks in advance.
>>
>>
>> --
>> View this message in context:
>> http://www.nabble.com/postgis-and-performance-tp18653591p18653591.html
>> Sent from the FDO Users mailing list archive at Nabble.com.
>>
>> _______________________________________________
>> fdo-users mailing list
>> fdo-users at lists.osgeo.org
>> http://lists.osgeo.org/mailman/listinfo/fdo-users
>>
> 
> 
> 
> -- 
> Zac Spitzer -
> http://zacster.blogspot.com (My Blog)
> +61 405 847 168
> _______________________________________________
> fdo-users mailing list
> fdo-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/fdo-users
> 
> 

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