[mapguide-users] Solve problem MySQL Polygon Selection

Kenneth, GEOGRAF A/S ks at geograf.dk
Fri Aug 3 05:05:18 EDT 2007


I'm sorry, but I never had that problem with OGR,
and I have no idea what may be causing it.

Regards, Kenneth, GEOGRAF A/S



Dhirendra Kumar skrev:
> Hi Kenneth,
>
> Now i established connection with OGR provider and MGOS1.2.0RC2, i can make
> layer also Performance is good. but when i select any polygon then polygon
> not get selected. I established connection using OGR provider
> (OGRProvider-3.2.2.win32.zip). Kenneth please help me once agian. Thankyou
> in Advance
>
> Regards,
> Dhirendra Kumar
>
>
> Kenneth, GEOGRAF A/S wrote:
>   
>> I have no experience with the PostGIS provider.
>> I had no delays using OGR for PostGIS data.
>>
>> Regards Kenneth, GEOGRAF A/S
>>
>>
>>
>> Dhirendra Kumar skrev:
>>     
>>> Hi Kenneth,
>>>
>>> I make layer using PostGIS provider not OGR Provider. No problems with
>>> tooltips, it is working fine. only problem with polygon selection taking
>>> 4
>>> second to highlight. OGR Provider can solve this problem ? Yes Kenneth
>>> before displaying layer or map server use 100% CPU and before tool tips
>>> displaying server use 10-20% CPU. Any way to overcome this problem ?
>>>
>>> Regards,
>>>
>>> Dhirendra kumar
>>>
>>>
>>> Kenneth, GEOGRAF A/S wrote:
>>>   
>>>       
>>>> I recall that there was a problem with selection/info in some version of 
>>>> the OGR.
>>>> What version of the OGR provider do you use?
>>>>
>>>> Does your server use 100% CPU before displaying?
>>>> Is the problem the same with tooltip's ?
>>>>
>>>> Regards, Kenneth, GEOGRAF A/S
>>>>
>>>>
>>>> Dhirendra Kumar skrev:
>>>>     
>>>>         
>>>>> Hi Kenneth,
>>>>>
>>>>> Once again i am asking qustion to you about Postgres/PostGIS, Kenneth I
>>>>> import table in PostGIS database using shp2pgsql tool. I can create
>>>>> Layers
>>>>> from PostGIs Database. But when i select any polygon then polygon
>>>>> highlight
>>>>> after 4 second, So can i increase performence of polygon selection ?
>>>>> 300
>>>>> polygon on current layer. I also provide index but problem is still
>>>>> same.
>>>>> Any thing wrong in my process ? Please help me.
>>>>>
>>>>> 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
>>>>>>
>>>>>>
>>>>>>     
>>>>>>         
>>>>>>             
>>>>>   
>>>>>       
>>>>>           
>>>> _______________________________________________
>>>> mapguide-users mailing list
>>>> mapguide-users at lists.osgeo.org
>>>> http://lists.osgeo.org/mailman/listinfo/mapguide-users
>>>>
>>>>
>>>>     
>>>>         
>>>   
>>>       
>> _______________________________________________
>> mapguide-users mailing list
>> mapguide-users at lists.osgeo.org
>> http://lists.osgeo.org/mailman/listinfo/mapguide-users
>>
>>
>>     
>
>   
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapguide-users/attachments/20070803/fc08d743/attachment.html


More information about the mapguide-users mailing list