one of the golden rules for mapping performance is tuning your data.<br><br>for example, if you have very detailed datasets, say accurate to 5mm<br>and your rendering a map at a state level, your performance will be<br>be sub optimal.<br>
<br>To address this, you might need to make one or more copies of your<br>data, generalised so that it's only detailed enough for rendering the <br>layer accurately at the given scale.<br><br>The other solution is to use base layer groups, aka tiled maps for<br>
the data which doesn't change as often. When the base maps need <br>updating, you just save the map definition which will flush the tile cache<br><br>z<br><br><div class="gmail_quote">On Thu, Apr 14, 2011 at 10:12 PM, Martin Morrison <span dir="ltr"><<a href="mailto:martin.morrison@edsi.com">martin.morrison@edsi.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">Remove everything that is slow, that will make it fast...<br>
<br>
Seriously, we don't know your schema, so how do we know what to suggest? Do you have 1 table with 2 cols? 100 tables with 50 cols in each table and joins on a text field among all of them? We need details in order to help.<br>
<font color="#888888"><br>
Martin Morrison<br>
Application Engineer<br>
Engineering Design Systems, Inc.<br>
3780 Peters Creek Rd Ext SW<br>
Roanoke, VA 24018<br>
<a href="tel:540.345.1410" value="+15403451410">540.345.1410</a><br>
<a href="http://gis.edsi.com" target="_blank">gis.edsi.com</a><br>
</font><div><div></div><div class="h5"><br>
<br>
-----Original Message-----<br>
From: <a href="mailto:mapguide-users-bounces@lists.osgeo.org">mapguide-users-bounces@lists.osgeo.org</a> [mailto:<a href="mailto:mapguide-users-bounces@lists.osgeo.org">mapguide-users-bounces@lists.osgeo.org</a>] On Behalf Of prabhat30<br>
Sent: Thursday, April 14, 2011 8:06 AM<br>
To: <a href="mailto:mapguide-users@lists.osgeo.org">mapguide-users@lists.osgeo.org</a><br>
Subject: [mapguide-users] RE: RDBMS connection performance in Mapguide<br>
<br>
Thanks to all for yours valuable replays....<br>
<br>
I have tried in both server setup like , my application and database in one<br>
server and same in separate also. both the cases i have got same type of<br>
performance issue. i can't use file data system as i m having dynamic data<br>
so i have to use RDBMS.<br>
<br>
In my Database i have used Clustered index in primary field of each spatial<br>
tables(i,e featid ). so any thing else that u all can suggest me to add or<br>
remove from my tables for performance tuning.i want to know how this<br>
mapguide works ?? i mean how it fetch data from database ,is it uses featid<br>
field or some other field .....so that i can use more indexes on my tables .<br>
<br>
Prabhat<br>
<br>
<br>
--<br>
View this message in context: <a href="http://osgeo-org.1803224.n2.nabble.com/RDBMS-connection-performance-in-Mapguide-tp6245821p6272486.html" target="_blank">http://osgeo-org.1803224.n2.nabble.com/RDBMS-connection-performance-in-Mapguide-tp6245821p6272486.html</a><br>
Sent from the MapGuide Users mailing list archive at Nabble.com.<br>
_______________________________________________<br>
mapguide-users mailing list<br>
<a href="mailto:mapguide-users@lists.osgeo.org">mapguide-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/mapguide-users" target="_blank">http://lists.osgeo.org/mailman/listinfo/mapguide-users</a><br>
<br>
_______________________________________________<br>
mapguide-users mailing list<br>
<a href="mailto:mapguide-users@lists.osgeo.org">mapguide-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/mapguide-users" target="_blank">http://lists.osgeo.org/mailman/listinfo/mapguide-users</a><br>
</div></div></blockquote></div><br><br clear="all"><br>-- <br>Zac Spitzer <br>Solution Architect / Director<br>Ennoble Consultancy Australia<br><a href="http://www.ennoble.com.au">http://www.ennoble.com.au</a><br><a href="http://zacster.blogspot.com">http://zacster.blogspot.com</a><br>
+61 405 847 168<br><br><br><br>