jcon.no: Oracle blog

SQL Daily just tweeted about the fact that JDBC roundtrips are expensive. This is something many developers either forget or do not know. I have seen so many chatty applications killing the application performance, and the database performance. Toon Koppelaars have performed some excellent presentations showing this. Lukas Eder have also written some nice articles about this. Use the following links to read up on the subject:

• Lukas Eder: “The Performance Difference Between SQL Row-by-row Updating, Batch Updating, and Bulk Updating”
• Toon Koppelaars: “NoPLSql and Thick Database Approaches”