Issue Details (XML | Word | Printable)

Key: NUCRDBMS-394
Type: Task Task
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Andy Jefferson
Reporter: Andy Jefferson
Votes: 1
Watchers: 1
Operations

If you were logged in you would be able to see more operations.
DataNucleus Store RDBMS

Statement batching on INSERTs

Created: 12/May/07 10:22 AM   Updated: 27/Jun/10 08:57 AM   Resolved: 16/Jun/10 09:19 AM
Component/s: None
Affects Version/s: None
Fix Version/s: 2.1.1


 Description  « Hide
The SQLController allows the potential of SQL statement batching. It is currently (1.2.0-beta-3) enabled for DELETE statements, but could also reasonably be used for INSERT statements (org.jpox.store.rdbms.request.InsertRequest). To enable this we would need to check that no other SQL is going to be invoked from allocating the PreparedStatement for the INSERT until executeUpdate is called on it. This means that no value strategy in the datastore is invoked and no other relations are processed for the object to be inserted.

Andy Jefferson made changes - 11/Jul/07 08:19 PM
Field Original Value New Value
Fix Version/s 1.2.0 [ 10021 ]
Andy Jefferson made changes - 22/Nov/07 07:52 PM
Project Core [ 10000 ] RDBMS [ 10111 ]
Key CORE-3261 RDBMS-28
Component/s Datastore Support : RDBMS [ 10001 ]
Affects Version/s 1.2.0-beta-2 [ 10201 ]
Andy Jefferson made changes - 17/May/10 02:37 PM
Project JPOX RDBMS (ARCHIVED) [ 10111 ] DataNucleus RDBMS [ 10144 ]
Key RDBMS-28 NUCRDBMS-394
Andy Jefferson added a comment - 16/Jun/10 09:19 AM
SVN trunk now enables this, and all tests pass with it after the fix to NUCRDBMS-417

Andy Jefferson made changes - 16/Jun/10 09:19 AM
Status Open [ 1 ] Resolved [ 5 ]
Assignee Andy Jefferson [ andy ]
Fix Version/s 2.1.1 [ 10991 ]
Resolution Fixed [ 1 ]
Andy Jefferson made changes - 27/Jun/10 08:57 AM
Status Resolved [ 5 ] Closed [ 6 ]