Merge branch 'latest' of github.com:webnotes/erpnext into latest
diff --git a/erpnext/patches/jan_mar_2012/remove_archive.py b/erpnext/patches/jan_mar_2012/remove_archive.py
index cce4d8e..9f685b6 100644
--- a/erpnext/patches/jan_mar_2012/remove_archive.py
+++ b/erpnext/patches/jan_mar_2012/remove_archive.py
@@ -8,12 +8,17 @@
from webnotes.utils import archive
arc_tables = webnotes.conn.sql('show tables like "arc%"')
try:
+ count = 0
for tab in arc_tables:
tab = tab[0]
dt = tab[3:]
res = webnotes.conn.sql("SELECT name FROM `%s`" % tab)
for dn in res:
archive.archive_doc(dt, dn[0], restore=1)
+ count++
+ if not count%100:
+ webnotes.conn.commit()
+ webnotes.conn.begin()
except Exception, e:
raise e
else: