[mapguide-users] Speed up for loading shp files into oracle

[Brad Nesom]

Zac,
I'm interested... was the code set to 100 records before the commit? And
that was the slow down?
I have read that with problems in large datasets the 1000 record commit can
help save resources and prevent slow down.
Hmm.
Brad

-----Original Message-----
From: mapguide-users-bounces at lists.osgeo.org
[mailto:mapguide-users-bounces at lists.osgeo.org] On Behalf Of Zac Spitzer
Sent: Thursday, April 19, 2007 3:30 AM
To: mapguide-users at lists.osgeo.org
Subject: [mapguide-users] Speed up for loading shp files into oracle

I've been loading a lot of shp files into oracle for a mapguide
project and i found a good way to speed the whole process up by about
25%

I'm using the Oracle Java Shapefile Converter sample and the trick was
to tweak the code to use "COMMIT WORK WRITE BATCH NOWAIT" which
basically lets oracle decide when to flush your inserts out to disk
(ie commit)... it's not always recommended as you ain't guaranteed
your changes have been written disk, but it's only an import right?

i blogged about it here -
http://zacster.blogspot.com/2007/04/trouble-with-commits.html

basically i got a 25% performance boost which is handy when your
loading a lot of shape file which can takes hours and hours...

-- 
Zac Spitzer
+61 405 847 168
_______________________________________________
mapguide-users mailing list
mapguide-users at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapguide-users