OGR virtual spatial data

[Frank Warmerdam]

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. 

Best regards,
-- 
---------------------------------------+--------------------------------------
I set the clouds in motion - turn up   | Frank Warmerdam, warmerdam at pobox.com
light and sound - activate the windows | http://pobox.com/~warmerdam
and watch the world go round - Rush    | Geospatial Programmer for Rent