Changeset 424

Timestamp:

Mar 2, 2010, 5:26:05 PM (15 years ago)

Author:

gav

Message:

Add cleanUpGorm() to AssetCsvService.

File:

• trunk/grails-app/services/AssetCsvService.groovy (modified) (4 diffs)

trunk/grails-app/services/AssetCsvService.groovy

@@ +1 @@
+import grails.util.GrailsUtil
 import au.com.bytecode.opencsv.CSVWriter
 import au.com.bytecode.opencsv.CSVReader
@@ -12 +13 @@
 
     def g = new org.codehaus.groovy.grails.plugins.web.taglib.ApplicationTagLib()
+
+    def sessionFactory
+    def propertyInstanceMap = org.codehaus.groovy.grails.plugins.DomainClassGrailsPlugin.PROPERTY_INSTANCE_MAP
 
     /**
@@ -259 +263 @@
 
                 } // while( nextColumn() )
+
+                if(lineNumber % 100 == 0)
+                    cleanUpGorm()
 
                 nextLine()
@@ -448 +455 @@
     }
 
+    /**
+    * This cleans up the hibernate session and a grails map.
+    * For more info see: http://naleid.com/blog/2009/10/01/batch-import-performance-with-grails-and-mysql/
+    * The hibernate session flush is normal for hibernate.
+    * The map is apparently used by grails for domain object validation errors.
+    * A starting point for clean up is every 100 objects.
+    */
+    def cleanUpGorm() {
+        def session = sessionFactory.currentSession
+        session.flush()
+        session.clear()
+        propertyInstanceMap.get().clear()
+    }
+
 } // end class