Update of /cvsroot/monetdb/pathfinder/modules/pftijah/Tests
In directory
sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv23220/modules/pftijah/Tests
Modified Files:
procs.stable.out
Log Message:
finally, I managed to fullfil JanR's "small wish":
replaced
PROC multi_merged_union (BAT[void, BAT] b) : BAT[void,BAT]
by
.COMMAND multi_merged_union (BAT[void, BAT] b)
: BAT[void,BAT] = CMDmulti_merged_union;
"PARAMETERS:
BAT[void,BAT t[void,BAT c[VoID,any]]]:
a void-headed BAT of n void-headed BATs t such that each BAT t represents a
relational table t of m columns c, each represented by a dense-headed BAT c;
the first column of each table must be sorted.
DESCRIPTION:
Merges the n relational tables t according to the value-order as defined by the
first columns of all tables."
At a slight performance decrease with only 2 or 3 tables,
it yields a performance gain of 25% - 63% with 4-9 tables
(each table has 9 columns and 1000000 tuples):
# Old New New-Old (N-O)/O
2 289745 339914 50169 17%
3 719059 904862 185803 25%
4 1302676 955985 -346691 -26%
5 2023403 1082348 -941055 -46%
6 2922657 1359887 -1562770 -53%
7 3757045 1597463 -2159582 -57%
8 5151854 1878731 -3273123 -63%
9 6028759 2177258 -3851501 -63%
Index: procs.stable.out
===================================================================
RCS file: /cvsroot/monetdb/pathfinder/modules/pftijah/Tests/procs.stable.out,v
retrieving revision 1.22
retrieving revision 1.23
diff -u -d -r1.22 -r1.23
--- procs.stable.out 27 Jun 2007 13:46:49 -0000 1.22
+++ procs.stable.out 20 Jul 2007 21:12:45 -0000 1.23
@@ -449,7 +449,6 @@
[ "mposjoin(any, oid, BAT[oid,BAT]) : BAT[void,any]"
]
[ "msecs(int, int, int, int, int) : lng"
]
[ "msync(BAT[void,any::1], oid, bit) : BAT[void,any::1]"
]
-[ "multi_merged_union(BAT[void,BAT]) : BAT[void,BAT]"
]
[ "mvaljoin(any, oid, BAT[oid,BAT]) : BAT[oid,oid]"
]
[ "mylog_delta(logger, BAT[any,any], str) : void"
]
[ "myupdate(BAT[any::1,any::2], BAT[any::1,any::2]) : BAT[any::1,any::2]"
]
-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2005.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Monetdb-pf-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-pf-checkins
