[mapguide-users] Solve problem MySQL Polygon Selection

[Dhirendra Kumar]

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 <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.
> _______________________________________________
> 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#a11919719
Sent from the MapGuide Users mailing list archive at Nabble.com.