diff options
| -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; |