MyGIS Layer & shp2mysql

[Robert Hollingsworth]

no specific comments on your exact situation, but just to say I was warned
away from CONNECTIONTYPE mygis because its robustness is suspect.  I had
very stable results accessing MySQL thru the OGR support.   I was using the
GEOMETRY type in MySQL plus spatial indexes; when using MBRCONTAINS and
similar functions in query, performance seems quite competitive with
shapefile with shptree indexes.

Robert H.

>Hi you all,
>
>I recently re-compiled mapserver (on debian lenny) with MyGis support and
>used shp2mysql to store shapes in a MySQL db.
>
>Adding a MyGis layer, a simple europe rivers shape, everything works fine
>but the visualization under pmapper. 
>In fact rivers are renderend extremely "pruned" on the map... really just
>few segments are drawn.
>
>The rivers shape is displayed correctly using the "default" shp+dbf connection.
>
>Any experience/suggestion on this?
>
>Thanks
>Raffaele