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

[Badreddine Karoui]

Hi Jason,

FDO does not allow the creation of an index. 
Also, the data created by the SDF provider cannot be accessed by any
SQLite tools; The SDF provider does not use the SQLite metadata.

It sounds like 14000 rows is not a large data set that would present a
performance issue for the SDF provider. What kind of performance numbers
you are getting and how it compares with the case where no filter is
used?
And how complex is the attribute filter?

Badreddine

-----Original Message-----
From: Jason Birch [mailto:Jason.Birch at nanaimo.ca] 
Sent: Tuesday, September 12, 2006 3:55 PM
To: dev at fdo.osgeo.org
Subject: RE: [fdo-dev] Create nonspatial index in SDF via FDO?

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

Thanks,
Jason 

-----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
http://www.sqlite.org/lang_createindex.html
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?
 
Thanks,
Jason

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


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