[fdo-dev] Create nonspatial index in SDF via FDO?

Jason Birch Jason.Birch at nanaimo.ca
Tue Sep 12 15:55:26 EDT 2006

Is this not an appropriate place to ask this question?  Is there
somewhere better?


-----Original Message-----
From: Jason Birch [mailto:Jason.Birch at nanaimo.ca] 
Sent: Monday, September 11, 2006 19:18
To: dev at fdo.osgeo.org
Subject: [fdo-dev] Create nonspatial index in SDF via FDO?

Hi all,
Is it possible to create a non-spatial (attribute) index in the SDF
format using FDO?  I'm seeing really poor performance on queries with
attribute filters applied on a fairly small (14000 row) table and I'd
like to try applying an index to see if it makes a difference.
I know that SQLite supports attribute indexes
but can't find a method in FDO to create them, and the SQLite tools
don't seem to like opening up SDF3 files directly.  Any ideas?

To unsubscribe, e-mail: dev-unsubscribe at fdo.osgeo.org For additional
commands, e-mail: dev-help at fdo.osgeo.org

More information about the Fdo-internals mailing list