Hi Kathy,
Attached is the output from my benchmark with the runtime info
interspersed in between ...
As you can see there are only 2 prepared statements extant (since I
modified the benchmark to explicitly close others) over the lifetime
of the benchmark ...
I am somewhat puzzled as to why there are 2 sessions, 1 for the
lifetime of the run, and one new one per iteration of the benchmark,
as I am not opening additional connections to the DB per iteration
at the application level.
I am hoping that this is a programming error on my behalf (although I
think that the behaviors should be the same in embedded and networked
case) but I am still seeing this linear growth trend in access time
per iterator ...
Thanks for you interest
- Larry Cable
__________________________________
Do you Yahoo!?
Yahoo! Mail - Find what you need with new enhanced search.
http://info.mail.yahoo.com/mail_250run:
start ...
loading libHiResTimer.so
frequency = 2000000000
correcttion = 164
10000 iterations avg took:5932850.9732ns
--- Derby Network Server Runtime Information ---
---------- Session Information ---------------
Session # :1
Database :pojo_test
User :APP
# Statements:2
Prepared Statement Information:
Stmt ID SQLText
------------- -----------
SYSSH2002 update POJO1 set int0 = ? where id = ?
SYSSH2001 select * from POJO1 where id = ? for update
Session # :2
-------------------------------------------------------------
# Connection Threads : 2
# Active Sessions : 2
# Waiting Sessions : 0
Total Memory : 518520832 Free Memory : 514572360
1000 iterations avg took:7370479.6305ns
--- Derby Network Server Runtime Information ---
---------- Session Information ---------------
Session # :1
Database :pojo_test
User :APP
# Statements:2
Prepared Statement Information:
Stmt ID SQLText
------------- -----------
SYSSH2002 update POJO1 set int0 = ? where id = ?
SYSSH2001 select * from POJO1 where id = ? for update
Session # :3
-------------------------------------------------------------
# Connection Threads : 2
# Active Sessions : 2
# Waiting Sessions : 0
Total Memory : 518520832 Free Memory : 513069760
1000 iterations avg took:6612163.959ns
--- Derby Network Server Runtime Information ---
---------- Session Information ---------------
Session # :1
Database :pojo_test
User :APP
# Statements:2
Prepared Statement Information:
Stmt ID SQLText
------------- -----------
SYSSH2002 update POJO1 set int0 = ? where id = ?
SYSSH2001 select * from POJO1 where id = ? for update
Session # :4
-------------------------------------------------------------
# Connection Threads : 2
# Active Sessions : 2
# Waiting Sessions : 0
Total Memory : 518520832 Free Memory : 511567192
1000 iterations avg took:6225587.8805ns
--- Derby Network Server Runtime Information ---
---------- Session Information ---------------
Session # :1
Database :pojo_test
User :APP
# Statements:2
Prepared Statement Information:
Stmt ID SQLText
------------- -----------
SYSSH2002 update POJO1 set int0 = ? where id = ?
SYSSH2001 select * from POJO1 where id = ? for update
Session # :5
-------------------------------------------------------------
# Connection Threads : 2
# Active Sessions : 2
# Waiting Sessions : 0
Total Memory : 518520832 Free Memory : 512805104
1000 iterations avg took:6419594.087ns
--- Derby Network Server Runtime Information ---
---------- Session Information ---------------
Session # :1
Database :pojo_test
User :APP
# Statements:2
Prepared Statement Information:
Stmt ID SQLText
------------- -----------
SYSSH2002 update POJO1 set int0 = ? where id = ?
SYSSH2001 select * from POJO1 where id = ? for update
Session # :6
-------------------------------------------------------------
# Connection Threads : 2
# Active Sessions : 2
# Waiting Sessions : 0
Total Memory : 518520832 Free Memory : 511303320
1000 iterations avg took:6529248.625ns
--- Derby Network Server Runtime Information ---
---------- Session Information ---------------
Session # :1
Database :pojo_test
User :APP
# Statements:2
Prepared Statement Information:
Stmt ID SQLText
------------- -----------
SYSSH2002 update POJO1 set int0 = ? where id = ?
SYSSH2001 select * from POJO1 where id = ? for update
Session # :7
-------------------------------------------------------------
# Connection Threads : 2
# Active Sessions : 2
# Waiting Sessions : 0
Total Memory : 518520832 Free Memory : 509702608
1000 iterations avg took:6731700.813ns
--- Derby Network Server Runtime Information ---
---------- Session Information ---------------
Session # :1
Database :pojo_test
User :APP
# Statements:2
Prepared Statement Information:
Stmt ID SQLText
------------- -----------
SYSSH2002 update POJO1 set int0 = ? where id = ?
SYSSH2001 select * from POJO1 where id = ? for update
Session # :8
-------------------------------------------------------------
# Connection Threads : 2
# Active Sessions : 2
# Waiting Sessions : 0
Total Memory : 518520832 Free Memory : 508200824
1000 iterations avg took:7022145.969ns
--- Derby Network Server Runtime Information ---
---------- Session Information ---------------
Session # :1
Database :pojo_test
User :APP
# Statements:2
Prepared Statement Information:
Stmt ID SQLText
------------- -----------
SYSSH2002 update POJO1 set int0 = ? where id = ?
SYSSH2001 select * from POJO1 where id = ? for update
Session # :9
-------------------------------------------------------------
# Connection Threads : 2
# Active Sessions : 2
# Waiting Sessions : 0
Total Memory : 518520832 Free Memory : 511864616
1000 iterations avg took:7358174.985ns
--- Derby Network Server Runtime Information ---
---------- Session Information ---------------
Session # :1
Database :pojo_test
User :APP
# Statements:2
Prepared Statement Information:
Stmt ID SQLText
------------- -----------
SYSSH2002 update POJO1 set int0 = ? where id = ?
SYSSH2001 select * from POJO1 where id = ? for update
Session # :10
-------------------------------------------------------------
# Connection Threads : 2
# Active Sessions : 2
# Waiting Sessions : 0
Total Memory : 518520832 Free Memory : 510362824
1000 iterations avg took:7621157.3035ns
--- Derby Network Server Runtime Information ---
---------- Session Information ---------------
Session # :1
Database :pojo_test
User :APP
# Statements:2
Prepared Statement Information:
Stmt ID SQLText
------------- -----------
SYSSH2002 update POJO1 set int0 = ? where id = ?
SYSSH2001 select * from POJO1 where id = ? for update
Session # :11
-------------------------------------------------------------
# Connection Threads : 2
# Active Sessions : 2
# Waiting Sessions : 0
Total Memory : 518520832 Free Memory : 508860248
1000 iterations avg took:7989292.5485ns
--- Derby Network Server Runtime Information ---
---------- Session Information ---------------
Session # :1
Database :pojo_test
User :APP
# Statements:2
Prepared Statement Information:
Stmt ID SQLText
------------- -----------
SYSSH2002 update POJO1 set int0 = ? where id = ?
SYSSH2001 select * from POJO1 where id = ? for update
Session # :12
-------------------------------------------------------------
# Connection Threads : 2
# Active Sessions : 2
# Waiting Sessions : 0
Total Memory : 518520832 Free Memory : 507356888
1000 iterations avg took:8278469.646ns
--- Derby Network Server Runtime Information ---
---------- Session Information ---------------
Session # :1
Database :pojo_test
User :APP
# Statements:2
Prepared Statement Information:
Stmt ID SQLText
------------- -----------
SYSSH2002 update POJO1 set int0 = ? where id = ?
SYSSH2001 select * from POJO1 where id = ? for update
Session # :13
-------------------------------------------------------------
# Connection Threads : 2
# Active Sessions : 2
# Waiting Sessions : 0
Total Memory : 518520832 Free Memory : 510922648
1000 iterations avg took:8467537.9205ns
--- Derby Network Server Runtime Information ---
---------- Session Information ---------------
Session # :1
Database :pojo_test
User :APP
# Statements:2
Prepared Statement Information:
Stmt ID SQLText
------------- -----------
SYSSH2002 update POJO1 set int0 = ? where id = ?
SYSSH2001 select * from POJO1 where id = ? for update
Session # :14
-------------------------------------------------------------
# Connection Threads : 2
# Active Sessions : 2
# Waiting Sessions : 0
Total Memory : 518520832 Free Memory : 509420856
1000 iterations avg took:8798900.1195ns
--- Derby Network Server Runtime Information ---
---------- Session Information ---------------
Session # :1
Database :pojo_test
User :APP
# Statements:2
Prepared Statement Information:
Stmt ID SQLText
------------- -----------
SYSSH2002 update POJO1 set int0 = ? where id = ?
SYSSH2001 select * from POJO1 where id = ? for update
Session # :15
-------------------------------------------------------------
# Connection Threads : 2
# Active Sessions : 2
# Waiting Sessions : 0
Total Memory : 518520832 Free Memory : 507820232
1000 iterations avg took:9027374.3535ns
--- Derby Network Server Runtime Information ---
---------- Session Information ---------------
Session # :1
Database :pojo_test
User :APP
# Statements:2
Prepared Statement Information:
Stmt ID SQLText
------------- -----------
SYSSH2002 update POJO1 set int0 = ? where id = ?
SYSSH2001 select * from POJO1 where id = ? for update
Session # :16
-------------------------------------------------------------
# Connection Threads : 2
# Active Sessions : 2
# Waiting Sessions : 0
Total Memory : 518520832 Free Memory : 506318232
1000 iterations avg took:9308147.2875ns
--- Derby Network Server Runtime Information ---
---------- Session Information ---------------
Session # :1
Database :pojo_test
User :APP
# Statements:2
Prepared Statement Information:
Stmt ID SQLText
------------- -----------
SYSSH2002 update POJO1 set int0 = ? where id = ?
SYSSH2001 select * from POJO1 where id = ? for update
Session # :17
-------------------------------------------------------------
# Connection Threads : 2
# Active Sessions : 2
# Waiting Sessions : 0
Total Memory : 518520832 Free Memory : 509979808
1000 iterations avg took:9631844.99ns
--- Derby Network Server Runtime Information ---
---------- Session Information ---------------
Session # :1
Database :pojo_test
User :APP
# Statements:2
Prepared Statement Information:
Stmt ID SQLText
------------- -----------
SYSSH2002 update POJO1 set int0 = ? where id = ?
SYSSH2001 select * from POJO1 where id = ? for update
Session # :18
-------------------------------------------------------------
# Connection Threads : 2
# Active Sessions : 2
# Waiting Sessions : 0
Total Memory : 518520832 Free Memory : 508478008
1000 iterations avg took:9916671.6ns
--- Derby Network Server Runtime Information ---
---------- Session Information ---------------
Session # :1
Database :pojo_test
User :APP
# Statements:2
Prepared Statement Information:
Stmt ID SQLText
------------- -----------
SYSSH2002 update POJO1 set int0 = ? where id = ?
SYSSH2001 select * from POJO1 where id = ? for update
Session # :19
-------------------------------------------------------------
# Connection Threads : 2
# Active Sessions : 2
# Waiting Sessions : 0
Total Memory : 518520832 Free Memory : 506976448
1000 iterations avg took:1.0201145E7ns
--- Derby Network Server Runtime Information ---
---------- Session Information ---------------
Session # :1
Database :pojo_test
User :APP
# Statements:2
Prepared Statement Information:
Stmt ID SQLText
------------- -----------
SYSSH2002 update POJO1 set int0 = ? where id = ?
SYSSH2001 select * from POJO1 where id = ? for update
Session # :20
-------------------------------------------------------------
# Connection Threads : 2
# Active Sessions : 2
# Waiting Sessions : 0
Total Memory : 518520832 Free Memory : 505474648
1000 iterations avg took:1.0493610706E7ns
--- Derby Network Server Runtime Information ---
---------- Session Information ---------------
Session # :1
Database :pojo_test
User :APP
# Statements:2
Prepared Statement Information:
Stmt ID SQLText
------------- -----------
SYSSH2002 update POJO1 set int0 = ? where id = ?
SYSSH2001 select * from POJO1 where id = ? for update
Session # :21
-------------------------------------------------------------
# Connection Threads : 2
# Active Sessions : 2
# Waiting Sessions : 0
Total Memory : 518520832 Free Memory : 509040096
1000 iterations avg took:1.0802519745E7ns
--- Derby Network Server Runtime Information ---
---------- Session Information ---------------
Session # :1
Database :pojo_test
User :APP
# Statements:2
Prepared Statement Information:
Stmt ID SQLText
------------- -----------
SYSSH2002 update POJO1 set int0 = ? where id = ?
SYSSH2001 select * from POJO1 where id = ? for update
Session # :22
-------------------------------------------------------------
# Connection Threads : 2
# Active Sessions : 2
# Waiting Sessions : 0
Total Memory : 518520832 Free Memory : 507439256
1000 iterations avg took:1.12896949095E7ns
--- Derby Network Server Runtime Information ---
---------- Session Information ---------------
Session # :1
Database :pojo_test
User :APP
# Statements:2
Prepared Statement Information:
Stmt ID SQLText
------------- -----------
SYSSH2002 update POJO1 set int0 = ? where id = ?
SYSSH2001 select * from POJO1 where id = ? for update
Session # :23
-------------------------------------------------------------
# Connection Threads : 2
# Active Sessions : 2
# Waiting Sessions : 0
Total Memory : 518520832 Free Memory : 505937456
1000 iterations avg took:1.13526675565E7ns
--- Derby Network Server Runtime Information ---
---------- Session Information ---------------
Session # :1
Database :pojo_test
User :APP
# Statements:2
Prepared Statement Information:
Stmt ID SQLText
------------- -----------
SYSSH2002 update POJO1 set int0 = ? where id = ?
SYSSH2001 select * from POJO1 where id = ? for update
Session # :24
-------------------------------------------------------------
# Connection Threads : 2
# Active Sessions : 2
# Waiting Sessions : 0
Total Memory : 518520832 Free Memory : 504435488
1000 iterations avg took:1.16674951885E7ns
--- Derby Network Server Runtime Information ---
---------- Session Information ---------------
Session # :1
Database :pojo_test
User :APP
# Statements:2
Prepared Statement Information:
Stmt ID SQLText
------------- -----------
SYSSH2002 update POJO1 set int0 = ? where id = ?
SYSSH2001 select * from POJO1 where id = ? for update
Session # :25
-------------------------------------------------------------
# Connection Threads : 2
# Active Sessions : 2
# Waiting Sessions : 0
Total Memory : 518520832 Free Memory : 508100224
1000 iterations avg took:1.2009963034E7ns
--- Derby Network Server Runtime Information ---
---------- Session Information ---------------
Session # :1
Database :pojo_test
User :APP
# Statements:2
Prepared Statement Information:
Stmt ID SQLText
------------- -----------
SYSSH2002 update POJO1 set int0 = ? where id = ?
SYSSH2001 select * from POJO1 where id = ? for update
Session # :26
-------------------------------------------------------------
# Connection Threads : 2
# Active Sessions : 2
# Waiting Sessions : 0
Total Memory : 518520832 Free Memory : 506598424
1000 iterations avg took:1.2281325912E7ns
--- Derby Network Server Runtime Information ---
---------- Session Information ---------------
Session # :1
Database :pojo_test
User :APP
# Statements:2
Prepared Statement Information:
Stmt ID SQLText
------------- -----------
SYSSH2002 update POJO1 set int0 = ? where id = ?
SYSSH2001 select * from POJO1 where id = ? for update
Session # :27
-------------------------------------------------------------
# Connection Threads : 2
# Active Sessions : 2
# Waiting Sessions : 0
Total Memory : 518520832 Free Memory : 505096624
1000 iterations avg took:1.25444367305E7ns
--- Derby Network Server Runtime Information ---
---------- Session Information ---------------
Session # :1
Database :pojo_test
User :APP
# Statements:2
Prepared Statement Information:
Stmt ID SQLText
------------- -----------
SYSSH2002 update POJO1 set int0 = ? where id = ?
SYSSH2001 select * from POJO1 where id = ? for update
Session # :28
-------------------------------------------------------------
# Connection Threads : 2
# Active Sessions : 2
# Waiting Sessions : 0
Total Memory : 518520832 Free Memory : 503594224
1000 iterations avg took:1.28577796195E7ns
--- Derby Network Server Runtime Information ---
---------- Session Information ---------------
Session # :1
Database :pojo_test
User :APP
# Statements:2
Prepared Statement Information:
Stmt ID SQLText
------------- -----------
SYSSH2002 update POJO1 set int0 = ? where id = ?
SYSSH2001 select * from POJO1 where id = ? for update
Session # :29
-------------------------------------------------------------
# Connection Threads : 2
# Active Sessions : 2
# Waiting Sessions : 0
Total Memory : 518520832 Free Memory : 507160552
1000 iterations avg took:1.3169659604E7ns
--- Derby Network Server Runtime Information ---
---------- Session Information ---------------
Session # :1
Database :pojo_test
User :APP
# Statements:2
Prepared Statement Information:
Stmt ID SQLText
------------- -----------
SYSSH2002 update POJO1 set int0 = ? where id = ?
SYSSH2001 select * from POJO1 where id = ? for update
Session # :30
-------------------------------------------------------------
# Connection Threads : 2
# Active Sessions : 2
# Waiting Sessions : 0
Total Memory : 518520832 Free Memory : 505658752
1000 iterations avg took:1.34958474435E7ns
--- Derby Network Server Runtime Information ---
---------- Session Information ---------------
Session # :1
Database :pojo_test
User :APP
# Statements:2
Prepared Statement Information:
Stmt ID SQLText
------------- -----------
SYSSH2002 update POJO1 set int0 = ? where id = ?
SYSSH2001 select * from POJO1 where id = ? for update
Session # :31
-------------------------------------------------------------
# Connection Threads : 2
# Active Sessions : 2
# Waiting Sessions : 0
Total Memory : 518520832 Free Memory : 504156952
1000 iterations avg took:1.37377881285E7ns
--- Derby Network Server Runtime Information ---
---------- Session Information ---------------
Session # :1
Database :pojo_test
User :APP
# Statements:2
Prepared Statement Information:
Stmt ID SQLText
------------- -----------
SYSSH2002 update POJO1 set int0 = ? where id = ?
SYSSH2001 select * from POJO1 where id = ? for update
Session # :32
-------------------------------------------------------------
# Connection Threads : 2
# Active Sessions : 2
# Waiting Sessions : 0
Total Memory : 518520832 Free Memory : 502655152
1000 iterations avg took:1.40197071785E7ns
--- Derby Network Server Runtime Information ---
---------- Session Information ---------------
Session # :1
Database :pojo_test
User :APP
# Statements:2
Prepared Statement Information:
Stmt ID SQLText
------------- -----------
SYSSH2002 update POJO1 set int0 = ? where id = ?
SYSSH2001 select * from POJO1 where id = ? for update
Session # :33
-------------------------------------------------------------
# Connection Threads : 2
# Active Sessions : 2
# Waiting Sessions : 0
Total Memory : 518520832 Free Memory : 506220600
1000 iterations avg took:1.43544783435E7ns
--- Derby Network Server Runtime Information ---
---------- Session Information ---------------
Session # :1
Database :pojo_test
User :APP
# Statements:2
Prepared Statement Information:
Stmt ID SQLText
------------- -----------
SYSSH2002 update POJO1 set int0 = ? where id = ?
SYSSH2001 select * from POJO1 where id = ? for update
Session # :34
-------------------------------------------------------------
# Connection Threads : 2
# Active Sessions : 2
# Waiting Sessions : 0
Total Memory : 518520832 Free Memory : 504718408
1000 iterations avg took:1.46455405815E7ns
--- Derby Network Server Runtime Information ---
---------- Session Information ---------------
Session # :1
Database :pojo_test
User :APP
# Statements:2
Prepared Statement Information:
Stmt ID SQLText
------------- -----------
SYSSH2002 update POJO1 set int0 = ? where id = ?
SYSSH2001 select * from POJO1 where id = ? for update
Session # :35
-------------------------------------------------------------
# Connection Threads : 2
# Active Sessions : 2
# Waiting Sessions : 0
Total Memory : 518520832 Free Memory : 503216608
1000 iterations avg took:1.4950869536E7ns
--- Derby Network Server Runtime Information ---
---------- Session Information ---------------
Session # :1
Database :pojo_test
User :APP
# Statements:2
Prepared Statement Information:
Stmt ID SQLText
------------- -----------
SYSSH2002 update POJO1 set int0 = ? where id = ?
SYSSH2001 select * from POJO1 where id = ? for update
Session # :36
-------------------------------------------------------------
# Connection Threads : 2
# Active Sessions : 2
# Waiting Sessions : 0
Total Memory : 518520832 Free Memory : 501615984
1000 iterations avg took:1.5218050271E7ns
--- Derby Network Server Runtime Information ---
---------- Session Information ---------------
Session # :1
Database :pojo_test
User :APP
# Statements:2
Prepared Statement Information:
Stmt ID SQLText
------------- -----------
SYSSH2002 update POJO1 set int0 = ? where id = ?
SYSSH2001 select * from POJO1 where id = ? for update
Session # :37
-------------------------------------------------------------
# Connection Threads : 2
# Active Sessions : 2
# Waiting Sessions : 0
Total Memory : 518520832 Free Memory : 505280616
1000 iterations avg took:1.55046604905E7ns
--- Derby Network Server Runtime Information ---
---------- Session Information ---------------
Session # :1
Database :pojo_test
User :APP
# Statements:2
Prepared Statement Information:
Stmt ID SQLText
------------- -----------
SYSSH2002 update POJO1 set int0 = ? where id = ?
SYSSH2001 select * from POJO1 where id = ? for update
Session # :38
-------------------------------------------------------------
# Connection Threads : 2
# Active Sessions : 2
# Waiting Sessions : 0
Total Memory : 518520832 Free Memory : 503778816
1000 iterations avg took:1.57796491795E7ns
--- Derby Network Server Runtime Information ---
---------- Session Information ---------------
Session # :1
Database :pojo_test
User :APP
# Statements:2
Prepared Statement Information:
Stmt ID SQLText
------------- -----------
SYSSH2002 update POJO1 set int0 = ? where id = ?
SYSSH2001 select * from POJO1 where id = ? for update
Session # :39
-------------------------------------------------------------
# Connection Threads : 2
# Active Sessions : 2
# Waiting Sessions : 0
Total Memory : 518520832 Free Memory : 502277256
1000 iterations avg took:1.60563267355E7ns
--- Derby Network Server Runtime Information ---
---------- Session Information ---------------
Session # :1
Database :pojo_test
User :APP
# Statements:2
Prepared Statement Information:
Stmt ID SQLText
------------- -----------
SYSSH2002 update POJO1 set int0 = ? where id = ?
SYSSH2001 select * from POJO1 where id = ? for update
Session # :40
-------------------------------------------------------------
# Connection Threads : 2
# Active Sessions : 2
# Waiting Sessions : 0
Total Memory : 518520832 Free Memory : 500775456
1000 iterations avg took:1.63641140165E7ns
--- Derby Network Server Runtime Information ---
---------- Session Information ---------------
Session # :1
Database :pojo_test
User :APP
# Statements:2
Prepared Statement Information:
Stmt ID SQLText
------------- -----------
SYSSH2002 update POJO1 set int0 = ? where id = ?
SYSSH2001 select * from POJO1 where id = ? for update
Session # :41
-------------------------------------------------------------
# Connection Threads : 2
# Active Sessions : 2
# Waiting Sessions : 0
Total Memory : 518520832 Free Memory : 504399864
1000 iterations avg took:1.6681850734E7ns
--- Derby Network Server Runtime Information ---
---------- Session Information ---------------
Session # :1
Database :pojo_test
User :APP
# Statements:2
Prepared Statement Information:
Stmt ID SQLText
------------- -----------
SYSSH2002 update POJO1 set int0 = ? where id = ?
SYSSH2001 select * from POJO1 where id = ? for update
Session # :42
-------------------------------------------------------------
# Connection Threads : 2
# Active Sessions : 2
# Waiting Sessions : 0
Total Memory : 518520832 Free Memory : 502898064
1000 iterations avg took:1.69486866175E7ns
--- Derby Network Server Runtime Information ---
---------- Session Information ---------------
Session # :1
Database :pojo_test
User :APP
# Statements:2
Prepared Statement Information:
Stmt ID SQLText
------------- -----------
SYSSH2002 update POJO1 set int0 = ? where id = ?
SYSSH2001 select * from POJO1 where id = ? for update
Session # :43
-------------------------------------------------------------
# Connection Threads : 2
# Active Sessions : 2
# Waiting Sessions : 0
Total Memory : 518520832 Free Memory : 501396264
1000 iterations avg took:1.72721586525E7ns
--- Derby Network Server Runtime Information ---
---------- Session Information ---------------
Session # :1
Database :pojo_test
User :APP
# Statements:2
Prepared Statement Information:
Stmt ID SQLText
------------- -----------
SYSSH2002 update POJO1 set int0 = ? where id = ?
SYSSH2001 select * from POJO1 where id = ? for update
Session # :44
-------------------------------------------------------------
# Connection Threads : 2
# Active Sessions : 2
# Waiting Sessions : 0
Total Memory : 518520832 Free Memory : 499795640
1000 iterations avg took:1.75517202505E7ns
--- Derby Network Server Runtime Information ---
---------- Session Information ---------------
Session # :1
Database :pojo_test
User :APP
# Statements:2
Prepared Statement Information:
Stmt ID SQLText
------------- -----------
SYSSH2002 update POJO1 set int0 = ? where id = ?
SYSSH2001 select * from POJO1 where id = ? for update
Session # :45
-------------------------------------------------------------
# Connection Threads : 2
# Active Sessions : 2
# Waiting Sessions : 0
Total Memory : 518520832 Free Memory : 503466240
1000 iterations avg took:1.78506489605E7ns
--- Derby Network Server Runtime Information ---
---------- Session Information ---------------
Session # :1
Database :pojo_test
User :APP
# Statements:2
Prepared Statement Information:
Stmt ID SQLText
------------- -----------
SYSSH2002 update POJO1 set int0 = ? where id = ?
SYSSH2001 select * from POJO1 where id = ? for update
Session # :46
-------------------------------------------------------------
# Connection Threads : 2
# Active Sessions : 2
# Waiting Sessions : 0
Total Memory : 518520832 Free Memory : 501964440
1000 iterations avg took:1.812948757E7ns
--- Derby Network Server Runtime Information ---
---------- Session Information ---------------
Session # :1
Database :pojo_test
User :APP
# Statements:2
Prepared Statement Information:
Stmt ID SQLText
------------- -----------
SYSSH2002 update POJO1 set int0 = ? where id = ?
SYSSH2001 select * from POJO1 where id = ? for update
Session # :47
-------------------------------------------------------------
# Connection Threads : 2
# Active Sessions : 2
# Waiting Sessions : 0
Total Memory : 518520832 Free Memory : 500462216
1000 iterations avg took:1.84292291905E7ns
--- Derby Network Server Runtime Information ---
---------- Session Information ---------------
Session # :1
Database :pojo_test
User :APP
# Statements:2
Prepared Statement Information:
Stmt ID SQLText
------------- -----------
SYSSH2002 update POJO1 set int0 = ? where id = ?
SYSSH2001 select * from POJO1 where id = ? for update
Session # :48
-------------------------------------------------------------
# Connection Threads : 2
# Active Sessions : 2
# Waiting Sessions : 0
Total Memory : 518520832 Free Memory : 498960416
1000 iterations avg took:1.8719467228E7ns
--- Derby Network Server Runtime Information ---
---------- Session Information ---------------
Session # :1
Database :pojo_test
User :APP
# Statements:2
Prepared Statement Information:
Stmt ID SQLText
------------- -----------
SYSSH2002 update POJO1 set int0 = ? where id = ?
SYSSH2001 select * from POJO1 where id = ? for update
Session # :49
-------------------------------------------------------------
# Connection Threads : 2
# Active Sessions : 2
# Waiting Sessions : 0
Total Memory : 518520832 Free Memory : 502526816
1000 iterations avg took:1.90206315945E7ns
--- Derby Network Server Runtime Information ---
---------- Session Information ---------------
Session # :1
Database :pojo_test
User :APP
# Statements:2
Prepared Statement Information:
Stmt ID SQLText
------------- -----------
SYSSH2002 update POJO1 set int0 = ? where id = ?
SYSSH2001 select * from POJO1 where id = ? for update
Session # :50
-------------------------------------------------------------
# Connection Threads : 2
# Active Sessions : 2
# Waiting Sessions : 0
Total Memory : 518520832 Free Memory : 501025016
1000 iterations avg took:1.93443964475E7ns
--- Derby Network Server Runtime Information ---
---------- Session Information ---------------
Session # :1
Database :pojo_test
User :APP
# Statements:2
Prepared Statement Information:
Stmt ID SQLText
------------- -----------
SYSSH2002 update POJO1 set int0 = ? where id = ?
SYSSH2001 select * from POJO1 where id = ? for update
Session # :51
-------------------------------------------------------------
# Connection Threads : 2
# Active Sessions : 2
# Waiting Sessions : 0
Total Memory : 518520832 Free Memory : 499424392
1000 iterations avg took:1.9604384262E7ns
--- Derby Network Server Runtime Information ---
---------- Session Information ---------------
Session # :1
Database :pojo_test
User :APP
# Statements:2
Prepared Statement Information:
Stmt ID SQLText
------------- -----------
SYSSH2002 update POJO1 set int0 = ? where id = ?
SYSSH2001 select * from POJO1 where id = ? for update
Session # :52
-------------------------------------------------------------
# Connection Threads : 2
# Active Sessions : 2
# Waiting Sessions : 0
Total Memory : 518520832 Free Memory : 497922592
done!
run: 0 avg = 7370479.6305
run: 1 avg = 6612163.959
run: 2 avg = 6225587.8805
run: 3 avg = 6419594.087
run: 4 avg = 6529248.625
run: 5 avg = 6731700.813
run: 6 avg = 7022145.969
run: 7 avg = 7358174.985
run: 8 avg = 7621157.3035
run: 9 avg = 7989292.5485
run: 10 avg = 8278469.646
run: 11 avg = 8467537.9205
run: 12 avg = 8798900.1195
run: 13 avg = 9027374.3535
run: 14 avg = 9308147.2875
run: 15 avg = 9631844.99
run: 16 avg = 9916671.6
run: 17 avg = 1.0201145E7
run: 18 avg = 1.0493610706E7
run: 19 avg = 1.0802519745E7
run: 20 avg = 1.12896949095E7
run: 21 avg = 1.13526675565E7
run: 22 avg = 1.16674951885E7
run: 23 avg = 1.2009963034E7
run: 24 avg = 1.2281325912E7
run: 25 avg = 1.25444367305E7
run: 26 avg = 1.28577796195E7
run: 27 avg = 1.3169659604E7
run: 28 avg = 1.34958474435E7
run: 29 avg = 1.37377881285E7
run: 30 avg = 1.40197071785E7
run: 31 avg = 1.43544783435E7
run: 32 avg = 1.46455405815E7
run: 33 avg = 1.4950869536E7
run: 34 avg = 1.5218050271E7
run: 35 avg = 1.55046604905E7
run: 36 avg = 1.57796491795E7
run: 37 avg = 1.60563267355E7
run: 38 avg = 1.63641140165E7
run: 39 avg = 1.6681850734E7
run: 40 avg = 1.69486866175E7
run: 41 avg = 1.72721586525E7
run: 42 avg = 1.75517202505E7
run: 43 avg = 1.78506489605E7
run: 44 avg = 1.812948757E7
run: 45 avg = 1.84292291905E7
run: 46 avg = 1.8719467228E7
run: 47 avg = 1.90206315945E7
run: 48 avg = 1.93443964475E7
run: 49 avg = 1.9604384262E7
avg = 1.251316966271E7
BUILD SUCCESSFUL (total time: 11 minutes 53 seconds)
