Hi Matthew,
> ----- Original Message -----
> From: "Matthew Baird" <[EMAIL PROTECTED]>
> To: "OJB Users List" <[EMAIL PROTECTED]>
> Sent: Wednesday, August 14, 2002 12:08 PM
> Subject: metrics on batch update
> <snip>
> Anecdotal evidence says we could get a 40% improvement in performance on
updates/inserts
> due to lowered RPC's on the db. If that is true, a medium-major refactoring
would be
> warranted.
I just refactored some classes in OJB v0.9.5 to support batch
inserts/updates/deletes using Oracle's update batching. I then ran
org.apache.ojb.broker.PerformanceTest which inserts/updates/deletes 10,000 rows.
The tests generated these results:
Scenario #1: No batching/No prepared statement caching (as exists in v0.9.5)
insert - 83 sec
update - 82 sec
delete - 63 sec
Scenario #2: No batching/Prepared statement caching (49% improvement over
scenario #1)
insert - 45 sec
update - 40 sec
delete - 31 sec
Scenario #3 Batching/Prepared statement caching (83% improvement over scenario
#1)
insert - 12 sec
update - 13 sec
delete - 13 sec
Looks like a refactoring is certainly warranted against the Oracle platform.
-Richard
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
