diff options
| author | Matthew Somerville <matthew@rocket.ukcod.org.uk> | 2011-02-11 00:21:05 +0000 |
|---|---|---|
| committer | Matthew Somerville <matthew@rocket.ukcod.org.uk> | 2011-02-11 00:21:05 +0000 |
| commit | 9d2369c11c0fc81ba170b0dfd478b8edd5678429 (patch) | |
| tree | 8ca9a335125ef0abdc6da49d1b3510e1326f9f32 | |
| parent | d1b36a32d496002a639d4ca8fad7a1bfef47a253 (diff) | |
Use live updating batch size, and match whitespace from schema.
| -rw-r--r-- | db/migrate_from_osgb36_to_wgs84.pl | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/db/migrate_from_osgb36_to_wgs84.pl b/db/migrate_from_osgb36_to_wgs84.pl index 62eac8296..abd504fb8 100644 --- a/db/migrate_from_osgb36_to_wgs84.pl +++ b/db/migrate_from_osgb36_to_wgs84.pl @@ -29,7 +29,7 @@ BEGIN { ); } -my $UPDATE_BATCH_SIZE = 1; # FIXME - should be ~ 500 +my $UPDATE_BATCH_SIZE = 500; migrate_problem_table(); migrate_problem_find_nearby_function(); @@ -142,7 +142,7 @@ sub migrate_problem_find_nearby_function { * cos(radians($2 - longitude)))::numeric, 14) ) < $3 order by distance desc - ' language sql +' language sql SQL_END $dbh->commit; |