On 2/3/06, Marcel Reutegger <[EMAIL PROTECTED]> wrote: > Przemyslaw Pakulski wrote: > > Even if usage of connection pool is not reasonable in current design, I > > think it is worth to consider JDBC batch updates instead of single > > updates to gain better DBPM performance. > > That's a very good point. We should definitively look into this in more > detail.
i have considered using batched updates in SimpleDbPersistenceManager at an early stage but rejected the idea for the generic simple db pm as it caused interoperability problems with some vendor's jdbc drivers. some drivers didn't allowed writing blob values within batched updates, others seemed to have other limitations (e.g. the max # of batched stmts) etc etc. if you want to use batched updates i guess you'll have to target a specific driver/backend, so much for the idea of a vendor-neutral database client api :( cheers stefan > > regards > marcel >
