Revision 14417
Added by Aaron Marcuse-Kubitza over 10 years ago
| trunk/inputs/.TNRS/schema.sql | ||
|---|---|---|
| 567 | 567 |
to port derived column changes to vegbiendev: |
| 568 | 568 |
SELECT util.derived_cols_export(''"TNRS".taxon_match'');
|
| 569 | 569 |
# run the returned SQL on vegbiendev |
| 570 |
-- runtime: 30 min ("5564201 rows affected, 1624829 ms execution time")
|
|
| 570 |
-- runtime: 6 h, 2.6 ms/row ("22030570 ms"; "rows=8353235")
|
|
| 571 | 571 |
SELECT util.recreate_view(''"TNRS".taxon_best_match'');
|
| 572 | 572 |
|
| 573 | 573 |
to add a new derived column: |
| trunk/schemas/vegbien.sql | ||
|---|---|---|
| 20228 | 20228 |
to port derived column changes to vegbiendev: |
| 20229 | 20229 |
SELECT util.derived_cols_export(''"TNRS".taxon_match'');
|
| 20230 | 20230 |
# run the returned SQL on vegbiendev |
| 20231 |
-- runtime: 30 min ("5564201 rows affected, 1624829 ms execution time")
|
|
| 20231 |
-- runtime: 6 h, 2.6 ms/row ("22030570 ms"; "rows=8353235")
|
|
| 20232 | 20232 |
SELECT util.recreate_view(''"TNRS".taxon_best_match'');
|
| 20233 | 20233 |
|
| 20234 | 20234 |
to add a new derived column: |
Also available in: Unified diff
inputs/.TNRS/schema.sql: taxon_match: to port derived column changes to vegbiendev: derived_cols_export() code: documented runtime (6 h)