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

[Martin Morrison]

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