Revision 11346
Added by Paul Sarando about 11 years ago
| geonames-to-gadm.sql | ||
|---|---|---|
| 42 | 42 |
-- UPDATE 248 |
| 43 | 43 |
-- Time: 3562.601 ms |
| 44 | 44 |
|
| 45 |
CREATE INDEX "gadm_country_lookup_name_0_idx" ON gadm_country_lookup (name_0); |
|
| 46 |
|
|
| 45 | 47 |
------------------------------ |
| 46 | 48 |
-- Level 1 (State/Province) -- |
| 47 | 49 |
------------------------------ |
Also available in: Unified diff
Added indexes to speed up geonames-to-gadm.sql.
Without these indexes, these queries could take hours to complete.
With them, the times more closely matched the times Jim noted in the sql
comments.