Update of /cvsroot/monetdb/sql/src/benchmarks/scantest
In directory
sc8-pr-cvs7.sourceforge.net:/tmp/cvs-serv12030/src/benchmarks/scantest
Modified Files:
dumpt1.sql dumpt10.sql dumpt100.sql dumpt200.sql dumpt25.sql
dumpt5.sql dumpt50.sql ft1.sql ft10.sql ft100.sql ft200.sql
ft25.sql ft5.sql ft50.sql info.sql readme.txt
Log Message:
propagated changes of Friday Mar 02 2007 - Wednesday Mar 07 2007
from the SQL_2-16 branch to the development trunk
Index: ft1.sql
===================================================================
RCS file: /cvsroot/monetdb/sql/src/benchmarks/scantest/ft1.sql,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -d -r1.2 -r1.3
--- ft1.sql 1 Jan 2003 07:58:10 -0000 1.2
+++ ft1.sql 7 Mar 2007 15:02:41 -0000 1.3
@@ -1,21 +1,21 @@
--- uses table t1 (see ct1.sql)
---
--- USAGE
--- SQL> @ft1
--- SQL> exec ft1(10)
---
-
-CREATE OR REPLACE
-PROCEDURE ft1 (rows INTEGER) IS
- x NUMBER := 0.01;
-BEGIN
- FOR i IN 1..rows LOOP
- INSERT INTO t1 VALUES (i, x);
- x := x + 0.01;
- END LOOP;
-END ft1;
-.
-
--- now execute program
-/
-exec ft1(100000)
+-- uses table t1 (see ct1.sql)
+--
+-- USAGE
+-- SQL> @ft1
+-- SQL> exec ft1(10)
+--
+
+CREATE OR REPLACE
+PROCEDURE ft1 (rows INTEGER) IS
+ x NUMBER := 0.01;
+BEGIN
+ FOR i IN 1..rows LOOP
+ INSERT INTO t1 VALUES (i, x);
+ x := x + 0.01;
+ END LOOP;
+END ft1;
+.
+
+-- now execute program
+/
+exec ft1(100000)
Index: ft10.sql
===================================================================
RCS file: /cvsroot/monetdb/sql/src/benchmarks/scantest/ft10.sql,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -d -r1.2 -r1.3
--- ft10.sql 1 Jan 2003 07:58:10 -0000 1.2
+++ ft10.sql 7 Mar 2007 15:02:41 -0000 1.3
@@ -1,21 +1,21 @@
--- uses table t10 (see ct10.sql)
---
--- USAGE
--- SQL> @ft10
--- SQL> exec ft10(10)
---
-
-CREATE OR REPLACE
-PROCEDURE ft10 (rows INTEGER) IS
- x NUMBER := 0.01;
-BEGIN
- FOR i IN 1..rows LOOP
- INSERT INTO t10 (Id,v1) VALUES (i, x);
- x := x + 0.01;
- END LOOP;
-END ft10;
-.
-
--- now execute program
-/
-exec ft10(100000)
+-- uses table t10 (see ct10.sql)
+--
+-- USAGE
+-- SQL> @ft10
+-- SQL> exec ft10(10)
+--
+
+CREATE OR REPLACE
+PROCEDURE ft10 (rows INTEGER) IS
+ x NUMBER := 0.01;
+BEGIN
+ FOR i IN 1..rows LOOP
+ INSERT INTO t10 (Id,v1) VALUES (i, x);
+ x := x + 0.01;
+ END LOOP;
+END ft10;
+.
+
+-- now execute program
+/
+exec ft10(100000)
Index: dumpt10.sql
===================================================================
RCS file: /cvsroot/monetdb/sql/src/benchmarks/scantest/dumpt10.sql,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -d -r1.1 -r1.2
--- dumpt10.sql 29 Dec 2002 18:57:08 -0000 1.1
+++ dumpt10.sql 7 Mar 2007 15:02:40 -0000 1.2
@@ -1,34 +1,34 @@
--- dumps table t10 to file t10.txt
--- assumes there are 100000 rows in the table
-
--- put all lines on one page
-set pagesize 0
-
--- display numbers with a maximum width of 7
-set numwidth 7
-
--- linesize should be "nr of columns" x (numwidth + 1)
-set linesize 88
-
--- to specify the character between columns, default is ' '
--- set colsep ','
-
--- to eliminate the "... rows selected" message
-set feedback off
-
--- do not echo results on terminal
-set termout off
-
--- send output to t10.txt
-spool t10.txt
-
-select *
-from t10;
-
-
--- stop capturing output
-spool off
-
--- turn options back on
-set termout on
-set feedback on
+-- dumps table t10 to file t10.txt
+-- assumes there are 100000 rows in the table
+
+-- put all lines on one page
+set pagesize 0
+
+-- display numbers with a maximum width of 7
+set numwidth 7
+
+-- linesize should be "nr of columns" x (numwidth + 1)
+set linesize 88
+
+-- to specify the character between columns, default is ' '
+-- set colsep ','
+
+-- to eliminate the "... rows selected" message
+set feedback off
+
+-- do not echo results on terminal
+set termout off
+
+-- send output to t10.txt
+spool t10.txt
+
+select *
+from t10;
+
+
+-- stop capturing output
+spool off
+
+-- turn options back on
+set termout on
+set feedback on
Index: ft50.sql
===================================================================
RCS file: /cvsroot/monetdb/sql/src/benchmarks/scantest/ft50.sql,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -d -r1.2 -r1.3
--- ft50.sql 1 Jan 2003 07:58:10 -0000 1.2
+++ ft50.sql 7 Mar 2007 15:02:41 -0000 1.3
@@ -1,21 +1,21 @@
--- uses table t50 (see ct50.sql)
---
--- USAGE
--- SQL> @ft50
--- SQL> exec ft50(10)
---
-
-CREATE OR REPLACE
-PROCEDURE ft50 (rows INTEGER) IS
- x NUMBER := 0.01;
-BEGIN
- FOR i IN 1..rows LOOP
- INSERT INTO t50 (Id,v1) VALUES (i, x);
- x := x + 0.01;
- END LOOP;
-END ft50;
-.
-
--- now execute program
-/
-exec ft50(100000)
+-- uses table t50 (see ct50.sql)
+--
+-- USAGE
+-- SQL> @ft50
+-- SQL> exec ft50(10)
+--
+
+CREATE OR REPLACE
+PROCEDURE ft50 (rows INTEGER) IS
+ x NUMBER := 0.01;
+BEGIN
+ FOR i IN 1..rows LOOP
+ INSERT INTO t50 (Id,v1) VALUES (i, x);
+ x := x + 0.01;
+ END LOOP;
+END ft50;
+.
+
+-- now execute program
+/
+exec ft50(100000)
Index: dumpt50.sql
===================================================================
RCS file: /cvsroot/monetdb/sql/src/benchmarks/scantest/dumpt50.sql,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -d -r1.1 -r1.2
--- dumpt50.sql 29 Dec 2002 18:57:08 -0000 1.1
+++ dumpt50.sql 7 Mar 2007 15:02:41 -0000 1.2
@@ -1,34 +1,34 @@
--- dumps table t50 to file t50.txt
--- assumes there are 100000 rows in the table
-
--- put all lines on one page
-set pagesize 0
-
--- display numbers with a maximum width of 7
-set numwidth 7
-
--- linesize should be "nr of columns" x (numwidth + 1)
-set linesize 408
-
--- to specify the character between columns, default is ' '
--- set colsep ','
-
--- to eliminate the "... rows selected" message
-set feedback off
-
--- do not echo results on terminal
-set termout off
-
--- send output to t50.txt
-spool t50.txt
-
-select *
-from t50;
-
-
--- stop capturing output
-spool off
-
--- turn options back on
-set termout on
-set feedback on
+-- dumps table t50 to file t50.txt
+-- assumes there are 100000 rows in the table
+
+-- put all lines on one page
+set pagesize 0
+
+-- display numbers with a maximum width of 7
+set numwidth 7
+
+-- linesize should be "nr of columns" x (numwidth + 1)
+set linesize 408
+
+-- to specify the character between columns, default is ' '
+-- set colsep ','
+
+-- to eliminate the "... rows selected" message
+set feedback off
+
+-- do not echo results on terminal
+set termout off
+
+-- send output to t50.txt
+spool t50.txt
+
+select *
+from t50;
+
+
+-- stop capturing output
+spool off
+
+-- turn options back on
+set termout on
+set feedback on
Index: dumpt200.sql
===================================================================
RCS file: /cvsroot/monetdb/sql/src/benchmarks/scantest/dumpt200.sql,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -d -r1.1 -r1.2
--- dumpt200.sql 29 Dec 2002 18:57:08 -0000 1.1
+++ dumpt200.sql 7 Mar 2007 15:02:41 -0000 1.2
@@ -1,34 +1,34 @@
--- dumps table t200 to file t200.txt
--- assumes there are 100000 rows in the table
-
--- put all lines on one page
-set pagesize 0
-
--- display numbers with a maximum width of 7
-set numwidth 7
-
--- linesize should be "nr of columns" x (numwidth + 1)
-set linesize 1608
-
--- to specify the character between columns, default is ' '
--- set colsep ','
-
--- to eliminate the "... rows selected" message
-set feedback off
-
--- do not echo results on terminal
-set termout off
-
--- send output to t200.txt
-spool t200.txt
-
-select *
-from t200;
-
-
--- stop capturing output
-spool off
-
--- turn options back on
-set termout on
-set feedback on
+-- dumps table t200 to file t200.txt
+-- assumes there are 100000 rows in the table
+
+-- put all lines on one page
+set pagesize 0
+
+-- display numbers with a maximum width of 7
+set numwidth 7
+
+-- linesize should be "nr of columns" x (numwidth + 1)
+set linesize 1608
+
+-- to specify the character between columns, default is ' '
+-- set colsep ','
+
+-- to eliminate the "... rows selected" message
+set feedback off
+
+-- do not echo results on terminal
+set termout off
+
+-- send output to t200.txt
+spool t200.txt
+
+select *
+from t200;
+
+
+-- stop capturing output
+spool off
+
+-- turn options back on
+set termout on
+set feedback on
Index: ft200.sql
===================================================================
RCS file: /cvsroot/monetdb/sql/src/benchmarks/scantest/ft200.sql,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -d -r1.2 -r1.3
--- ft200.sql 1 Jan 2003 07:58:10 -0000 1.2
+++ ft200.sql 7 Mar 2007 15:02:41 -0000 1.3
@@ -1,21 +1,21 @@
--- uses table t200 (see ct200.sql)
---
--- USAGE
--- SQL> @ft200
--- SQL> exec ft200(10)
---
-
-CREATE OR REPLACE
-PROCEDURE ft200 (rows INTEGER) IS
- x NUMBER := 0.01;
-BEGIN
- FOR i IN 1..rows LOOP
- INSERT INTO t200 (Id,v1) VALUES (i, x);
- x := x + 0.01;
- END LOOP;
-END ft200;
-.
-
--- now execute program
-/
-exec ft200(100000)
+-- uses table t200 (see ct200.sql)
+--
+-- USAGE
+-- SQL> @ft200
+-- SQL> exec ft200(10)
+--
+
+CREATE OR REPLACE
+PROCEDURE ft200 (rows INTEGER) IS
+ x NUMBER := 0.01;
+BEGIN
+ FOR i IN 1..rows LOOP
+ INSERT INTO t200 (Id,v1) VALUES (i, x);
+ x := x + 0.01;
+ END LOOP;
+END ft200;
+.
+
+-- now execute program
+/
+exec ft200(100000)
Index: dumpt100.sql
===================================================================
RCS file: /cvsroot/monetdb/sql/src/benchmarks/scantest/dumpt100.sql,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -d -r1.1 -r1.2
--- dumpt100.sql 29 Dec 2002 18:57:08 -0000 1.1
+++ dumpt100.sql 7 Mar 2007 15:02:40 -0000 1.2
@@ -1,34 +1,34 @@
--- dumps table t100 to file t100.txt
--- assumes there are 100000 rows in the table
-
--- put all lines on one page
-set pagesize 0
-
--- display numbers with a maximum width of 7
-set numwidth 7
-
--- linesize should be "nr of columns" x (numwidth + 1)
-set linesize 808
-
--- to specify the character between columns, default is ' '
--- set colsep ','
-
--- to eliminate the "... rows selected" message
-set feedback off
-
--- do not echo results on terminal
-set termout off
-
--- send output to t100.txt
-spool t100.txt
-
-select *
-from t100;
-
-
--- stop capturing output
-spool off
-
--- turn options back on
-set termout on
-set feedback on
+-- dumps table t100 to file t100.txt
+-- assumes there are 100000 rows in the table
+
+-- put all lines on one page
+set pagesize 0
+
+-- display numbers with a maximum width of 7
+set numwidth 7
+
+-- linesize should be "nr of columns" x (numwidth + 1)
+set linesize 808
+
+-- to specify the character between columns, default is ' '
+-- set colsep ','
+
+-- to eliminate the "... rows selected" message
+set feedback off
+
+-- do not echo results on terminal
+set termout off
+
+-- send output to t100.txt
+spool t100.txt
+
+select *
+from t100;
+
+
+-- stop capturing output
+spool off
+
+-- turn options back on
+set termout on
+set feedback on
Index: ft5.sql
===================================================================
RCS file: /cvsroot/monetdb/sql/src/benchmarks/scantest/ft5.sql,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -d -r1.2 -r1.3
--- ft5.sql 1 Jan 2003 07:58:10 -0000 1.2
+++ ft5.sql 7 Mar 2007 15:02:41 -0000 1.3
@@ -1,21 +1,21 @@
--- uses table t5 (see ct5.sql)
---
--- USAGE
--- SQL> @ft5
--- SQL> exec ft5(10)
---
-
-CREATE OR REPLACE
-PROCEDURE ft5 (rows INTEGER) IS
- x NUMBER := 0.01;
-BEGIN
- FOR i IN 1..rows LOOP
- INSERT INTO t5 (Id,v1) VALUES (i, x);
- x := x + 0.01;
- END LOOP;
-END ft5;
-.
-
--- now execute program
-/
-exec ft5(100000)
+-- uses table t5 (see ct5.sql)
+--
+-- USAGE
+-- SQL> @ft5
+-- SQL> exec ft5(10)
+--
+
+CREATE OR REPLACE
+PROCEDURE ft5 (rows INTEGER) IS
+ x NUMBER := 0.01;
+BEGIN
+ FOR i IN 1..rows LOOP
+ INSERT INTO t5 (Id,v1) VALUES (i, x);
+ x := x + 0.01;
+ END LOOP;
+END ft5;
+.
+
+-- now execute program
+/
+exec ft5(100000)
Index: dumpt5.sql
===================================================================
RCS file: /cvsroot/monetdb/sql/src/benchmarks/scantest/dumpt5.sql,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -d -r1.1 -r1.2
--- dumpt5.sql 29 Dec 2002 18:57:08 -0000 1.1
+++ dumpt5.sql 7 Mar 2007 15:02:41 -0000 1.2
@@ -1,34 +1,34 @@
--- dumps table t5 to file t5.txt
--- assumes there are 100000 rows in the table
-
--- put all lines on one page
-set pagesize 0
-
--- display numbers with a maximum width of 7
-set numwidth 7
-
--- linesize should be "nr of columns" x (numwidth + 1)
-set linesize 48
-
--- to specify the character between columns, default is ' '
--- set colsep ','
-
--- to eliminate the "... rows selected" message
-set feedback off
-
--- do not echo results on terminal
-set termout off
-
--- send output to t5.txt
-spool t5.txt
-
-select *
-from t5;
-
-
--- stop capturing output
-spool off
-
--- turn options back on
-set termout on
-set feedback on
+-- dumps table t5 to file t5.txt
+-- assumes there are 100000 rows in the table
+
+-- put all lines on one page
+set pagesize 0
+
+-- display numbers with a maximum width of 7
+set numwidth 7
+
+-- linesize should be "nr of columns" x (numwidth + 1)
+set linesize 48
+
+-- to specify the character between columns, default is ' '
+-- set colsep ','
+
+-- to eliminate the "... rows selected" message
+set feedback off
+
+-- do not echo results on terminal
+set termout off
+
+-- send output to t5.txt
+spool t5.txt
+
+select *
+from t5;
+
+
+-- stop capturing output
+spool off
+
+-- turn options back on
+set termout on
+set feedback on
Index: dumpt25.sql
===================================================================
RCS file: /cvsroot/monetdb/sql/src/benchmarks/scantest/dumpt25.sql,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -d -r1.1 -r1.2
--- dumpt25.sql 29 Dec 2002 18:57:08 -0000 1.1
+++ dumpt25.sql 7 Mar 2007 15:02:41 -0000 1.2
@@ -1,34 +1,34 @@
--- dumps table t25 to file t25.txt
--- assumes there are 100000 rows in the table
-
--- put all lines on one page
-set pagesize 0
-
--- display numbers with a maximum width of 7
-set numwidth 7
-
--- linesize should be "nr of columns" x (numwidth + 1)
-set linesize 208
-
--- to specify the character between columns, default is ' '
--- set colsep ','
-
--- to eliminate the "... rows selected" message
-set feedback off
-
--- do not echo results on terminal
-set termout off
-
--- send output to t25.txt
-spool t25.txt
-
-select *
-from t25;
-
-
--- stop capturing output
-spool off
-
--- turn options back on
-set termout on
-set feedback on
+-- dumps table t25 to file t25.txt
+-- assumes there are 100000 rows in the table
+
+-- put all lines on one page
+set pagesize 0
+
+-- display numbers with a maximum width of 7
+set numwidth 7
+
+-- linesize should be "nr of columns" x (numwidth + 1)
+set linesize 208
+
+-- to specify the character between columns, default is ' '
+-- set colsep ','
+
+-- to eliminate the "... rows selected" message
+set feedback off
+
+-- do not echo results on terminal
+set termout off
+
+-- send output to t25.txt
+spool t25.txt
+
+select *
+from t25;
+
+
+-- stop capturing output
+spool off
+
+-- turn options back on
+set termout on
+set feedback on
Index: dumpt1.sql
===================================================================
RCS file: /cvsroot/monetdb/sql/src/benchmarks/scantest/dumpt1.sql,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -d -r1.1 -r1.2
--- dumpt1.sql 29 Dec 2002 18:57:08 -0000 1.1
+++ dumpt1.sql 7 Mar 2007 15:02:40 -0000 1.2
@@ -1,34 +1,34 @@
--- dumps table t1 to file t1.txt
--- assumes there are 100000 rows in the table
-
--- put all lines on one page
-set pagesize 0
-
--- display numbers with a maximum width of 7
-set numwidth 7
-
--- linesize should be "nr of columns" x (numwidth + 1)
-set linesize 16
-
--- to specify the character between columns, default is ' '
--- set colsep ','
-
--- to eliminate the "... rows selected" message
-set feedback off
-
--- do not echo results on terminal
-set termout off
-
--- send output to t1.txt
-spool t1.txt
-
-select *
-from t1;
-
-
--- stop capturing output
-spool off
-
--- turn options back on
-set termout on
-set feedback on
+-- dumps table t1 to file t1.txt
+-- assumes there are 100000 rows in the table
+
+-- put all lines on one page
+set pagesize 0
+
+-- display numbers with a maximum width of 7
+set numwidth 7
+
+-- linesize should be "nr of columns" x (numwidth + 1)
+set linesize 16
+
+-- to specify the character between columns, default is ' '
+-- set colsep ','
+
+-- to eliminate the "... rows selected" message
+set feedback off
+
+-- do not echo results on terminal
+set termout off
+
+-- send output to t1.txt
+spool t1.txt
+
+select *
+from t1;
+
+
+-- stop capturing output
+spool off
+
+-- turn options back on
+set termout on
+set feedback on
Index: ft100.sql
===================================================================
RCS file: /cvsroot/monetdb/sql/src/benchmarks/scantest/ft100.sql,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -d -r1.2 -r1.3
--- ft100.sql 1 Jan 2003 07:58:10 -0000 1.2
+++ ft100.sql 7 Mar 2007 15:02:41 -0000 1.3
@@ -1,21 +1,21 @@
--- uses table t100 (see ct100.sql)
---
--- USAGE
--- SQL> @ft100
--- SQL> exec ft100(10)
---
-
-CREATE OR REPLACE
-PROCEDURE ft100 (rows INTEGER) IS
- x NUMBER := 0.01;
-BEGIN
- FOR i IN 1..rows LOOP
- INSERT INTO t100 (Id,v1) VALUES (i, x);
- x := x + 0.01;
- END LOOP;
-END ft100;
-.
-
--- now execute program
-/
-exec ft100(100000)
+-- uses table t100 (see ct100.sql)
+--
+-- USAGE
+-- SQL> @ft100
+-- SQL> exec ft100(10)
+--
+
+CREATE OR REPLACE
+PROCEDURE ft100 (rows INTEGER) IS
+ x NUMBER := 0.01;
+BEGIN
+ FOR i IN 1..rows LOOP
+ INSERT INTO t100 (Id,v1) VALUES (i, x);
+ x := x + 0.01;
+ END LOOP;
+END ft100;
+.
+
+-- now execute program
+/
+exec ft100(100000)
Index: info.sql
===================================================================
RCS file: /cvsroot/monetdb/sql/src/benchmarks/scantest/info.sql,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -d -r1.1 -r1.2
--- info.sql 29 Dec 2002 18:57:08 -0000 1.1
+++ info.sql 7 Mar 2007 15:02:41 -0000 1.2
@@ -1,2 +1,2 @@
-select table_name from user_tables;
-
+select table_name from user_tables;
+
Index: ft25.sql
===================================================================
RCS file: /cvsroot/monetdb/sql/src/benchmarks/scantest/ft25.sql,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -d -r1.2 -r1.3
--- ft25.sql 1 Jan 2003 07:58:10 -0000 1.2
+++ ft25.sql 7 Mar 2007 15:02:41 -0000 1.3
@@ -1,21 +1,21 @@
--- uses table t25 (see ct25.sql)
---
--- USAGE
--- SQL> @ft25
--- SQL> exec ft25(10)
---
-
-CREATE OR REPLACE
-PROCEDURE ft25 (rows INTEGER) IS
- x NUMBER := 0.01;
-BEGIN
- FOR i IN 1..rows LOOP
- INSERT INTO t25 (Id,v1) VALUES (i, x);
- x := x + 0.01;
- END LOOP;
-END ft25;
-.
-
--- now execute program
-/
-exec ft25(100000)
+-- uses table t25 (see ct25.sql)
+--
+-- USAGE
+-- SQL> @ft25
+-- SQL> exec ft25(10)
+--
+
+CREATE OR REPLACE
+PROCEDURE ft25 (rows INTEGER) IS
+ x NUMBER := 0.01;
+BEGIN
+ FOR i IN 1..rows LOOP
+ INSERT INTO t25 (Id,v1) VALUES (i, x);
+ x := x + 0.01;
+ END LOOP;
+END ft25;
+.
+
+-- now execute program
+/
+exec ft25(100000)
Index: readme.txt
===================================================================
RCS file: /cvsroot/monetdb/sql/src/benchmarks/scantest/readme.txt,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -d -r1.1 -r1.2
--- readme.txt 29 Dec 2002 18:57:08 -0000 1.1
+++ readme.txt 7 Mar 2007 15:02:41 -0000 1.2
@@ -1,27 +1,27 @@
-sqlplus scantest/[EMAIL PROTECTED]:
-
-set verify off
-set timing on
-
[EMAIL PROTECTED]
[EMAIL PROTECTED]
-exec ft1(100000)
[EMAIL PROTECTED] 10000
-etc.
-
-
-
-===================================================================
-select sum(v1)+sum(v2)+sum(v3)+sum(v4)+sum(v5) from t5;
-is faster (0.37 vs 0.45) than
-select sum(v1+v2+v3+v4+v5) from t5;
-
-Using sum(v1+v2+v3+v4+v5) as it is a more "realistic" feature measure.
-
-===================================================================
-select sum(v1+v2+v3+v4+v5) from t5;
-is faster (0.45 vs 0.50) than
-select sum(v1+v2+v3+v4+v5) from t5 where rownum < &1;
-when doing the same number of rows
-
-Using rownum for easier experimentation.
+sqlplus scantest/[EMAIL PROTECTED]:
+
+set verify off
+set timing on
+
[EMAIL PROTECTED]
[EMAIL PROTECTED]
+exec ft1(100000)
[EMAIL PROTECTED] 10000
+etc.
+
+
+
+===================================================================
+select sum(v1)+sum(v2)+sum(v3)+sum(v4)+sum(v5) from t5;
+is faster (0.37 vs 0.45) than
+select sum(v1+v2+v3+v4+v5) from t5;
+
+Using sum(v1+v2+v3+v4+v5) as it is a more "realistic" feature measure.
+
+===================================================================
+select sum(v1+v2+v3+v4+v5) from t5;
+is faster (0.45 vs 0.50) than
+select sum(v1+v2+v3+v4+v5) from t5 where rownum < &1;
+when doing the same number of rows
+
+Using rownum for easier experimentation.
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
