<div dir="ltr"><div class="gmail_extra"><div class="gmail_quote">Hi,</div><div class="gmail_quote"><br></div><div class="gmail_quote">On Tue, Jul 5, 2016 at 7:29 PM, svlad <span dir="ltr"><<a href="mailto:svlad.cjelli42@web.de" target="_blank">svlad.cjelli42@web.de</a>></span> wrote:<br></div></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);padding-left:1ex">What about foreign keys in your setup, you have to ignore them in the XML<br><span class="">
schema</span></blockquote><blockquote style="margin:0 0 0 40px;border:none;padding:0px"><div class="gmail_extra"><div class="gmail_quote"><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);padding-left:1ex">I had never problems with foreign keys</blockquote></div></div></blockquote><div class="gmail_extra"><div class="gmail_quote"><div><br></div><div>in my test xml schema if a table contains references to other tables there are references to those classes.</div><div>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.</div><div><br></div><div>Or maybe I don't understand correctly your setup.</div><div>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?</div><div><br></div><div> </div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);padding-left:1ex"><span class=""><br>
What about schema change, for instance when you create some new table? You<br>
need to launch a script to create the appropriate feature sources<br>
</span></blockquote></div></div><blockquote style="margin:0 0 0 40px;border:none;padding:0px"><div class="gmail_extra"><div class="gmail_quote"><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);padding-left:1ex">I add new tables via FDO, so the SetResource purges the schema mapping.</blockquote></div></div><div class="gmail_extra"><div class="gmail_quote"><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);padding-left:1ex">
In addition to that we restart the MG server every night.</blockquote></div></div><div class="gmail_extra"><div class="gmail_quote"><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);padding-left:1ex">
At every new MapGuide session I test the used datasources if there is a</blockquote></div></div><div class="gmail_extra"><div class="gmail_quote"><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);padding-left:1ex">
config.xml, if not I create it.</blockquote></div></div></blockquote>ok<br> <div><br><div class="gmail_extra"><div class="gmail_quote"><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);padding-left:1ex"><span class="">
What about repository size having hundreds of feature sources for db?<br>
</span></blockquote></div></div><blockquote style="margin:0 0 0 40px;border:none;padding:0px"><div class="gmail_extra"><div class="gmail_quote"><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);padding-left:1ex">We have hundreds of tables the repository size is not the problem.</blockquote></div></div></blockquote><div><br></div><div>ok</div><div><br></div><div> <br></div><div class="gmail_extra"><div class="gmail_quote"><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);padding-left:1ex">
Did you optimize your postres db?<br>
work_mem, shared_buffers, effective_cache_size, checkpoint_segments,<br>
wal_buffers, checkpoint_completion_target, maintenance_work_mem<br></blockquote><div><br></div><div>out of scope, but yes.</div><div>Its performance is quite good.</div><div> </div><div><br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);padding-left:1ex">
Did you optimize the MG serverconfig.ini?<br></blockquote><div><br></div><div>Reasonably yes.</div><div><br></div><div><br></div><div>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.</div><div><br></div><div>Best regards,</div><div><br></div><div>Gabriele Monfardini</div><div><br></div></div></div></div></div>