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: