Revision 973
Added by Jing Tao over 22 years ago
| test/queryperformance.sh | ||
|---|---|---|
| 1 |
#!/bin/sh |
|
| 2 |
# Jing Tao |
|
| 3 |
# This program will invoke DBQuery class to test query performance with path (index) or nested query(non-index) |
|
| 4 |
|
|
| 5 |
echo "---------------------Result------------------" |
|
| 6 |
echo " PrepQuery Execut OpenDB Read Size " |
|
| 7 |
echo -n "INDEXED DEPTH 0 " |
|
| 8 |
java -cp /usr/local/devtools/jakarta-tomcat/lib/common/servlet.jar:../build/metacat.jar:../lib/xerces.jar:/oracle01/app/oracle/product/8.1.6/jdbc/lib/classes111.zip edu.ucsb.nceas.metacat.DBQuery -t -index pathquerydepth0 |
|
| 9 |
echo -n "NONINDEXED DEPTH 0 " |
|
| 10 |
java -cp /usr/local/devtools/jakarta-tomcat/lib/common/servlet.jar:../build/metacat.jar:../lib/xerces.jar:/oracle01/app/oracle/product/8.1.6/jdbc/lib/classes111.zip edu.ucsb.nceas.metacat.DBQuery -t pathquerydepth0 |
|
| 11 |
|
|
| 12 |
echo -n "INDEXED DEPTH 1 " |
|
| 13 |
java -cp /usr/local/devtools/jakarta-tomcat/lib/common/servlet.jar:../build/metacat.jar:../lib/xerces.jar:/oracle01/app/oracle/product/8.1.6/jdbc/lib/classes111.zip edu.ucsb.nceas.metacat.DBQuery -t -index pathquerydepth1 |
|
| 14 |
echo -n "NONINDEXED DEPTH 1 " |
|
| 15 |
java -cp /usr/local/devtools/jakarta-tomcat/lib/common/servlet.jar:../build/metacat.jar:../lib/xerces.jar:/oracle01/app/oracle/product/8.1.6/jdbc/lib/classes111.zip edu.ucsb.nceas.metacat.DBQuery -t pathquerydepth1 |
|
| 16 |
|
|
| 17 |
|
|
| 18 |
echo -n "INDEXED DEPTH 2 " |
|
| 19 |
java -cp /usr/local/devtools/jakarta-tomcat/lib/common/servlet.jar:../build/metacat.jar:../lib/xerces.jar:/oracle01/app/oracle/product/8.1.6/jdbc/lib/classes111.zip edu.ucsb.nceas.metacat.DBQuery -t -index pathquerydepth2 |
|
| 20 |
echo -n "NONINDEXED DEPTH 2 " |
|
| 21 |
java -cp /usr/local/devtools/jakarta-tomcat/lib/common/servlet.jar:../build/metacat.jar:../lib/xerces.jar:/oracle01/app/oracle/product/8.1.6/jdbc/lib/classes111.zip edu.ucsb.nceas.metacat.DBQuery -t pathquerydepth2 |
|
| 22 |
|
|
| 23 |
|
|
| 24 |
echo -n "INDEXED DEPTH 3 " |
|
| 25 |
java -cp /usr/local/devtools/jakarta-tomcat/lib/common/servlet.jar:../build/metacat.jar:../lib/xerces.jar:/oracle01/app/oracle/product/8.1.6/jdbc/lib/classes111.zip edu.ucsb.nceas.metacat.DBQuery -t -index pathquerydepth3 |
|
| 26 |
echo -n "NONINDEXED DEPTH 3 " |
|
| 27 |
java -cp /usr/local/devtools/jakarta-tomcat/lib/common/servlet.jar:../build/metacat.jar:../lib/xerces.jar:/oracle01/app/oracle/product/8.1.6/jdbc/lib/classes111.zip edu.ucsb.nceas.metacat.DBQuery -t pathquerydepth3 |
|
| 28 |
|
|
| 29 |
|
|
| 30 |
echo -n "INDEXED DEPTH 4 " |
|
| 31 |
java -cp /usr/local/devtools/jakarta-tomcat/lib/common/servlet.jar:../build/metacat.jar:../lib/xerces.jar:/oracle01/app/oracle/product/8.1.6/jdbc/lib/classes111.zip edu.ucsb.nceas.metacat.DBQuery -t -index pathquerydepth4 |
|
| 32 |
echo -n "NONINDEXED DEPTH 4 " |
|
| 33 |
java -cp /usr/local/devtools/jakarta-tomcat/lib/common/servlet.jar:../build/metacat.jar:../lib/xerces.jar:/oracle01/app/oracle/product/8.1.6/jdbc/lib/classes111.zip edu.ucsb.nceas.metacat.DBQuery -t pathquerydepth4 |
|
| 34 |
|
|
| 35 |
|
|
| 36 |
echo -n "INDEXED DEPTH 5 " |
|
| 37 |
java -cp /usr/local/devtools/jakarta-tomcat/lib/common/servlet.jar:../build/metacat.jar:../lib/xerces.jar:/oracle01/app/oracle/product/8.1.6/jdbc/lib/classes111.zip edu.ucsb.nceas.metacat.DBQuery -t -index pathquerydepth5 |
|
| 38 |
echo -n "NONINDEXED DEPTH 5 " |
|
| 39 |
java -cp /usr/local/devtools/jakarta-tomcat/lib/common/servlet.jar:../build/metacat.jar:../lib/xerces.jar:/oracle01/app/oracle/product/8.1.6/jdbc/lib/classes111.zip edu.ucsb.nceas.metacat.DBQuery -t pathquerydepth5 |
|
| 40 |
|
|
| 41 |
|
|
| 42 |
|
|
| 43 |
echo "-------------" |
|
| 44 |
echo "TEST COMPLETE" |
|
| 45 |
echo "-------------" |
|
| 0 | 46 | |
Also available in: Unified diff
This script file can run serials queries and print out the running time.