You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-commits@db.apache.org by Apache Wiki <wi...@apache.org> on 2006/10/01 14:58:23 UTC
[Db-derby Wiki] Update of "DerbyBug47" by JamesSynge
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||