> Many thanks for the Answer and I using at the moment prepared > statements > in java and my autocommit is off. So I need help with the Parameter > Settings like Cache Size and so on.
Add addBatch and executeBatch to the mix. This reduces communication overhead. Don't make the batches too large or much time will be spent in java memory management. Daniel Dittmar -- Daniel Dittmar SAP DB, SAP Labs Berlin [EMAIL PROTECTED] http://www.sapdb.org/ _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
