Revision 10802
Added by Aaron Marcuse-Kubitza over 11 years ago
| schemas/vegbien.sql | ||
|---|---|---|
| 740 | 740 |
schema_null: identifies which schema''s tables to use. the default value is usually fine. |
| 741 | 741 |
|
| 742 | 742 |
runtime: |
| 743 |
ACAD: 30 s: 27738 ms/45503 rows = 0.61 ms/row |
|
| 744 |
GBIF: ~10 h: 55,417,646 rows * 0.61 ms/row * 1 s/1000 ms * 1 h/3600 s = 9.39 h |
|
| 743 |
ACAD: 30 s : 27738 ms/ 45,503 rows = 0.61 ms/row |
|
| 744 |
MO : 55 min: 3311962 ms/3,894,706 rows = 0.85 ms/row |
|
| 745 |
GBIF: ~13 h : 55,417,646 rows * 0.85 ms/row * 1 s/1000 ms * 1 h/3600 s = 13.1 h |
|
| 745 | 746 |
|
| 746 | 747 |
to calculate runtime: |
| 747 | 748 |
BEGIN; |
Also available in: Unified diff
schemas/vegbien.sql: datasource_rm(): runtime: added runtime of MO (55 min, 0.85 ms/row), which has a much larger # of rows than ACAD (4 million instead of 45,000). updated GBIF runtime estimate (~13 h) with more accurate ms/row from MO.