Revision 713
Added by berkley about 23 years ago
query.sh | ||
---|---|---|
1 | 1 |
echo "---------------------TSTMT------------------" |
2 |
echo "TSTMT INDEXED DEPTH 3" |
|
2 |
echo -n "TSTMT INDEXED DEPTH 0 " |
|
3 |
java -classpath /home/computer/berkley/project/berkley/xmltodb/build/metacat.jar:/opt/tomcat/webapps/berkley/WEB-INF/lib/xerces.jar:/opt/tomcat/webapps/berkley/WEB-INF/lib/xmlparserv2.jar:/opt/tomcat/webapps/berkley/WEB-INF/lib/oracle-jdbc111.jar:./:/home/computer/berkley/project/ edu.ucsb.nceas.metacat.DBQuery -t -index pathquery0 |
|
4 |
echo -n "TSTMT INDEXED DEPTH 1 " |
|
5 |
java -classpath /home/computer/berkley/project/berkley/xmltodb/build/metacat.jar:/opt/tomcat/webapps/berkley/WEB-INF/lib/xerces.jar:/opt/tomcat/webapps/berkley/WEB-INF/lib/xmlparserv2.jar:/opt/tomcat/webapps/berkley/WEB-INF/lib/oracle-jdbc111.jar:./:/home/computer/berkley/project/ edu.ucsb.nceas.metacat.DBQuery -t -index pathquery1tstmt |
|
6 |
echo -n "TSTMT INDEXED DEPTH 2 " |
|
7 |
java -classpath /home/computer/berkley/project/berkley/xmltodb/build/metacat.jar:/opt/tomcat/webapps/berkley/WEB-INF/lib/xerces.jar:/opt/tomcat/webapps/berkley/WEB-INF/lib/xmlparserv2.jar:/opt/tomcat/webapps/berkley/WEB-INF/lib/oracle-jdbc111.jar:./:/home/computer/berkley/project/ edu.ucsb.nceas.metacat.DBQuery -t -index pathquery2tstmt |
|
8 |
echo -n "TSTMT INDEXED DEPTH 3 " |
|
3 | 9 |
java -classpath /home/computer/berkley/project/berkley/xmltodb/build/metacat.jar:/opt/tomcat/webapps/berkley/WEB-INF/lib/xerces.jar:/opt/tomcat/webapps/berkley/WEB-INF/lib/xmlparserv2.jar:/opt/tomcat/webapps/berkley/WEB-INF/lib/oracle-jdbc111.jar:./:/home/computer/berkley/project/ edu.ucsb.nceas.metacat.DBQuery -t -index pathquery3tstmt |
4 |
|
|
5 |
echo "" |
|
6 |
echo "TSTMT INDEXED DEPTH 4" |
|
10 |
echo -n "TSTMT INDEXED DEPTH 4 " |
|
7 | 11 |
java -classpath /home/computer/berkley/project/berkley/xmltodb/build/metacat.jar:/opt/tomcat/webapps/berkley/WEB-INF/lib/xerces.jar:/opt/tomcat/webapps/berkley/WEB-INF/lib/xmlparserv2.jar:/opt/tomcat/webapps/berkley/WEB-INF/lib/oracle-jdbc111.jar:./:/home/computer/berkley/project/ edu.ucsb.nceas.metacat.DBQuery -t -index pathquery4tstmt |
8 |
|
|
9 |
echo "" |
|
10 |
echo "TSTMT INDEXED DEPTH 5" |
|
12 |
echo -n "TSTMT INDEXED DEPTH 5 " |
|
11 | 13 |
java -classpath /home/computer/berkley/project/berkley/xmltodb/build/metacat.jar:/opt/tomcat/webapps/berkley/WEB-INF/lib/xerces.jar:/opt/tomcat/webapps/berkley/WEB-INF/lib/xmlparserv2.jar:/opt/tomcat/webapps/berkley/WEB-INF/lib/oracle-jdbc111.jar:./:/home/computer/berkley/project/ edu.ucsb.nceas.metacat.DBQuery -t -index pathquery5tstmt |
14 |
echo -n "TSTMT INDEXED DEPTH 6 " |
|
15 |
java -classpath /home/computer/berkley/project/berkley/xmltodb/build/metacat.jar:/opt/tomcat/webapps/berkley/WEB-INF/lib/xerces.jar:/opt/tomcat/webapps/berkley/WEB-INF/lib/xmlparserv2.jar:/opt/tomcat/webapps/berkley/WEB-INF/lib/oracle-jdbc111.jar:./:/home/computer/berkley/project/ edu.ucsb.nceas.metacat.DBQuery -t -index pathquery6tstmt |
|
12 | 16 |
|
13 |
echo "" |
|
14 |
echo "TSTMT NONINDEXED DEPTH 3" |
|
17 |
echo -n "TSTMT NONINDEXED DEPTH 0 " |
|
18 |
java -classpath /home/computer/berkley/project/berkley/xmltodb/build/metacat.jar:/opt/tomcat/webapps/berkley/WEB-INF/lib/xerces.jar:/opt/tomcat/webapps/berkley/WEB-INF/lib/xmlparserv2.jar:/opt/tomcat/webapps/berkley/WEB-INF/lib/oracle-jdbc111.jar:./:/home/computer/berkley/project/ edu.ucsb.nceas.metacat.DBQuery -t pathquery0 |
|
19 |
echo -n "TSTMT NONINDEXED DEPTH 1 " |
|
20 |
java -classpath /home/computer/berkley/project/berkley/xmltodb/build/metacat.jar:/opt/tomcat/webapps/berkley/WEB-INF/lib/xerces.jar:/opt/tomcat/webapps/berkley/WEB-INF/lib/xmlparserv2.jar:/opt/tomcat/webapps/berkley/WEB-INF/lib/oracle-jdbc111.jar:./:/home/computer/berkley/project/ edu.ucsb.nceas.metacat.DBQuery -t pathquery1tstmt |
|
21 |
echo -n "TSTMT NONINDEXED DEPTH 2 " |
|
22 |
java -classpath /home/computer/berkley/project/berkley/xmltodb/build/metacat.jar:/opt/tomcat/webapps/berkley/WEB-INF/lib/xerces.jar:/opt/tomcat/webapps/berkley/WEB-INF/lib/xmlparserv2.jar:/opt/tomcat/webapps/berkley/WEB-INF/lib/oracle-jdbc111.jar:./:/home/computer/berkley/project/ edu.ucsb.nceas.metacat.DBQuery -t pathquery2tstmt |
|
23 |
echo -n "TSTMT NONINDEXED DEPTH 3 " |
|
15 | 24 |
java -classpath /home/computer/berkley/project/berkley/xmltodb/build/metacat.jar:/opt/tomcat/webapps/berkley/WEB-INF/lib/xerces.jar:/opt/tomcat/webapps/berkley/WEB-INF/lib/xmlparserv2.jar:/opt/tomcat/webapps/berkley/WEB-INF/lib/oracle-jdbc111.jar:./:/home/computer/berkley/project/ edu.ucsb.nceas.metacat.DBQuery -t pathquery3tstmt |
16 |
|
|
17 |
echo "" |
|
18 |
echo "TSTMT NONINDEXED DEPTH 4" |
|
25 |
echo -n "TSTMT NONINDEXED DEPTH 4 " |
|
19 | 26 |
java -classpath /home/computer/berkley/project/berkley/xmltodb/build/metacat.jar:/opt/tomcat/webapps/berkley/WEB-INF/lib/xerces.jar:/opt/tomcat/webapps/berkley/WEB-INF/lib/xmlparserv2.jar:/opt/tomcat/webapps/berkley/WEB-INF/lib/oracle-jdbc111.jar:./:/home/computer/berkley/project/ edu.ucsb.nceas.metacat.DBQuery -t pathquery4tstmt |
20 |
|
|
21 |
echo "" |
|
22 |
echo "TSTMT NONINDEXED DEPTH 5" |
|
27 |
echo -n "TSTMT NONINDEXED DEPTH 5 " |
|
23 | 28 |
java -classpath /home/computer/berkley/project/berkley/xmltodb/build/metacat.jar:/opt/tomcat/webapps/berkley/WEB-INF/lib/xerces.jar:/opt/tomcat/webapps/berkley/WEB-INF/lib/xmlparserv2.jar:/opt/tomcat/webapps/berkley/WEB-INF/lib/oracle-jdbc111.jar:./:/home/computer/berkley/project/ edu.ucsb.nceas.metacat.DBQuery -t pathquery5tstmt |
29 |
echo -n "TSTMT NONINDEXED DEPTH 6 " |
|
30 |
java -classpath /home/computer/berkley/project/berkley/xmltodb/build/metacat.jar:/opt/tomcat/webapps/berkley/WEB-INF/lib/xerces.jar:/opt/tomcat/webapps/berkley/WEB-INF/lib/xmlparserv2.jar:/opt/tomcat/webapps/berkley/WEB-INF/lib/oracle-jdbc111.jar:./:/home/computer/berkley/project/ edu.ucsb.nceas.metacat.DBQuery -t pathquery6tstmt |
|
24 | 31 |
|
25 |
|
|
26 |
echo "-------------------PLAY-----------------------" |
|
27 |
echo "PLAY INDEXED DEPTH 3" |
|
28 |
java -classpath /home/computer/berkley/project/berkley/xmltodb/build/metacat.jar:/opt/tomcat/webapps/berkley/WEB-INF/lib/xerces.jar:/opt/tomcat/webapps/berkley/WEB-INF/lib/xmlparserv2.jar:/opt/tomcat/webapps/berkley/WEB-INF/lib/oracle-jdbc111.jar:./:/home/computer/berkley/project/ edu.ucsb.nceas.metacat.DBQuery -t -index pathquery3play |
|
29 |
|
|
30 |
echo "" |
|
31 |
echo "PLAY INDEXED DEPTH 4" |
|
32 |
java -classpath /home/computer/berkley/project/berkley/xmltodb/build/metacat.jar:/opt/tomcat/webapps/berkley/WEB-INF/lib/xerces.jar:/opt/tomcat/webapps/berkley/WEB-INF/lib/xmlparserv2.jar:/opt/tomcat/webapps/berkley/WEB-INF/lib/oracle-jdbc111.jar:./:/home/computer/berkley/project/ edu.ucsb.nceas.metacat.DBQuery -t -index pathquery4play |
|
33 |
|
|
34 |
echo "" |
|
35 |
echo "PLAY INDEXED DEPTH 5" |
|
36 |
java -classpath /home/computer/berkley/project/berkley/xmltodb/build/metacat.jar:/opt/tomcat/webapps/berkley/WEB-INF/lib/xerces.jar:/opt/tomcat/webapps/berkley/WEB-INF/lib/xmlparserv2.jar:/opt/tomcat/webapps/berkley/WEB-INF/lib/oracle-jdbc111.jar:./:/home/computer/berkley/project/ edu.ucsb.nceas.metacat.DBQuery -t -index pathquery5play |
|
37 |
|
|
38 |
echo "" |
|
39 |
echo "PLAY NONINDEXED DEPTH 3" |
|
40 |
java -classpath /home/computer/berkley/project/berkley/xmltodb/build/metacat.jar:/opt/tomcat/webapps/berkley/WEB-INF/lib/xerces.jar:/opt/tomcat/webapps/berkley/WEB-INF/lib/xmlparserv2.jar:/opt/tomcat/webapps/berkley/WEB-INF/lib/oracle-jdbc111.jar:./:/home/computer/berkley/project/ edu.ucsb.nceas.metacat.DBQuery -t pathquery3play |
|
41 |
|
|
42 |
echo "" |
|
43 |
echo "PLAY NONINDEXED DEPTH 4" |
|
44 |
java -classpath /home/computer/berkley/project/berkley/xmltodb/build/metacat.jar:/opt/tomcat/webapps/berkley/WEB-INF/lib/xerces.jar:/opt/tomcat/webapps/berkley/WEB-INF/lib/xmlparserv2.jar:/opt/tomcat/webapps/berkley/WEB-INF/lib/oracle-jdbc111.jar:./:/home/computer/berkley/project/ edu.ucsb.nceas.metacat.DBQuery -t pathquery4play |
|
45 |
|
|
46 |
echo "" |
|
47 |
echo "PLAY NONINDEXED DEPTH 5" |
|
48 |
java -classpath /home/computer/berkley/project/berkley/xmltodb/build/metacat.jar:/opt/tomcat/webapps/berkley/WEB-INF/lib/xerces.jar:/opt/tomcat/webapps/berkley/WEB-INF/lib/xmlparserv2.jar:/opt/tomcat/webapps/berkley/WEB-INF/lib/oracle-jdbc111.jar:./:/home/computer/berkley/project/ edu.ucsb.nceas.metacat.DBQuery -t pathquery5play |
|
49 |
|
|
50 | 32 |
echo "-------------" |
51 | 33 |
echo "TEST COMPLETE" |
52 | 34 |
echo "-------------" |
Also available in: Unified diff
script and data files for performance testing