OGR virtual spatial data

[Kralidis,Tom [Burlington]]

> 
> On 9/7/05, Kralidis,Tom [Burlington] <Tom.Kralidis at ec.gc.ca> wrote:
> > Hi,
> > 
> > I have a MySQL table which I'm connecting to via OGR's 
> virtual spatial 
> > data option and unixODBC.  The table has ~ 2 million records with x 
> > and y columns.  I have setup an .ovf and mapfile accordingly.
> > 
> > When I run shp2img, CPU usage spikes up to 100% and then a 
> core dump 
> > results.  I am running shp2img with an extent which will 
> result in far 
> > less records.
> 
> Tom, 
> 
> As Bart notes, new versions of GDAL should handle the spatial 
> queries much more efficiently for ODBC via VRT (assuming the 
> database can handle the query efficiently).   
> 
> I am concerned about the crash though.  There was a cleanup 
> issue with an older version of the OGR VRT driver that might 
> be causing it.  If the problem persists with GDAL 1.3.0 let 
> me know and we can try to dig into it. 
> 

When upgrading to 1.3.0, there were no crash or cleanup issues (I used
VRT with a MySQL connection).

Thanks

..Tom