本文整理汇总了Java中org.hsqldb.lib.StopWatch.elapsedTime方法的典型用法代码示例。如果您正苦于以下问题:Java StopWatch.elapsedTime方法的具体用法?Java StopWatch.elapsedTime怎么用?Java StopWatch.elapsedTime使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类org.hsqldb.lib.StopWatch
的用法示例。
在下文中一共展示了StopWatch.elapsedTime方法的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的Java代码示例。
示例1: countTestZip
import org.hsqldb.lib.StopWatch; //导入方法依赖的package包/类
private void countTestZip() {
try {
StopWatch sw = new StopWatch();
sStatement.execute("SELECT count(*) from TEST where zip > -1");
ResultSet rs = sStatement.getResultSet();
rs.next();
int time = (int) sw.elapsedTime();
int rate = (bigrows * 1000) / (time + 1);
storeResult("count (index on zip)", rs.getInt(1), time, rate);
System.out.println("count time (index on zip) " + rs.getInt(1)
+ " rows -- " + time + " ms -- " + rate
+ " tps");
} catch (SQLException e) {}
}
示例2: countTestZip
import org.hsqldb.lib.StopWatch; //导入方法依赖的package包/类
private void countTestZip() {
try {
StopWatch sw = new StopWatch();
sStatement.execute("SELECT count(*) from TEST where zip > -1");
ResultSet rs = sStatement.getResultSet();
rs.next();
long time = (long) sw.elapsedTime();
long rate = ((long) bigrows * 1000) / (time + 1);
storeResult("count (index on zip)", rs.getInt(1), time, rate);
System.out.println("count time (index on zip) " + rs.getInt(1)
+ " rows -- " + time + " ms -- " + rate
+ " tps");
} catch (SQLException e) {}
}
示例3: selectID
import org.hsqldb.lib.StopWatch; //导入方法依赖的package包/类
void selectID() {
StopWatch sw = new StopWatch();
java.util.Random randomgen = new java.util.Random();
int i = 0;
boolean slow = false;
try {
PreparedStatement ps = cConnection.prepareStatement(
"SELECT firstname,lastname,zip,filler FROM test WHERE id = ?");
for (i = 0; i < smallops; i++) {
ps.setInt(1, nextIntRandom(randomgen, bigrows - 1));
ps.execute();
if (reportProgress && (i + 1) % 10000 == 0
|| (slow && (i + 1) % 100 == 0)) {
System.out.println("Select " + (i + 1) + " : "
+ (sw.elapsedTime() + 1));
}
}
ps.close();
} catch (SQLException e) {
e.printStackTrace();
}
long time = sw.elapsedTime();
long rate = ((long) i * 1000) / (time + 1);
storeResult("select random id", i, time, rate);
System.out.println("select time for random id " + i + " rows -- "
+ time + " ms -- " + rate + " tps");
}
示例4: selectZipTable
import org.hsqldb.lib.StopWatch; //导入方法依赖的package包/类
void selectZipTable() {
StopWatch sw = new StopWatch();
java.util.Random randomgen = new java.util.Random();
int i = 0;
boolean slow = false;
try {
PreparedStatement ps = cConnection.prepareStatement(
"SELECT zip FROM zip WHERE zip = ?");
for (i = 0; i < bigops; i++) {
ps.setInt(1, nextIntRandom(randomgen, smallrows - 1));
ps.execute();
if (reportProgress && (i + 1) % 10000 == 0
|| (slow && (i + 1) % 100 == 0)) {
System.out.println("Select " + (i + 1) + " : "
+ (sw.elapsedTime() + 1));
}
}
ps.close();
} catch (SQLException e) {
e.printStackTrace();
}
long time = sw.elapsedTime();
long rate = ((long) i * 1000) / (time + 1);
storeResult("select random zip (zip table)", i, time, rate);
System.out.println("select time for random zip from zip table " + i
+ " rows -- " + time + " ms -- " + rate + " tps");
}
示例5: updateZip
import org.hsqldb.lib.StopWatch; //导入方法依赖的package包/类
private void updateZip() {
StopWatch sw = new StopWatch();
java.util.Random randomgen = new java.util.Random();
int i = 0;
boolean slow = false;
int count = 0;
int random = 0;
try {
PreparedStatement ps = cConnection.prepareStatement(
"UPDATE test SET filler = filler || zip WHERE zip = ?");
for (; i < smallrows; i++) {
random = nextIntRandom(randomgen, smallrows - 1);
ps.setInt(1, random);
count += ps.executeUpdate();
if (reportProgress && count % 10000 < 20) {
System.out.println("Update " + count + " : "
+ (sw.elapsedTime() + 1));
}
}
ps.close();
} catch (SQLException e) {
System.out.println("error : " + random);
e.printStackTrace();
}
long time = sw.elapsedTime();
long rate = (i * 1000) / (time + 1);
storeResult("update with random zip", i, time, rate);
System.out.println("update time with random zip " + i + " rows -- "
+ time + " ms -- " + rate + " tps");
}
示例6: selectID
import org.hsqldb.lib.StopWatch; //导入方法依赖的package包/类
void selectID() {
StopWatch sw = new StopWatch();
java.util.Random randomgen = new java.util.Random();
int i = 0;
boolean slow = false;
try {
PreparedStatement ps = cConnection.prepareStatement(
"SELECT firstname,lastname,zip,filler FROM test WHERE id = ?");
for (i = 0; i < bigops; i++) {
ps.setInt(1, nextIntRandom(randomgen, bigrows - 1));
ps.execute();
if (reportProgress && (i + 1) % 10000 == 0
|| (slow && (i + 1) % 100 == 0)) {
System.out.println("Select " + (i + 1) + " : "
+ (sw.elapsedTime() + 1));
}
}
} catch (SQLException e) {
e.printStackTrace();
}
int time = (int) sw.elapsedTime();
int rate = (i * 1000) / (time + 1);
storeResult("select random id", i, time, rate);
System.out.println("select time for random id " + i + " rows -- "
+ time + " ms -- " + rate + " tps");
}
示例7: main
import org.hsqldb.lib.StopWatch; //导入方法依赖的package包/类
public static void main(String argv[]) {
TestCacheSize test = new TestCacheSize();
HsqlProperties props = HsqlProperties.argArrayToProps(argv, "test");
test.bigops = props.getIntegerProperty("test.bigops", test.bigops);
test.bigrows = test.bigops;
test.smallops = test.bigops / 8;
test.cacheScale = props.getIntegerProperty("test.scale",
test.cacheScale);
test.logType = props.getProperty("test.logtype", test.logType);
test.tableType = props.getProperty("test.tabletype", test.tableType);
test.nioMode = props.isPropertyTrue("test.nio", test.nioMode);
if (props.getProperty("test.dbtype", "").equals("mem")) {
test.filepath = "mem:test";
test.filedb = false;
test.shutdown = false;
}
test.setUp();
StopWatch sw = new StopWatch();
test.testFillUp();
test.checkResults();
long time = sw.elapsedTime();
test.storeResult("total test time", 0, (int) time, 0);
System.out.println("total test time -- " + sw.elapsedTime() + " ms");
test.tearDown();
}
示例8: deleteTest
import org.hsqldb.lib.StopWatch; //导入方法依赖的package包/类
void deleteTest() {
StopWatch sw = new StopWatch();
java.util.Random randomgen = new java.util.Random();
int i = 0;
boolean slow = false;
int count = 0;
int random = 0;
try {
PreparedStatement ps =
cConnection.prepareStatement("DELETE FROM test WHERE id = ?");
for (i = 0; count < smallops; i++) {
random = nextIntRandom(randomgen, bigrows);
// random = i;
ps.setInt(1, random);
count += ps.executeUpdate();
if (reportProgress && (i + 1) % 10000 == 0
|| (slow && (i + 1) % 100 == 0)) {
System.out.println("delete " + (i + 1) + " : "
+ sw.elapsedTime() + " rps: "
+ (i * 1000 / (sw.elapsedTime() + 1)));
}
}
} catch (SQLException e) {
System.out.println("error : " + random);
e.printStackTrace();
}
int time = (int) sw.elapsedTime();
int rate = (count * 1000) / (time + 1);
storeResult("delete with random id", count, time, rate);
System.out.println("delete time for random id " + count
+ " rows -- " + time + " ms -- " + rate + " tps");
}
示例9: main
import org.hsqldb.lib.StopWatch; //导入方法依赖的package包/类
public static void main(String[] argv) {
TestCacheSize test = new TestCacheSize();
HsqlProperties props = HsqlProperties.argArrayToProps(argv, "test");
test.bigops = props.getIntegerProperty("test.bigops", test.bigops);
test.bigrows = test.bigops;
test.smallops = test.bigops / 8;
test.cacheScale = props.getIntegerProperty("test.scale",
test.cacheScale);
test.tableType = props.getProperty("test.tabletype", test.tableType);
test.nioMode = props.isPropertyTrue("test.nio", test.nioMode);
if (props.getProperty("test.dbtype", "").equals("mem")) {
test.filepath = "mem:test";
test.filedb = false;
test.shutdown = false;
}
test.setUp();
StopWatch sw = new StopWatch();
test.testFillUp();
test.checkResults();
long time = sw.elapsedTime();
test.storeResult("total test time", 0, (int) time, 0);
System.out.println("total test time -- " + sw.elapsedTime() + " ms");
test.tearDown();
}
示例10: selectZip
import org.hsqldb.lib.StopWatch; //导入方法依赖的package包/类
void selectZip() {
StopWatch sw = new StopWatch();
java.util.Random randomgen = new java.util.Random();
int i = 0;
boolean slow = false;
try {
PreparedStatement ps = cConnection.prepareStatement(
"SELECT TOP 1 firstname,lastname,zip,filler FROM test WHERE zip = ?");
for (; i < bigops; i++) {
ps.setInt(1, nextIntRandom(randomgen, smallrows));
ps.execute();
if ((i + 1) == 100 && sw.elapsedTime() > 50000) {
slow = true;
}
if (reportProgress && (i + 1) % 10000 == 0
|| (slow && (i + 1) % 100 == 0)) {
System.out.println("Select " + (i + 1) + " : "
+ sw.elapsedTime() + " rps: "
+ (i * 1000 / (sw.elapsedTime() + 1)));
}
}
} catch (SQLException e) {
e.printStackTrace();
}
long time = sw.elapsedTime();
long rate = ((long) i * 1000) / (time + 1);
storeResult("select random zip", i, time, rate);
System.out.println("select time for random zip " + i + " rows -- "
+ time + " ms -- " + rate + " tps");
}
示例11: updateID
import org.hsqldb.lib.StopWatch; //导入方法依赖的package包/类
void updateID() {
StopWatch sw = new StopWatch();
java.util.Random randomgen = new java.util.Random();
int i = 0;
boolean slow = false;
int count = 0;
int random = 0;
try {
PreparedStatement ps = cConnection.prepareStatement(
"UPDATE test SET zip = zip + 1 WHERE id = ? and zip <> "
+ smallrows);
for (i = 0; i < smallops; i++) {
random = nextIntRandom(randomgen, bigrows - 1);
ps.setInt(1, random);
ps.execute();
if (reportProgress && (i + 1) % 10000 == 0
|| (slow && (i + 1) % 100 == 0)) {
System.out.println("Update " + (i + 1) + " : "
+ sw.elapsedTime() + " rps: "
+ (i * 1000 / (sw.elapsedTime() + 1)));
}
}
ps.close();
} catch (SQLException e) {
System.out.println("error : " + random);
e.printStackTrace();
}
long time = sw.elapsedTime();
long rate = (i * 1000) / (time + 1);
storeResult("update with random id", i, time, rate);
System.out.println("update time with random id " + i + " rows -- "
+ time + " ms -- " + rate + " tps");
}
示例12: deleteTest
import org.hsqldb.lib.StopWatch; //导入方法依赖的package包/类
void deleteTest() {
StopWatch sw = new StopWatch();
java.util.Random randomgen = new java.util.Random();
int i = 0;
boolean slow = false;
int count = 0;
int random = 0;
try {
PreparedStatement ps =
cConnection.prepareStatement("DELETE FROM test WHERE id = ?");
for (i = 0; count < smallops; i++) {
random = nextIntRandom(randomgen, bigrows);
// random = i;
ps.setInt(1, random);
count += ps.executeUpdate();
/*
if ((i + 1) % 10000 == 0) {
Statement st = cConnection.createStatement();
st.execute("CHECKPOINT DEFRAG");
st.close();
}
*/
if (reportProgress && (i + 1) % 10000 == 0
|| (slow && (i + 1) % 100 == 0)) {
System.out.println("delete " + (i + 1) + " : "
+ sw.elapsedTime() + " rps: "
+ (i * 1000 / (sw.elapsedTime() + 1)));
}
}
ps.close();
} catch (SQLException e) {
System.out.println("error : " + random);
e.printStackTrace();
}
long time = sw.elapsedTime();
long rate = (count * 1000) / (time + 1);
storeResult("delete with random id", count, time, rate);
System.out.println("delete time for random id " + count + " rows -- "
+ time + " ms -- " + rate + " tps");
}
示例13: updateIDLinear
import org.hsqldb.lib.StopWatch; //导入方法依赖的package包/类
void updateIDLinear() {
StopWatch sw = new StopWatch();
java.util.Random randomgen = new java.util.Random();
int i = 0;
boolean slow = false;
int count = 0;
int random = 0;
try {
PreparedStatement ps = cConnection.prepareStatement(
"UPDATE test SET zip = zip + 1 WHERE id = ? and zip <> "
+ smallrows);
for (i = 0; i < bigops; i++) {
random = i;
ps.setInt(1, random);
ps.execute();
if (reportProgress && (i + 1) % 10000 == 0
|| (slow && (i + 1) % 100 == 0)) {
System.out.println("Update " + (i + 1) + " : "
+ sw.elapsedTime() + " rps: "
+ (i * 1000 / (sw.elapsedTime() + 1)));
}
}
ps.close();
} catch (SQLException e) {
System.out.println("error : " + random);
e.printStackTrace();
}
long time = sw.elapsedTime();
long rate = (i * 1000) / (time + 1);
storeResult("update with sequential id", i, time, rate);
System.out.println("update time with sequential id " + i
+ " rows -- " + time + " ms -- " + rate + " tps");
}
示例14: printCommandStats
import org.hsqldb.lib.StopWatch; //导入方法依赖的package包/类
static void printCommandStats(StopWatch sw, String cmd) {
long et = sw.elapsedTime();
print(sw.elapsedTimeToMessage(rows + " " + cmd));
println(" " + ((1000 * rows) / et) + " ops/s.");
}
示例15: printCommandStats
import org.hsqldb.lib.StopWatch; //导入方法依赖的package包/类
static void printCommandStats(StopWatch sw, String cmd, int count) {
long et = sw.elapsedTime();
print(sw.elapsedTimeToMessage(count + " " + cmd));
println(" " + ((1000 * count) / et) + " ops/s.");
}