Hi Rahul, Thankyou for suggestion. I want to use free database i have not idea about OracleXE, it is free or not ? but i already test PostGIS. PostGIS is slow in compare of MySQL. In PostGIS when i select one polygon then polygon higlight after few second on my local machine. Any method to increase PostGIS performence ? 20 layers in my project so i think SQLite will be not good for this project. help me. Thankyou in Advance.
Regards, Dhirendrs Kumar Rahul-2 wrote: > > Hi, > I think you can try OracleXE and use King Oracle Provider 0.7.1 > or you can try PostGIS as both are much better Spatial Databases as > compared to MySQL. > > SDF uses SQLite inbuilt database so i think for small scale not for > enterprise solution SDF will also be an option to consider upon seriously. > > Cheers > Max > > Dhirendra Kumar <[EMAIL PROTECTED]> wrote: > > Hi Kenneth, > > Thankyou for replay and giving suggestion once again. I can't use Oracle > as > a FDO Database so for that resion i want use MySQL. you mentioned in 3rd > no. > points Use another provider, so which provider is better ? and another > thing > you mentioned transfer all data using sdf file. So i transfered all data > in > MySQL database using FDO2FDO, 1st i convert shp file to sdf and after that > importing sdf file in MySQL using FDO2FDO.Kenneth, any thing wrong in my > steps ? I am waiting for your suggestion. > > Regards, > Dhirendra Kumar > > > Kenneth, GEOGRAF A/S wrote: >> >> As someone else mentioned, the selection problem is a known bug in the >> MySQL provider. >> You have the following options: >> 1. Wait until someone fixes the problem. >> 2. Download source and fix it yourself (or perhaps pay someone to do it) >> 3. Use another provider >> >> If you MUST use a "real" database, I can only suggest Oracle (you have >> tried the others). >> Are there any reason that you cannot use SDF files? >> >> Regards, Kenneth, GEOGRAF A/S >> >> >> >> Dhirendra Kumar skrev: >>> Hi All, >>> >>> Sorry for repeating this qustion. I tested MS SQL server, MySQL, >>> Postgresql/postGIS and i got result MySQL performance is better in >>> compare >>> of all, but problem in polygon selection. I want to know that, no way to >>> solve this polygon selection problem ? :( >>> PROBLEM:- When i select some polygon then near polygon get highlighted >>> in >>> place of current selection. >>> If anyone have idea or suggestion then please help me. Thankyou in >>> Advance. >>> >>> Regards, >>> >>> Dhirendra Kumar >>> >> _______________________________________________ >> mapguide-users mailing list >> mapguide-users@lists.osgeo.org >> http://lists.osgeo.org/mailman/listinfo/mapguide-users >> >> > > -- > View this message in context: > http://www.nabble.com/Solve-problem-MySQL-Polygon-Selection-tf4170008s16610.html#a11918234 > 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 > > > > --------------------------------- > Building a website is a piece of cake. > Yahoo! Small Business gives you all the tools to get online. > _______________________________________________ > mapguide-users mailing list > mapguide-users@lists.osgeo.org > http://lists.osgeo.org/mailman/listinfo/mapguide-users > > -- View this message in context: http://www.nabble.com/Solve-problem-MySQL-Polygon-Selection-tf4170008s16610.html#a11919719 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