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
