[mapguide-users] Solve problem MySQL Polygon Selection

[Rahul]

Hi,
      OracleXE is free to download ,you can check on oracle website,Regarding the slowness its nothing to do with PostGIS Database as i already used some other webGIS solutions and no problem regarding selection or anything ,may be something to do with OGR Provider(No Idea) may be better clarification required from Tarain or Kenneth.
   
  I think you try with SDF and 20 layers are not important ,the important thing is data size and if you follow the "Guide--implementing best practises using the MapGuide",i think u can work with 20 layers,just try to work through with SDF if you have no customer limitations regarding the Database.
   
  Cheers
  Max !!
  
Dhirendra Kumar <dhirendra.mgos at gmail.com> wrote:
  
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 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.

_______________________________________________
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/84ff17fb/attachment.html