DBF to Shape OGR JOIN, PHP crashes

[Frank Warmerdam]

On 9/15/05, Christopher R. Thorne <christhorne at sympatico.ca> wrote:
> 
> What do you mean an "OGR style index"? This maybe my problem. ;)

Chris, 

The OGR Shapefile driver supports using indexes to accelerate
simple attribute lookups (for unique ids).  To create the corresponding
index do something like:

 ogrinfo abc.shp -sql "create index on abc using abc_id"

This is mentioned briefly near the bottom of the OGR SQL page at:

  http://www.gdal.org/ogr/ogr_sql.html

Note that the indexes need to be dropped and rebuilt if you change
the file.  They aren't maintained on the fly.

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