keep in mind mysql is a limited spatial implementation and it only supports MBR type spatial queries
the sqlLite fdo is rumoured to be much better performance wise than SHP/SDF especially because you can add non spatial indexes which sdf/shp do not have if you using filters on your layers, performance will be better via a real database server, tho as mentioned above sql lite should get closer z On Fri, Sep 18, 2009 at 3:09 PM, T.kiran kumar reddy <[email protected]> wrote: > > Compare to the shp files oracle is working faster, presently we are > converting shp to oracle spatial table through the mapbuilder, performence > is fine in our projects we are working upto the four lakhs records ,i know > upto this level performence is good. > > Srinivas Raparthi wrote: >> >> Dear Kiran, >> >> Well presently we are working on flat files SHP/SDF for entire North >> America data and planning to advance flat files to oracle spatial 10g for >> better performance. >> >> Can you let us know the performance using oracle 10g and the data you are >> working on.. >> >> Thanks >> Srinivas Raparthi. >> >> >> T.kiran kumar reddy wrote: >>> >>> hi to every one, >>> Presently i am using the mgos2.0,maestro r3911 , asp.net2.0, >>> orcale 10g with spatial support, i want to change to either mysql or >>> microsoft sequel server or post gre sql server which one is better to >>> support spatial data or with performence in all other issues , is >>> spatilal data is supported by all these databases? if any body uses these >>> databases please tell abuot these data bases performences >>> >>> >> >> > > -- > View this message in context: > http://n2.nabble.com/about-the-databases-tp3610107p3667737.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 > -- Zac Spitzer - http://zacster.blogspot.com +61 405 847 168 _______________________________________________ mapguide-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapguide-users
