1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
|
/*
Derby - Class org.apache.derbyTesting.functionTests.test.perf.StartupTest
Licensed to the Apache Software Foundation (ASF) under one
or more contributor license agreements. See the NOTICE file
distributed with this work for additional information
regarding copyright ownership. The ASF licenses this file
to you under the Apache License, Version 2.0 (the
"License"); you may not use this file except in compliance
with the License. You may obtain a copy of the License at
http://www.apache.org/licenses/LICENSE-2.0
Unless required by applicable law or agreed to in writing,
software distributed under the License is distributed on an
"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
KIND, either express or implied. See the License for the
specific language governing permissions and limitations
under the License.
*/
package org.apache.derbyTesting.functionTests.tests.perf;
import org.apache.derbyTesting.functionTests.util.JarUtil;
import org.apache.derbyTesting.junit.BaseJDBCTestCase;
import java.sql.*;
/**
* This test test the timing of starting up Derby. It tries to divide the
* total time up into reasonable chunks. It's written as a JUnit test but
* really can't be automated because the timings are so dependent upon
* the exact hardware, operating system and software environment the test
* is running in. I just use JUnit because of the convenient framework
* it gives me...
*/
public class StartupExistingDBTest extends BaseJDBCTestCase {
public StartupExistingDBTest(String name) {
super(name);
}
public void testExistingDB() throws Exception {
JarUtil.unjar("existingDb.jar", null);
long startTime = System.currentTimeMillis();
System.out.println("Testing startup with an EXISTING database... " +
"All measurements are in milliseconds.");
// Load the driver
Class driver = Class.forName("org.apache.derby.jdbc.EmbeddedDriver");
long currentTime = System.currentTimeMillis();
System.out.println("Loading driver: " + (currentTime - startTime));
// Use an existing DB. This is copied over by the harness
startTime = System.currentTimeMillis();
Connection conn =
DriverManager.getConnection("jdbc:derby:../existingDb");
currentTime = System.currentTimeMillis();
System.out.println("Open connection with existing database: "
+ (currentTime - startTime));
// Create a table
startTime = System.currentTimeMillis();
Statement stmt = conn.createStatement();
stmt.execute("CREATE TABLE test_table(id integer primary key, " +
"last_name varchar(80), first_name varchar(80), " +
"mi char(1), address varchar(100), city varchar(80))");
currentTime = System.currentTimeMillis();
System.out.println("Creating a table: "
+ (currentTime - startTime));
}
}
|
