[GRASS-user] Join sqlite table by coordinate pair (X,Y)

Johannes Radinger johannesradinger at gmail.com
Tue Oct 30 08:34:24 PDT 2012

Dear all,
Dear Micha,

> The first thing that comes to mind is to create an index on both of the
> text-key columns
> CREATE INDEX idx_table1_key ON table1(key);
> CREATE INDEX idx_table2_key ON table2(key);
Yours suggestion of creating an index substantially improved the speed
of the Sqlite process (From 45 min to <1 min).

Thank you very much.

Best regards,

More information about the grass-user mailing list