[mapguide-users] Solve problem MySQL Polygon Selection

Rahul unicorn_admirer at yahoo.com
Tue Jul 31 03:15:08 EDT 2007


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 <dhirendra.mgos at gmail.com> 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 at 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 at 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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapguide-users/attachments/20070731/d68e9c67/attachment.html


More information about the mapguide-users mailing list