Update of /cvsroot/monetdb/sql/src/test/BugDay_2005-10-06_2.9.3/Tests
In directory sc8-pr-cvs16:/tmp/cvs-serv4950/Tests
Modified Files:
slow_counting_1.SF-923709.sql
slow_counting_1.SF-923709.stable.out
slow_counting_2.SF-923709.stable.out
Log Message:
Reduce execution time.
Index: slow_counting_1.SF-923709.stable.out
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugDay_2005-10-06_2.9.3/Tests/slow_counting_1.SF-923709.stable.out,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -d -r1.2 -r1.3
--- slow_counting_1.SF-923709.stable.out 7 Dec 2006 19:11:18 -0000
1.2
+++ slow_counting_1.SF-923709.stable.out 28 Apr 2007 19:11:36 -0000
1.3
@@ -1,19 +1,17 @@
stdout of test 'slow_counting_1.SF-923709` in directory
'src/test/BugDay_2005-10-06_2.9.3` itself:
-# 19:05:32 >
-# 19:05:32 > Mtimeout -timeout 180 Mserver
"--config=/ufs/niels/scratch/rc/Linux-x86_64/etc/MonetDB.conf" --debug=10 --set
"monet_mod_path=/ufs/niels/scratch/rc/Linux-x86_64/lib64/MonetDB:/ufs/niels/scratch/rc/Linux-x86_64/lib64/MonetDB/lib:/ufs/niels/scratch/rc/Linux-x86_64/lib64/MonetDB/bin"
--set "gdk_dbfarm=/ufs/niels/scratch/rc/Linux-x86_64/var/MonetDB/dbfarm" --set
"sql_logdir=/ufs/niels/scratch/rc/Linux-x86_64/var/MonetDB/sql_logs" --set
"sql_logdir=/ufs/niels/scratch/rc/Linux-x86_64/var/MonetDB/xquery_logs" --set
mapi_port=37689 --set monet_prompt= --trace
"--dbname=mTests_src_test_BugDay_2005-10-06_2.9.3" --dbinit="
module(sql_server);" ; echo ; echo Over..
-# 19:05:32 >
-
-# Monet Database Server V4.14.0
-# Copyright (c) 1993-2006, CWI. All rights reserved.
-# Compiled for x86_64-redhat-linux-gnu/64bit with 64bit OIDs; dynamically
linked.
-# Visit http://monetdb.cwi.nl/ for further information.
+# 21:03:27 >
+# 21:03:27 > Mtimeout -timeout 180 mserver5
"--config=/ufs/mk/monet5/Linux/etc/monetdb5.conf" --debug=10 --set
"monet_mod_path=/ufs/mk/monet5//Linux/lib/MonetDB5:/ufs/mk/monet5//Linux/lib/MonetDB5/lib:/ufs/mk/monet5//Linux/lib/MonetDB5/bin"
--set "gdk_dbfarm=/ufs/mk/monet5//dbfarm" --set
"sql_logdir=/ufs/mk/monet5//dblogs/logs/sql" --set
"xquery_logdir=/ufs/mk/monet5//Linux/var/MonetDB5/xquery_logs" --set
mapi_port=37933 --set xrpc_port=41509 --set monet_prompt= --trace
"--dbname=mTests_src_test_BugDay_2005-10-06_2.9.3" --dbinit=' include sql;' ;
echo ; echo Over..
+# 21:03:27 >
-printf("\nReady.\n");
+# MonetDB Server v5.0.0_beta2_1
+# Copyright (c) 1993-2007 CWI, all rights reserved
+# Compiled for x86_64-redhat-linux-gnu/64bit with 64bit OIDs dynamically linked
+# dbname:mTests_src_test_BugDay_2005-10-06_2.9.3
+# Visit http://monetdb.cwi.nl/ for further information
Ready.
-quit();
Over..
@@ -39,14 +37,6 @@
[ 16384 ]
[ 32768 ]
[ 65536 ]
-[ 131072 ]
-[ 262144 ]
-[ 524288 ]
-[ 1048576 ]
-[ 2097152 ]
-[ 4194304 ]
-[ 8388608 ]
-[ 16777216 ]
% . # table_name
% gen_insert_single_value # name
% int # type
@@ -55,8 +45,8 @@
% sys. # table_name
% count_ # name
% int # type
-% 8 # length
-[ 33554432 ]
+% 6 # length
+[ 131072 ]
# 19:05:59 >
# 19:05:59 > Done.
Index: slow_counting_1.SF-923709.sql
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugDay_2005-10-06_2.9.3/Tests/slow_counting_1.SF-923709.sql,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -d -r1.2 -r1.3
--- slow_counting_1.SF-923709.sql 7 Dec 2006 19:11:18 -0000 1.2
+++ slow_counting_1.SF-923709.sql 28 Apr 2007 19:11:36 -0000 1.3
@@ -10,6 +10,6 @@
end while;
return 0;
end;
-select gen_insert(25);
+select gen_insert(17); -- previous call was 25
select count(*) from slow_count;
Index: slow_counting_2.SF-923709.stable.out
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugDay_2005-10-06_2.9.3/Tests/slow_counting_2.SF-923709.stable.out,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -d -r1.2 -r1.3
--- slow_counting_2.SF-923709.stable.out 7 Dec 2006 19:11:19 -0000
1.2
+++ slow_counting_2.SF-923709.stable.out 28 Apr 2007 19:11:37 -0000
1.3
@@ -1,19 +1,17 @@
stdout of test 'slow_counting_2.SF-923709` in directory
'src/test/BugDay_2005-10-06_2.9.3` itself:
-# 19:05:59 >
-# 19:05:59 > Mtimeout -timeout 180 Mserver
"--config=/ufs/niels/scratch/rc/Linux-x86_64/etc/MonetDB.conf" --debug=10 --set
"monet_mod_path=/ufs/niels/scratch/rc/Linux-x86_64/lib64/MonetDB:/ufs/niels/scratch/rc/Linux-x86_64/lib64/MonetDB/lib:/ufs/niels/scratch/rc/Linux-x86_64/lib64/MonetDB/bin"
--set "gdk_dbfarm=/ufs/niels/scratch/rc/Linux-x86_64/var/MonetDB/dbfarm" --set
"sql_logdir=/ufs/niels/scratch/rc/Linux-x86_64/var/MonetDB/sql_logs" --set
"sql_logdir=/ufs/niels/scratch/rc/Linux-x86_64/var/MonetDB/xquery_logs" --set
mapi_port=37689 --set monet_prompt= --trace
"--dbname=mTests_src_test_BugDay_2005-10-06_2.9.3" --dbinit="
module(sql_server);" ; echo ; echo Over..
-# 19:05:59 >
-
-# Monet Database Server V4.14.0
-# Copyright (c) 1993-2006, CWI. All rights reserved.
-# Compiled for x86_64-redhat-linux-gnu/64bit with 64bit OIDs; dynamically
linked.
-# Visit http://monetdb.cwi.nl/ for further information.
+# 21:03:28 >
+# 21:03:28 > Mtimeout -timeout 180 mserver5
"--config=/ufs/mk/monet5/Linux/etc/monetdb5.conf" --debug=10 --set
"monet_mod_path=/ufs/mk/monet5//Linux/lib/MonetDB5:/ufs/mk/monet5//Linux/lib/MonetDB5/lib:/ufs/mk/monet5//Linux/lib/MonetDB5/bin"
--set "gdk_dbfarm=/ufs/mk/monet5//dbfarm" --set
"sql_logdir=/ufs/mk/monet5//dblogs/logs/sql" --set
"xquery_logdir=/ufs/mk/monet5//Linux/var/MonetDB5/xquery_logs" --set
mapi_port=37933 --set xrpc_port=41509 --set monet_prompt= --trace
"--dbname=mTests_src_test_BugDay_2005-10-06_2.9.3" --dbinit=' include sql;' ;
echo ; echo Over..
+# 21:03:28 >
-printf("\nReady.\n");
+# MonetDB Server v5.0.0_beta2_1
+# Copyright (c) 1993-2007 CWI, all rights reserved
+# Compiled for x86_64-redhat-linux-gnu/64bit with 64bit OIDs dynamically linked
+# dbname:mTests_src_test_BugDay_2005-10-06_2.9.3
+# Visit http://monetdb.cwi.nl/ for further information
Ready.
-quit();
Over..
@@ -24,8 +22,8 @@
% sys. # table_name
% count_ # name
% int # type
-% 8 # length
-[ 33554432 ]
+% 6 # length
+[ 131072 ]
# 19:06:15 >
# 19:06:15 > Done.
-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
