Project

General

Profile

« Previous | Next » 

Revision 973

Added by Jing Tao over 22 years ago

This script file can run serials queries and print out the running time.

View differences:

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