[mapguide-users] Solve problem MySQL Polygon Selection

[Kenneth, GEOGRAF A/S]

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
>>
>>
>>     
>
>   
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapguide-users/attachments/20070802/f155cf91/attachment.html