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: [email protected] [mailto:[email protected]] On Behalf Of prabhat30 Sent: Thursday, April 14, 2011 8:06 AM To: [email protected] 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 [email protected] http://lists.osgeo.org/mailman/listinfo/mapguide-users _______________________________________________ mapguide-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapguide-users
