[mapguide-users] Solve problem MySQL Polygon Selection

[Dhirendra Kumar]

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

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