Slow attribute management

From GRASS-Wiki
Jump to: navigation, 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);