7 public class noIndexTest
{
9 public static void main(String
[] args
) {
15 int noOfRecords
=10000;
16 Connection con
= connect
.getDBConn();
17 Statement cStmt
= con
.createStatement();
18 cStmt
.execute("CREATE TABLE emp (f1 int, f2 char (20));");
19 connect
[] conth
= new connect
[10];
20 System
.out
.println("Table Insert");
21 for(int i
=0;i
<noOfThreads
;i
++)
23 conth
[i
] = new connect(i
,0,noOfRecords
);
25 for(int i
=0;i
<noOfThreads
;i
++)
29 long totalTimeTaken
=0;
30 for(int i
=0;i
<noOfThreads
;i
++)
32 totalTimeTaken
= totalTimeTaken
+ conth
[i
].timeTaken
;
34 System
.out
.println("Table Insert " + totalTimeTaken
);
37 for(int i
=0;i
<noOfThreads
;i
++)
39 conth
[i
] = new connect(i
,1,noOfRecords
);
41 for(int i
=0;i
<noOfThreads
;i
++)
46 for(int i
=0;i
<noOfThreads
;i
++)
48 totalTimeTaken
= totalTimeTaken
+ conth
[i
].timeTaken
;
50 System
.out
.println("Table Select " + totalTimeTaken
);
52 /*System.out.println("Table Update");
53 for(int i=0;i<noOfThreads;i++)
55 conth[i] = new connect(i,2,noOfRecords);
57 for(int i=0;i<noOfThreads;i++)
61 System.out.println("Table delete");
62 for(int i=0;i<noOfThreads;i++)
64 conth[i] = new connect(i,3,noOfRecords);
66 for(int i=0;i<noOfThreads;i++)
71 System
.out
.println("Drop Table ");
73 cStmt
.execute("DROP TABLE emp ;");
76 System
.out
.println("Exception in Test: "+e
);