<DIV>Hi,</DIV> <DIV> 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. </DIV> <DIV> </DIV> <DIV>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.</DIV> <DIV> </DIV> <DIV>Cheers</DIV> <DIV>Max<BR><BR><B><I>Dhirendra Kumar <dhirendra.mgos@gmail.com></I></B> wrote:</DIV> <BLOCKQUOTE class=replbq style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #1010ff 2px solid"><BR>Hi Kenneth,<BR><BR>Thankyou for replay and giving suggestion once again. I can't use Oracle as<BR>a FDO Database so for that resion i want use MySQL. you mentioned in 3rd no.<BR>points Use another provider, so which provider is better ? and another thing<BR>you mentioned transfer all data using sdf file. So i transfered all data in<BR>MySQL database
using FDO2FDO, 1st i convert shp file to sdf and after that<BR>importing sdf file in MySQL using FDO2FDO.Kenneth, any thing wrong in my<BR>steps ? I am waiting for your suggestion.<BR><BR>Regards,<BR>Dhirendra Kumar<BR><BR><BR>Kenneth, GEOGRAF A/S wrote:<BR>> <BR>> As someone else mentioned, the selection problem is a known bug in the <BR>> MySQL provider.<BR>> You have the following options:<BR>> 1. Wait until someone fixes the problem.<BR>> 2. Download source and fix it yourself (or perhaps pay someone to do it)<BR>> 3. Use another provider<BR>> <BR>> If you MUST use a "real" database, I can only suggest Oracle (you have <BR>> tried the others).<BR>> Are there any reason that you cannot use SDF files?<BR>> <BR>> Regards, Kenneth, GEOGRAF A/S<BR>> <BR>> <BR>> <BR>> Dhirendra Kumar skrev:<BR>>> Hi All,<BR>>><BR>>> Sorry for repeating this qustion. I tested MS SQL server, MySQL,<BR>>>
Postgresql/postGIS and i got result MySQL performance is better in<BR>>> compare<BR>>> of all, but problem in polygon selection. I want to know that, no way to<BR>>> solve this polygon selection problem ? :(<BR>>> PROBLEM:- When i select some polygon then near polygon get highlighted in<BR>>> place of current selection.<BR>>> If anyone have idea or suggestion then please help me. Thankyou in<BR>>> Advance.<BR>>><BR>>> Regards,<BR>>><BR>>> Dhirendra Kumar<BR>>> <BR>> _______________________________________________<BR>> mapguide-users mailing list<BR>> mapguide-users@lists.osgeo.org<BR>> http://lists.osgeo.org/mailman/listinfo/mapguide-users<BR>> <BR>> <BR><BR>-- <BR>View this message in context: http://www.nabble.com/Solve-problem-MySQL-Polygon-Selection-tf4170008s16610.html#a11918234<BR>Sent from the MapGuide Users mailing list archive at
Nabble.com.<BR><BR>_______________________________________________<BR>mapguide-users mailing list<BR>mapguide-users@lists.osgeo.org<BR>http://lists.osgeo.org/mailman/listinfo/mapguide-users<BR></BLOCKQUOTE><BR><p> 
<hr size=1>Building a website is a piece of cake. <br>Yahoo! Small Business gives you <a href="http://us.rd.yahoo.com/evt=48251/*http://smallbusiness.yahoo.com/webhosting/?p=PASSPORTPLUS">all the tools to get online.</a>