Slow attribute management: Difference between revisions

From GRASS-Wiki
Jump to navigation Jump to search
(new)
 
(No difference)

Latest revision as of 17:18, 28 November 2012

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);