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

[Zac Spitzer]

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