[mapguide-users] RE: RDBMS connection performance in Mapguide

[Zac Spitzer]

one of the golden rules for mapping performance is tuning your data.

for example, if you have very detailed datasets, say accurate to 5mm
and your rendering a map at a state level, your performance will be
be sub optimal.

To address this, you might need to make one or more copies of your
data, generalised so that it's only detailed enough for rendering the
layer accurately at the given scale.

The other solution is to use base layer groups, aka tiled maps for
the data which doesn't change as often. When the base maps need
updating, you just save the map definition which will flush the tile cache

z

On Thu, Apr 14, 2011 at 10:12 PM, Martin Morrison
<martin.morrison at edsi.com>wrote:

> Remove everything that is slow, that will make it fast...
>
> 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.
>
> Martin Morrison
> Application Engineer
> Engineering Design Systems, Inc.
> 3780 Peters Creek Rd Ext SW
> Roanoke, VA  24018
> 540.345.1410
> gis.edsi.com
>
>
> -----Original Message-----
> From: mapguide-users-bounces at lists.osgeo.org [mailto:
> mapguide-users-bounces at lists.osgeo.org] On Behalf Of prabhat30
> Sent: Thursday, April 14, 2011 8:06 AM
> To: mapguide-users at lists.osgeo.org
> Subject: [mapguide-users] RE: RDBMS connection performance in Mapguide
>
>  Thanks to all for yours valuable replays....
>
> I have tried in both server setup like , my application and database in one
> server and same in separate also. both the cases i have got same type of
> performance issue. i can't use file data system as i m having dynamic data
> so i have to use RDBMS.
>
> In my Database i have used Clustered index in primary field of each spatial
> tables(i,e featid ). so any thing else that u all can suggest me to add or
> remove from my tables for performance tuning.i want to know how this
> mapguide works ?? i mean how it fetch data from database ,is it uses featid
> field or some other field .....so that i can use more indexes on my tables
> .
>
> Prabhat
>
>
> --
> View this message in context:
> http://osgeo-org.1803224.n2.nabble.com/RDBMS-connection-performance-in-Mapguide-tp6245821p6272486.html
> Sent from the MapGuide Users mailing list archive at Nabble.com.
> _______________________________________________
> mapguide-users mailing list
> mapguide-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapguide-users
>
> _______________________________________________
> mapguide-users mailing list
> mapguide-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapguide-users
>



-- 
Zac Spitzer
Solution Architect / Director
Ennoble Consultancy Australia
http://www.ennoble.com.au
http://zacster.blogspot.com
+61 405 847 168
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapguide-users/attachments/20110415/7e199ed1/attachment.html