Opened 15 years ago

Closed 15 years ago

#619 closed enhancement (invalid)

Attribute indexing in SDF File

Reported by: jnel Owned by:
Priority: medium Milestone:
Component: General Version: 2.0.1
Severity: minor Keywords: SDF indexing
Cc: External ID:

Description

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.

Change History (2)

comment:1 by zspitzer, 15 years ago

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

comment:2 by jbirch, 15 years ago

Resolution: invalid
Status: newclosed

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/

Note: See TracTickets for help on using tickets.