Upgrade
Sign In : Sign Up : Blog : Search: Language : Help :
This website is now frozen, please migrate your content to BotLibre.com or BotLibre.biz
Browse : Java : Java Persistence Performance

Browse

1 results.
Batch Writing, and Dynamic vs Parametrized SQL, how well does your database perform?
by jamesssss posted Nov 21 2014, 6:56
One of the most effective database optimizations is batch writing. Batch writing is supported by most modern databases and part of the JDBC standard and is supported by most JPA providers.

Normal database access consists of sending each DML (insert, update, delete) statement to the database in a separate database/network access. Each database access has a certain amount of overhead to it, and the database must process each statement independently. Batch writing has two forms, dynamic an

Tags: eclipselink, jpa, batch, parametrized sql, database, postgresql, oracle, db2, mysql, derby, sql server, h2, hsql
Replies: 0, Views: 1892, today: 1, week: 3, month: 10
Thumbs up: 0, thumbs down: 0, stars: 0.0
Batch Writing, and Dynamic vs Parametrized SQL, how well does your database perform?
by jamesssss posted Nov 21 2014, 6:56
Replies: 0 | Views: 1892