db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Apache Wiki <wikidi...@apache.org>
Subject [Db-derby Wiki] Update of "DerbyBug47" by JamesSynge
Date Sun, 01 Oct 2006 12:58:23 GMT
Dear Wiki user,

You have subscribed to a wiki page or wiki category on "Db-derby Wiki" for change notification.

The following page has been changed by JamesSynge:
http://wiki.apache.org/db-derby/DerbyBug47

------------------------------------------------------------------------------
  Here are the results for different numbers of parameters (the ID Count column below), on
a table of 100,000 rows.
  
  || ||||Literals||||Literal||||Markers||||Marker||||Join Temp||||Join Scratch||||Join Savepoint||||Nested
Temp||||Nested Scratch||||Nested Savepoint||
- ||ID Count||Total ms||Avg ms||Total ms||Avg ms||Total ms||Avg ms||Total ms||Avg ms||Total
ms||Avg ms||Total ms||Avg ms||Total ms||Avg ms||Total ms||Avg ms||Total ms||Avg ms||Total
ms||Avg ms||
+ ||ID Count||Total ms||ms / ID||Total ms||ms / ID||Total ms||ms / ID||Total ms||ms / ID||Total
ms||ms / ID||Total ms||ms / ID||Total ms||ms / ID||Total ms||ms / ID||Total ms||ms / ID||Total
ms||ms / ID||
  ||1||30||30||40||40||10||10||0||0||120||120||10||10||10||10||1126||1126||881||881||860||860||
  ||2||690||345||50||25||1370||685||0||0||40||20||0||0||10||5||761||380||711||355||871||435||
  ||3||660||220||90||30||1962||654||0||0||50||16||10||3||0||0||761||253||771||257||730||243||

Mime
View raw message