From 24e81f4d632ebb4af2d8a68e64352c37052781b5 Mon Sep 17 00:00:00 2001
From: ivan <ivan>
Date: Sun, 25 Jul 2010 07:30:42 +0000
Subject: [PATCH] limit memory use when upgrading attachments

---
 FS/FS/otaker_Mixin.pm | 4 +++-
 1 file changed, 3 insertions(+), 1 deletion(-)

diff --git a/FS/FS/otaker_Mixin.pm b/FS/FS/otaker_Mixin.pm
index 4aa47c38d..0da9aeedb 100644
--- a/FS/FS/otaker_Mixin.pm
+++ b/FS/FS/otaker_Mixin.pm
@@ -40,11 +40,13 @@ sub _upgrade_otaker {
   my $class = shift;
   my $table = $class->table;
 
+  my $limit = ( $table eq 'cust_attachment' ? 10 : 1000 );
+
   while ( 1 ) {
     my @records = qsearch({
                     'table'     => $table,
                     'hashref'   => {},
-                    'extra_sql' => 'WHERE otaker IS NOT NULL LIMIT 1000',
+                    'extra_sql' => "WHERE otaker IS NOT NULL LIMIT $limit",
                   });
     last unless @records;
 
-- 
2.11.0