[mapguide-users] FDO Postgis provider and schema override

[svlad]

What about foreign keys in your setup, you have to ignore them in the XML
schema
I had never problems with foreign keys

What about schema change, for instance when you create some new table? You
need to launch a script to create the appropriate feature sources
I add new tables via FDO, so the SetResource purges the schema mapping.
In addition to that we restart the MG server every night.
At every new MapGuide session I test the used datasources if there is a
config.xml, if not I create it.


What about repository size having hundreds of feature sources for db?
We have hundreds of tables the repository size is not the problem.

Did you optimize your postres db?
work_mem, shared_buffers, effective_cache_size, checkpoint_segments,
wal_buffers, checkpoint_completion_target, maintenance_work_mem

Did you optimize the MG serverconfig.ini?




--
View this message in context: http://osgeo-org.1560.x6.nabble.com/FDO-Postgis-provider-and-schema-override-tp5274210p5274819.html
Sent from the MapGuide Users mailing list archive at Nabble.com.