[mapguide-users] RE: RDBMS connection performance in Mapguide
martin.morrison at edsi.com
Thu Apr 14 08:12:50 EDT 2011
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.
Engineering Design Systems, Inc.
3780 Peters Creek Rd Ext SW
Roanoke, VA 24018
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 .
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
More information about the mapguide-users