Attribute indexing in SDF File

[jnel]

Building a mapping site with many layers (200+) and multiple thematics slow down the system significantly. Exporting to data to SDF improve the performance, but when a number of thematics are done on a large dataset, it slows down dramatically. Being able to add attribute indexes, in addition to the key would improve performance.

[zspitzer]

are you mostly filtering single tables into many layers or are you using one layer with a complex theme?

[jbirch]

This request belongs in the FDO trac.

You may want to consider trying the SQLite provider. I believe that it may take advantage of native SQLite attribute indexing.

You can either build it yourself, or grab an unofficial build from my website

​http://www.jasonbirch.com/nodes/2008/05/06/184/sqlite-for-fdo-with-sugar-free-ogr/