db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Kathey Marsden <kmars...@Sourcery.Org>
Subject Re: RESEND: possible resource leak in either Derby DRDA or IBM DB2 Universal JDBRe:
Date Fri, 21 Jan 2005 14:22:50 GMT
-----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-----

Mime
View raw message