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

[Johannes Radinger]

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,
Johannes