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 "-------------"
|