Re: [mapguide-users] FDO Postgis provider and schema override

[Gabriele Monfardini]

Hi,

On Tue, Jul 5, 2016 at 7:29 PM, svlad  wrote:

> What about foreign keys in your setup, you have to ignore them in the XML
> schema

I had never problems with foreign keys


in my test xml schema if a table contains references to other tables there
are references to those classes.
If you make a FeatureSource for this table, do you include the referenced
tables definition in the config.xml or do you omit the foreign key? I think
tertium non datur.

Or maybe I don't understand correctly your setup.
Do you create a FeatureSource for each table, with a config.xml that
describe only that table and optionally override it in order to specify the
attribute to use as primary key? Am I correct?



>
> 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.

ok


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


ok



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

out of scope, but yes.
Its performance is quite good.


Did you optimize the MG serverconfig.ini?
>

Reasonably yes.


In my current setup I have a FeatureSource for each database, so I think I
can use schema override in a similar setup (one FS for database), but
apparently XML seems so long that Mapguide have problems using it.

Best regards,

Gabriele Monfardini
___
mapguide-users mailing list
mapguide-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapguide-users

Re: [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.
___
mapguide-users mailing list
mapguide-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapguide-users

Re: [mapguide-users] FDO Postgis provider and schema override

[Gabriele Monfardini]

On Tue, Jul 5, 2016 at 4:30 PM, svlad  wrote:

> The schema override works.
> I do it programmatically with the API and create for each table one data
> source with one config.xml.
> The only caveat is, I can not create new features via FDO.
>

Thank you for your answer.

What about foreign keys in your setup, you have to ignore them in the XML
schema

What about schema change, for instance when you create some new table? You
need to launch a script to create the appropriate feature sources

What about repository size having hundreds of feature sources for db?

Best regards,

Gabriele Monfardini
___
mapguide-users mailing list
mapguide-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapguide-users

Re: [mapguide-users] FDO Postgis provider and schema override

[svlad]

The schema override works.
I do it programmatically with the API and create for each table one data
source with one config.xml.
The only caveat is, I can not create new features via FDO.



--
View this message in context: 
http://osgeo-org.1560.x6.nabble.com/FDO-Postgis-provider-and-schema-override-tp5274210p5274786.html
Sent from the MapGuide Users mailing list archive at Nabble.com.
___
mapguide-users mailing list
mapguide-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapguide-users

Re: [mapguide-users] FDO Postgis provider and schema override

[Gabriele Monfardini]

Thank you for your reply.

It takes a lot of time, but GETSCHEMAMAPPING outputs xml schema, and it is
quite long.

However if I add the xml as a configuration file to the feature source,
validation of the feature source takes a lot of time (tens of minutes).
Apparently it founds an error in the XML (the error log says there is a
mismatch between the identitiy property and the reverse identity property
of a foreign key) and recheck the feature source over and over for each
layer of the map.

I cannot even say if schema override works, since the first time the map is
opened it takes ages, apparently doing the same checks on the feature
source.

Best regards,

Gabriele Monfardini

---
Vivi come se dovessi morire domani, impara come se dovessi vivere per sempre

Mahatma Gandhi

On Thu, Jun 30, 2016 at 8:32 PM, vd2  wrote:

> To get the schema you could also use the web tier test
> GETSCHEMAINFO
> Unbenannt.PNG
> 
>
>
>
> --
> View this message in context:
> http://osgeo-org.1560.x6.nabble.com/FDO-Postgis-provider-and-schema-override-tp5274210p5274227.html
> Sent from the MapGuide Users mailing list archive at Nabble.com.
> ___
> mapguide-users mailing list
> mapguide-users@lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapguide-users
>
___
mapguide-users mailing list
mapguide-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapguide-users

Re: [mapguide-users] FDO Postgis provider and schema override

[vd2]

To get the schema you could also use the web tier test
GETSCHEMAINFO
Unbenannt.PNG
  



--
View this message in context: 
http://osgeo-org.1560.x6.nabble.com/FDO-Postgis-provider-and-schema-override-tp5274210p5274227.html
Sent from the MapGuide Users mailing list archive at Nabble.com.
___
mapguide-users mailing list
mapguide-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapguide-users