[Mapserver-users] OGR Join index

[Frank Warmerdam]

Richard Greenwood wrote:
> Totally cool! The indexes reduced execution time from over 2 minutes to 
> about 2 seconds. (Joining 12000 spatial rows to 300 attribute rows). The 
> index only seemed to be required on the attribute table.
> 
> But of course, there's always one more question: I can not get ogrinfo 
> to create an index on just a dbf file. It seems to require the 
> associated shp and shx files also, even tho there is no spatial data 
> there. Ogrinfo recognizes the dbf, but fails to create an index. e.g.
> 
> $ ogrinfo listing.DBF
>   INFO: Open of `listing.DBF'
>   using driver `ESRI Shapefile' successful.
>   1: listing (None)
> 
> $ ogrinfo -ro . -sql "create index on listing using Pidn"
>   INFO: Open of `.'
>   using driver `ESRI Shapefile' successful.
>   ERROR 1: CREATE INDEX ON failed, no such layer as `listing'.
> 
> I don't see what functional purpose the shp and shx files server in a 
> table having no spatial data. Any insight here?
> 
> As always, thank you very much for your explanations.

Richard,

I will dig into this today.  I would say file a bug but the GDAL/OGR bugzilla
is missing in action at this time.

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