[mapguide-users] Solve problem MySQL Polygon Selection

[Dhirendra Kumar]

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
> 
> 

-- 
View this message in context: http://www.nabble.com/Solve-problem-MySQL-Polygon-Selection-tf4170008s16610.html#a11979192
Sent from the MapGuide Users mailing list archive at Nabble.com.