-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Larry Cable wrote:
> 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. The second session is runtimeinfo connecting to get data. > > 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 ... > With these numbers, is the JCC driver running in the same JVM or a different one? If it is in the same jvm, could you send runtimeinfo numbers with JCC running in another JVM. Could you send us your benchmark? I don't think I am going to be able to work on this right away, but it sounds serious and I am hoping someone out there will have time to take a look and track down the problem if it is Network Server. Volunteers? > Thanks for you interest > > - Larry Cable > > Thank You! > > __________________________________ > Do you Yahoo!? > Yahoo! Mail - Find what you need with new enhanced search. > http://info.mail.yahoo.com/mail_250 > > > ------------------------------------------------------------------------ > > run: > 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) -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.5 (MingW32) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFB8RA6G0h36bFmkocRAvOBAKCEbtU9llVTnbXzRLbfUx7eXGs5TQCggRuK NZirtf7R1QvX/EfKcrgRlns= =Gjsj -----END PGP SIGNATURE-----
