Slow attribute management

From GRASS-Wiki
Revision as of 17:18, 28 November 2012 by Neteler (talk | contribs) (new)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

Q: In SQlite (or PostgreSQL or MySQL or ...) it seems that the vector attribute management is pretty slow. What can I do?

A: Generate an index on the column in question:

SQLite syntax example:

CREATE INDEX idx_table1_key ON table1(key);