[mapguide-users] Solve problem MySQL Polygon Selection

Tue Jul 31 22:31:16 EDT 2007

Hi,
          Kindly refer to the below link regarding the implementing best practices for MapGuide,although its for MGE but same can be followed in MGOS.

  http://usa.autodesk.com/adsk/servlet/index?siteID=123112&id=7798553

  Regarding the fdo2fdo just go the website www.sl-king.com and download the the Zip file after that its quite simple and just follow the steps.

  Cheers
  Max !1

  Mansoureh Sadrykia <m_sadrykia at yahoo.com> wrote:
    Hi !

  Would you please give me some information about the Guide which you mentioned by the name "implementing best practices using the mapguide".
  My problem is: I have to work with databases and don't know any idea what to do, Unfortunately I have no proper guides for databases, What help files or documentations do you suggest for becoming familiar with 'how to get databases specially spatial ones work in mapguide'. I would be really thankful if you introduce me fdo2fdo and tell me how I can get and install it. 

  Lots of Thanks for your help,  

Rahul <unicorn_admirer at yahoo.com> wrote:
    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._______________________________________________
mapguide-users mailing list
mapguide-users at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapguide-users

---------------------------------
  Ready for the edge of your seat? Check out tonight's top picks on Yahoo! TV. _______________________________________________
mapguide-users mailing list
mapguide-users at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapguide-users

---------------------------------
Choose the right car based on your needs.  Check out Yahoo! Autos new Car Finder tool.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapguide-users/attachments/20070731/b4271c50/attachment.html