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@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapguide-users