Update of /cvsroot/monetdb/sql/src/benchmarks/tpch
In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv27299/src/benchmarks/tpch
Modified Files:
load-sf-1.sql load.sh
Log Message:
count now returns wrd
U load.sh
Index: load.sh
===================================================================
RCS file: /cvsroot/monetdb/sql/src/benchmarks/tpch/load.sh,v
retrieving revision 1.31
retrieving revision 1.32
diff -u -d -r1.31 -r1.32
--- load.sh 11 Jan 2008 10:52:05 -0000 1.31
+++ load.sh 7 Sep 2008 14:27:52 -0000 1.32
@@ -28,8 +28,8 @@
#T=-
T=
-SF='sf-0.01'
-#SF='sf-1'
+#SF='sf-0.01'
+SF='sf-1'
#SF='sf-2'
#SF='sf-5'
U load-sf-1.sql
Index: load-sf-1.sql
===================================================================
RCS file: /cvsroot/monetdb/sql/src/benchmarks/tpch/load-sf-1.sql,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -d -r1.2 -r1.3
--- load-sf-1.sql 28 Jun 2006 20:29:38 -0000 1.2
+++ load-sf-1.sql 7 Sep 2008 14:27:52 -0000 1.3
@@ -1,10 +1,10 @@
START TRANSACTION;
-COPY 5 RECORDS INTO region from 'PWD/region.tbl' USING DELIMITERS '|', '|\n';
-COPY 25 RECORDS INTO nation from 'PWD/nation.tbl' USING DELIMITERS '|', '|\n';
-COPY 10000 RECORDS INTO supplier from 'PWD/supplier.tbl' USING DELIMITERS '|',
'|\n';
-COPY 150000 RECORDS INTO customer from 'PWD/customer.tbl' USING DELIMITERS
'|', '|\n';
-COPY 200000 RECORDS INTO part from 'PWD/part.tbl' USING DELIMITERS '|', '|\n';
-COPY 800000 RECORDS INTO partsupp from 'PWD/partsupp.tbl' USING DELIMITERS
'|', '|\n';
-COPY 1500000 RECORDS INTO orders from 'PWD/orders.tbl' USING DELIMITERS '|',
'|\n';
-COPY 7000000 RECORDS INTO lineitem from 'PWD/lineitem.tbl' USING DELIMITERS
'|', '|\n';
+COPY INTO region from 'PWD/region.tbl' USING DELIMITERS '|', '|\n';
+COPY INTO nation from 'PWD/nation.tbl' USING DELIMITERS '|', '|\n';
+COPY INTO supplier from 'PWD/supplier.tbl' USING DELIMITERS '|', '|\n';
+COPY INTO customer from 'PWD/customer.tbl' USING DELIMITERS '|', '|\n';
+COPY INTO part from 'PWD/part.tbl' USING DELIMITERS '|', '|\n';
+COPY INTO partsupp from 'PWD/partsupp.tbl' USING DELIMITERS '|', '|\n';
+COPY INTO orders from 'PWD/orders.tbl' USING DELIMITERS '|', '|\n';
+COPY INTO lineitem from 'PWD/lineitem.tbl' USING DELIMITERS '|', '|\n';
COMMIT;
-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
