mass inserts: index valuable?
416044Mar 16 2006 — edited Mar 17 2006We import hundreds of megabytes of data from XMl files via JDBC (ORACLE driver). As wehardly see any CPU usage (about 2-5%), the main time goes to the database access. We already optimized code by using prepared statements (that are CallableStatements because each record need to be inserted via a procedure call instead of a INSERT statement) that are reused for each record (type). I wonder what additional improvement can be done to speed up the procedure calls.