public class org.hsqldb.test.TestCacheSize
minor version: 0
major version: 59
flags: flags: (0x0021) ACC_PUBLIC, ACC_SUPER
this_class: org.hsqldb.test.TestCacheSize
super_class: java.lang.Object
{
protected boolean filedb;
descriptor: Z
flags: (0x0004) ACC_PROTECTED
protected boolean shutdown;
descriptor: Z
flags: (0x0004) ACC_PROTECTED
protected java.lang.String url;
descriptor: Ljava/lang/String;
flags: (0x0004) ACC_PROTECTED
protected java.lang.String filepath;
descriptor: Ljava/lang/String;
flags: (0x0004) ACC_PROTECTED
boolean reportProgress;
descriptor: Z
flags: (0x0000)
java.lang.String tableType;
descriptor: Ljava/lang/String;
flags: (0x0000)
int cacheScale;
descriptor: I
flags: (0x0000)
int cacheSizeScale;
descriptor: I
flags: (0x0000)
boolean nioMode;
descriptor: Z
flags: (0x0000)
int writeDelay;
descriptor: I
flags: (0x0000)
boolean indexZip;
descriptor: Z
flags: (0x0000)
boolean indexLastName;
descriptor: Z
flags: (0x0000)
boolean addForeignKey;
descriptor: Z
flags: (0x0000)
boolean refIntegrity;
descriptor: Z
flags: (0x0000)
boolean createTempTable;
descriptor: Z
flags: (0x0000)
boolean deleteWhileInsert;
descriptor: Z
flags: (0x0000)
int deleteWhileInsertInterval;
descriptor: I
flags: (0x0000)
int bigrows;
descriptor: I
flags: (0x0000)
int bigops;
descriptor: I
flags: (0x0000)
int smallops;
descriptor: I
flags: (0x0000)
int smallrows;
descriptor: I
flags: (0x0000)
boolean multikeytable;
descriptor: Z
flags: (0x0000)
java.lang.String user;
descriptor: Ljava/lang/String;
flags: (0x0000)
java.lang.String password;
descriptor: Ljava/lang/String;
flags: (0x0000)
java.sql.Statement sStatement;
descriptor: Ljava/sql/Statement;
flags: (0x0000)
java.sql.Connection cConnection;
descriptor: Ljava/sql/Connection;
flags: (0x0000)
java.io.FileWriter writer;
descriptor: Ljava/io/FileWriter;
flags: (0x0000)
java.lang.String filler;
descriptor: Ljava/lang/String;
flags: (0x0000)
public void <init>();
descriptor: ()V
flags: (0x0001) ACC_PUBLIC
Code:
stack=2, locals=1, args_size=1
start local 0 0: aload 0
invokespecial java.lang.Object.<init>:()V
1: aload 0
iconst_1
putfield org.hsqldb.test.TestCacheSize.filedb:Z
2: aload 0
iconst_1
putfield org.hsqldb.test.TestCacheSize.shutdown:Z
3: aload 0
ldc "jdbc:hsqldb:"
putfield org.hsqldb.test.TestCacheSize.url:Ljava/lang/String;
4: aload 0
ldc "/hsql/testcache/test"
putfield org.hsqldb.test.TestCacheSize.filepath:Ljava/lang/String;
5: aload 0
iconst_1
putfield org.hsqldb.test.TestCacheSize.reportProgress:Z
6: aload 0
ldc "CACHED"
putfield org.hsqldb.test.TestCacheSize.tableType:Ljava/lang/String;
7: aload 0
bipush 14
putfield org.hsqldb.test.TestCacheSize.cacheScale:I
8: aload 0
bipush 10
putfield org.hsqldb.test.TestCacheSize.cacheSizeScale:I
9: aload 0
iconst_1
putfield org.hsqldb.test.TestCacheSize.nioMode:Z
10: aload 0
bipush 60
putfield org.hsqldb.test.TestCacheSize.writeDelay:I
11: aload 0
iconst_0
putfield org.hsqldb.test.TestCacheSize.indexZip:Z
12: aload 0
iconst_0
putfield org.hsqldb.test.TestCacheSize.indexLastName:Z
13: aload 0
iconst_0
putfield org.hsqldb.test.TestCacheSize.addForeignKey:Z
14: aload 0
iconst_1
putfield org.hsqldb.test.TestCacheSize.refIntegrity:Z
15: aload 0
iconst_0
putfield org.hsqldb.test.TestCacheSize.createTempTable:Z
16: aload 0
iconst_0
putfield org.hsqldb.test.TestCacheSize.deleteWhileInsert:Z
17: aload 0
sipush 10000
putfield org.hsqldb.test.TestCacheSize.deleteWhileInsertInterval:I
18: aload 0
ldc 1024000
putfield org.hsqldb.test.TestCacheSize.bigrows:I
19: aload 0
ldc 1024000
putfield org.hsqldb.test.TestCacheSize.bigops:I
20: aload 0
sipush 32000
putfield org.hsqldb.test.TestCacheSize.smallops:I
21: aload 0
sipush 4095
putfield org.hsqldb.test.TestCacheSize.smallrows:I
22: aload 0
iconst_0
putfield org.hsqldb.test.TestCacheSize.multikeytable:Z
23: aload 0
ldc "ABCDEFGHIJKLMNOPQRSTUVWXYZABCDEFGHIJKLMNOPQRSTUVWXYZABCDEFGHIJKLMNOPQRSTUVWXYZABCDEFGHIJKLMNOPQRSTUVWXYZ"
putfield org.hsqldb.test.TestCacheSize.filler:Ljava/lang/String;
24: return
end local 0 LocalVariableTable:
Start End Slot Name Signature
0 25 0 this Lorg/hsqldb/test/TestCacheSize;
private void checkSelects();
descriptor: ()V
flags: (0x0002) ACC_PRIVATE
Code:
stack=1, locals=1, args_size=1
start local 0 0: aload 0
invokevirtual org.hsqldb.test.TestCacheSize.countTestID:()V
1: aload 0
invokevirtual org.hsqldb.test.TestCacheSize.selectID:()V
2: return
end local 0 LocalVariableTable:
Start End Slot Name Signature
0 3 0 this Lorg/hsqldb/test/TestCacheSize;
private void checkUpdates();
descriptor: ()V
flags: (0x0002) ACC_PRIVATE
Code:
stack=1, locals=1, args_size=1
start local 0 0: aload 0
invokevirtual org.hsqldb.test.TestCacheSize.updateTestString:()V
1: aload 0
invokevirtual org.hsqldb.test.TestCacheSize.countTestID:()V
2: aload 0
invokevirtual org.hsqldb.test.TestCacheSize.deleteTest:()V
3: aload 0
invokevirtual org.hsqldb.test.TestCacheSize.countTestID:()V
4: aload 0
invokevirtual org.hsqldb.test.TestCacheSize.countZip:()V
5: return
end local 0 LocalVariableTable:
Start End Slot Name Signature
0 6 0 this Lorg/hsqldb/test/TestCacheSize;
protected void setUp();
descriptor: ()V
flags: (0x0004) ACC_PROTECTED
Code:
stack=7, locals=3, args_size=1
start local 0 0: aload 0
new java.io.FileWriter
dup
ldc "speedtests.html"
iconst_1
invokespecial java.io.FileWriter.<init>:(Ljava/lang/String;Z)V
putfield org.hsqldb.test.TestCacheSize.writer:Ljava/io/FileWriter;
1: aload 0
getfield org.hsqldb.test.TestCacheSize.writer:Ljava/io/FileWriter;
ldc "<table>\n"
invokevirtual java.io.FileWriter.write:(Ljava/lang/String;)V
2: aload 0
new java.util.Date
dup
invokespecial java.util.Date.<init>:()V
invokevirtual java.util.Date.toString:()Ljava/lang/String;
iconst_0
lconst_0
lconst_0
invokevirtual org.hsqldb.test.TestCacheSize.storeResult:(Ljava/lang/String;IJJ)V
3: aload 0
new java.lang.StringBuilder
dup
aload 0
getfield org.hsqldb.test.TestCacheSize.filepath:Ljava/lang/String;
invokestatic java.lang.String.valueOf:(Ljava/lang/Object;)Ljava/lang/String;
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
ldc " "
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
aload 0
getfield org.hsqldb.test.TestCacheSize.tableType:Ljava/lang/String;
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
ldc " "
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
aload 0
getfield org.hsqldb.test.TestCacheSize.nioMode:Z
invokevirtual java.lang.StringBuilder.append:(Z)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
4: aload 0
getfield org.hsqldb.test.TestCacheSize.cacheScale:I
lconst_0
lconst_0
5: invokevirtual org.hsqldb.test.TestCacheSize.storeResult:(Ljava/lang/String;IJJ)V
6: goto 8
StackMap locals:
StackMap stack: java.lang.Exception
7: pop
8: StackMap locals:
StackMap stack:
aload 0
ldc "sa"
putfield org.hsqldb.test.TestCacheSize.user:Ljava/lang/String;
9: aload 0
ldc ""
putfield org.hsqldb.test.TestCacheSize.password:Ljava/lang/String;
10: aload 0
aconst_null
putfield org.hsqldb.test.TestCacheSize.sStatement:Ljava/sql/Statement;
11: aload 0
aconst_null
putfield org.hsqldb.test.TestCacheSize.cConnection:Ljava/sql/Connection;
12: ldc "org.hsqldb.jdbc.JDBCDriver"
invokestatic java.lang.Class.forName:(Ljava/lang/String;)Ljava/lang/Class;
pop
13: aload 0
getfield org.hsqldb.test.TestCacheSize.filedb:Z
ifeq 34
14: aload 0
getfield org.hsqldb.test.TestCacheSize.filepath:Ljava/lang/String;
invokestatic org.hsqldb.test.TestCacheSize.deleteDatabase:(Ljava/lang/String;)V
15: aload 0
new java.lang.StringBuilder
dup
aload 0
getfield org.hsqldb.test.TestCacheSize.url:Ljava/lang/String;
invokestatic java.lang.String.valueOf:(Ljava/lang/Object;)Ljava/lang/String;
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
aload 0
getfield org.hsqldb.test.TestCacheSize.filepath:Ljava/lang/String;
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
16: aload 0
getfield org.hsqldb.test.TestCacheSize.user:Ljava/lang/String;
aload 0
getfield org.hsqldb.test.TestCacheSize.password:Ljava/lang/String;
17: invokestatic java.sql.DriverManager.getConnection:(Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)Ljava/sql/Connection;
putfield org.hsqldb.test.TestCacheSize.cConnection:Ljava/sql/Connection;
18: aload 0
aload 0
getfield org.hsqldb.test.TestCacheSize.cConnection:Ljava/sql/Connection;
invokeinterface java.sql.Connection.createStatement:()Ljava/sql/Statement;
putfield org.hsqldb.test.TestCacheSize.sStatement:Ljava/sql/Statement;
19: aload 0
getfield org.hsqldb.test.TestCacheSize.sStatement:Ljava/sql/Statement;
ldc "SET FILES DEFRAG 0"
invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
pop
20: aload 0
getfield org.hsqldb.test.TestCacheSize.sStatement:Ljava/sql/Statement;
ldc "SET FILES LOG SIZE 0"
invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
pop
21: aload 0
getfield org.hsqldb.test.TestCacheSize.sStatement:Ljava/sql/Statement;
ldc "SET DATABASE EVENT LOG LEVEL 1"
invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
pop
22: iconst_1
aload 0
getfield org.hsqldb.test.TestCacheSize.cacheScale:I
ishl
iconst_3
imul
istore 1
start local 1 23: iconst_1
aload 0
getfield org.hsqldb.test.TestCacheSize.cacheSizeScale:I
ishl
iload 1
imul
sipush 1024
idiv
istore 2
start local 2 24: aload 0
getfield org.hsqldb.test.TestCacheSize.sStatement:Ljava/sql/Statement;
new java.lang.StringBuilder
dup
ldc "SET FILES CACHE ROWS "
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
iload 1
invokevirtual java.lang.StringBuilder.append:(I)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
pop
25: aload 0
getfield org.hsqldb.test.TestCacheSize.sStatement:Ljava/sql/Statement;
new java.lang.StringBuilder
dup
ldc "SET FILES CACHE SIZE "
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
iload 2
invokevirtual java.lang.StringBuilder.append:(I)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
pop
26: aload 0
getfield org.hsqldb.test.TestCacheSize.sStatement:Ljava/sql/Statement;
new java.lang.StringBuilder
dup
ldc "SET FILES NIO "
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
aload 0
getfield org.hsqldb.test.TestCacheSize.nioMode:Z
invokevirtual java.lang.StringBuilder.append:(Z)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
pop
27: aload 0
getfield org.hsqldb.test.TestCacheSize.sStatement:Ljava/sql/Statement;
ldc "SET FILES BACKUP INCREMENT true"
invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
pop
28: aload 0
getfield org.hsqldb.test.TestCacheSize.sStatement:Ljava/sql/Statement;
ldc "SHUTDOWN"
invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
pop
29: aload 0
getfield org.hsqldb.test.TestCacheSize.cConnection:Ljava/sql/Connection;
invokeinterface java.sql.Connection.close:()V
end local 2 end local 1 30: goto 34
StackMap locals:
StackMap stack: java.lang.Exception
31: astore 1
start local 1 32: aload 1
invokevirtual java.lang.Exception.printStackTrace:()V
33: getstatic java.lang.System.out:Ljava/io/PrintStream;
new java.lang.StringBuilder
dup
ldc "TestSql.setUp() error: "
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
aload 1
invokevirtual java.lang.Exception.getMessage:()Ljava/lang/String;
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
end local 1 34: StackMap locals:
StackMap stack:
return
end local 0 LocalVariableTable:
Start End Slot Name Signature
0 35 0 this Lorg/hsqldb/test/TestCacheSize;
23 30 1 cacheRows I
24 30 2 cacheSize I
32 34 1 e Ljava/lang/Exception;
Exception table:
from to target type
0 6 7 Class java.lang.Exception
10 30 31 Class java.lang.Exception
public void testFillUp();
descriptor: ()V
flags: (0x0001) ACC_PUBLIC
Code:
stack=7, locals=16, args_size=1
start local 0 0: new org.hsqldb.lib.StopWatch
dup
invokespecial org.hsqldb.lib.StopWatch.<init>:()V
astore 1
start local 1 1: ldc "DROP TABLE test IF EXISTS"
astore 2
start local 2 2: ldc "CREATE TABLE zip( zip INT IDENTITY )"
astore 3
start local 3 3: new java.lang.StringBuilder
dup
ldc "CREATE "
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
aload 0
getfield org.hsqldb.test.TestCacheSize.tableType:Ljava/lang/String;
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
ldc " TABLE test( id INT IDENTITY,"
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
4: ldc " firstname VARCHAR(20), "
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
ldc " lastname VARCHAR(20), "
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
5: ldc " zip INTEGER, "
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
ldc " filler VARCHAR(300))"
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
6: invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
astore 4
start local 4 7: new java.lang.StringBuilder
dup
ldc "SET TABLE test SOURCE \"test.csv;cache_scale="
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
8: aload 0
getfield org.hsqldb.test.TestCacheSize.cacheScale:I
invokevirtual java.lang.StringBuilder.append:(I)Ljava/lang/StringBuilder;
ldc "\""
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
9: invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
astore 5
start local 5 10: ldc "CREATE INDEX idx1 ON TEST (lastname)"
astore 6
start local 6 11: ldc "CREATE INDEX idx2 ON TEST (zip)"
astore 7
start local 7 12: ldc "ALTER TABLE test add constraint c1 FOREIGN KEY (zip) REFERENCES zip(zip) ON DELETE CASCADE;"
13: astore 8
start local 8 14: ldc "CREATE TEMP TABLE temptest( id INT, firstname VARCHAR, lastname VARCHAR, zip INTEGER, filler VARCHAR)"
astore 9
start local 9 15: ldc "DROP TABLE test2 IF EXISTS"
astore 10
start local 10 16: new java.lang.StringBuilder
dup
ldc "CREATE "
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
aload 0
getfield org.hsqldb.test.TestCacheSize.tableType:Ljava/lang/String;
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
17: ldc " TABLE test2( id1 INT, id2 INT,"
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
18: ldc " firstname VARCHAR, "
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
ldc " lastname VARCHAR, "
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
19: ldc " zip INTEGER, "
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
ldc " filler VARCHAR, "
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
20: ldc " PRIMARY KEY (id1,id2) )"
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
21: invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
astore 11
start local 11 22: new java.lang.StringBuilder
dup
ldc "SET TABLE test2 SOURCE \"test2.csv;cache_scale="
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
23: aload 0
getfield org.hsqldb.test.TestCacheSize.cacheScale:I
invokevirtual java.lang.StringBuilder.append:(I)Ljava/lang/StringBuilder;
ldc "\""
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
24: invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
astore 12
start local 12 25: aload 1
invokevirtual org.hsqldb.lib.StopWatch.zero:()V
26: aload 0
aconst_null
putfield org.hsqldb.test.TestCacheSize.cConnection:Ljava/sql/Connection;
27: aload 0
aconst_null
putfield org.hsqldb.test.TestCacheSize.sStatement:Ljava/sql/Statement;
28: aload 0
new java.lang.StringBuilder
dup
aload 0
getfield org.hsqldb.test.TestCacheSize.url:Ljava/lang/String;
invokestatic java.lang.String.valueOf:(Ljava/lang/Object;)Ljava/lang/String;
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
aload 0
getfield org.hsqldb.test.TestCacheSize.filepath:Ljava/lang/String;
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
aload 0
getfield org.hsqldb.test.TestCacheSize.user:Ljava/lang/String;
29: aload 0
getfield org.hsqldb.test.TestCacheSize.password:Ljava/lang/String;
30: invokestatic java.sql.DriverManager.getConnection:(Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)Ljava/sql/Connection;
putfield org.hsqldb.test.TestCacheSize.cConnection:Ljava/sql/Connection;
31: getstatic java.lang.System.out:Ljava/io/PrintStream;
new java.lang.StringBuilder
dup
ldc "connection time -- "
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
aload 1
invokevirtual org.hsqldb.lib.StopWatch.elapsedTime:()J
invokevirtual java.lang.StringBuilder.append:(J)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
32: aload 1
invokevirtual org.hsqldb.lib.StopWatch.zero:()V
33: aload 0
aload 0
getfield org.hsqldb.test.TestCacheSize.cConnection:Ljava/sql/Connection;
invokeinterface java.sql.Connection.createStatement:()Ljava/sql/Statement;
putfield org.hsqldb.test.TestCacheSize.sStatement:Ljava/sql/Statement;
34: new java.util.Random
dup
invokespecial java.util.Random.<init>:()V
astore 13
start local 13 35: aload 0
getfield org.hsqldb.test.TestCacheSize.sStatement:Ljava/sql/Statement;
aload 2
invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
pop
36: aload 0
getfield org.hsqldb.test.TestCacheSize.sStatement:Ljava/sql/Statement;
aload 3
invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
pop
37: aload 0
getfield org.hsqldb.test.TestCacheSize.sStatement:Ljava/sql/Statement;
aload 4
invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
pop
38: aload 0
getfield org.hsqldb.test.TestCacheSize.tableType:Ljava/lang/String;
ldc "TEXT"
invokevirtual java.lang.String.equals:(Ljava/lang/Object;)Z
ifeq 40
39: aload 0
getfield org.hsqldb.test.TestCacheSize.sStatement:Ljava/sql/Statement;
aload 5
invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
pop
40: StackMap locals: org.hsqldb.test.TestCacheSize org.hsqldb.lib.StopWatch java.lang.String java.lang.String java.lang.String java.lang.String java.lang.String java.lang.String java.lang.String java.lang.String java.lang.String java.lang.String java.lang.String java.util.Random
StackMap stack:
aload 0
getfield org.hsqldb.test.TestCacheSize.indexLastName:Z
ifeq 43
41: aload 0
getfield org.hsqldb.test.TestCacheSize.sStatement:Ljava/sql/Statement;
aload 6
invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
pop
42: getstatic java.lang.System.out:Ljava/io/PrintStream;
ldc "created index on lastname"
invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
43: StackMap locals:
StackMap stack:
aload 0
getfield org.hsqldb.test.TestCacheSize.indexZip:Z
ifeq 46
44: aload 0
getfield org.hsqldb.test.TestCacheSize.sStatement:Ljava/sql/Statement;
aload 7
invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
pop
45: getstatic java.lang.System.out:Ljava/io/PrintStream;
ldc "created index on zip"
invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
46: StackMap locals:
StackMap stack:
aload 0
getfield org.hsqldb.test.TestCacheSize.addForeignKey:Z
ifeq 49
47: aload 0
getfield org.hsqldb.test.TestCacheSize.sStatement:Ljava/sql/Statement;
aload 8
invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
pop
48: getstatic java.lang.System.out:Ljava/io/PrintStream;
ldc "added foreign key"
invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
49: StackMap locals:
StackMap stack:
aload 0
getfield org.hsqldb.test.TestCacheSize.createTempTable:Z
ifeq 52
50: aload 0
getfield org.hsqldb.test.TestCacheSize.sStatement:Ljava/sql/Statement;
aload 9
invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
pop
51: getstatic java.lang.System.out:Ljava/io/PrintStream;
ldc "created temp table"
invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
52: StackMap locals:
StackMap stack:
aload 0
getfield org.hsqldb.test.TestCacheSize.multikeytable:Z
ifeq 58
53: aload 0
getfield org.hsqldb.test.TestCacheSize.sStatement:Ljava/sql/Statement;
aload 10
invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
pop
54: aload 0
getfield org.hsqldb.test.TestCacheSize.sStatement:Ljava/sql/Statement;
aload 11
invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
pop
55: aload 0
getfield org.hsqldb.test.TestCacheSize.tableType:Ljava/lang/String;
ldc "TEXT"
invokevirtual java.lang.String.equals:(Ljava/lang/Object;)Z
ifeq 57
56: aload 0
getfield org.hsqldb.test.TestCacheSize.sStatement:Ljava/sql/Statement;
aload 12
invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
pop
57: StackMap locals:
StackMap stack:
getstatic java.lang.System.out:Ljava/io/PrintStream;
ldc "created multi key table"
invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
58: StackMap locals:
StackMap stack:
getstatic java.lang.System.out:Ljava/io/PrintStream;
new java.lang.StringBuilder
dup
ldc "complete setup time -- "
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
aload 1
invokevirtual org.hsqldb.lib.StopWatch.elapsedTime:()J
invokevirtual java.lang.StringBuilder.append:(J)Ljava/lang/StringBuilder;
59: ldc " ms"
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
60: invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
61: aload 0
aload 0
getfield org.hsqldb.test.TestCacheSize.filler:Ljava/lang/String;
aload 13
invokevirtual org.hsqldb.test.TestCacheSize.fillUpBigTable:(Ljava/lang/String;Ljava/util/Random;)V
62: aload 0
getfield org.hsqldb.test.TestCacheSize.multikeytable:Z
ifeq 64
63: aload 0
aload 0
getfield org.hsqldb.test.TestCacheSize.filler:Ljava/lang/String;
aload 13
invokevirtual org.hsqldb.test.TestCacheSize.fillUpMultiTable:(Ljava/lang/String;Ljava/util/Random;)V
64: StackMap locals:
StackMap stack:
aload 1
invokevirtual org.hsqldb.lib.StopWatch.zero:()V
65: aload 0
getfield org.hsqldb.test.TestCacheSize.shutdown:Z
ifeq 70
66: aload 0
getfield org.hsqldb.test.TestCacheSize.sStatement:Ljava/sql/Statement;
ldc "SHUTDOWN"
invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
pop
67: aload 1
invokevirtual org.hsqldb.lib.StopWatch.elapsedTime:()J
lstore 14
start local 14 68: aload 0
ldc "shutdown"
iconst_0
lload 14
lconst_0
invokevirtual org.hsqldb.test.TestCacheSize.storeResult:(Ljava/lang/String;IJJ)V
69: getstatic java.lang.System.out:Ljava/io/PrintStream;
new java.lang.StringBuilder
dup
ldc "shutdown time -- "
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
lload 14
invokevirtual java.lang.StringBuilder.append:(J)Ljava/lang/StringBuilder;
ldc " ms"
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
end local 14 70: StackMap locals:
StackMap stack:
aload 0
getfield org.hsqldb.test.TestCacheSize.cConnection:Ljava/sql/Connection;
invokeinterface java.sql.Connection.close:()V
end local 13 71: goto 74
StackMap locals: org.hsqldb.test.TestCacheSize org.hsqldb.lib.StopWatch java.lang.String java.lang.String java.lang.String java.lang.String java.lang.String java.lang.String java.lang.String java.lang.String java.lang.String java.lang.String java.lang.String
StackMap stack: java.sql.SQLException
72: astore 13
start local 13 73: getstatic java.lang.System.out:Ljava/io/PrintStream;
aload 13
invokevirtual java.sql.SQLException.getMessage:()Ljava/lang/String;
invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
end local 13 74: StackMap locals:
StackMap stack:
return
end local 12 end local 11 end local 10 end local 9 end local 8 end local 7 end local 6 end local 5 end local 4 end local 3 end local 2 end local 1 end local 0 LocalVariableTable:
Start End Slot Name Signature
0 75 0 this Lorg/hsqldb/test/TestCacheSize;
1 75 1 sw Lorg/hsqldb/lib/StopWatch;
2 75 2 ddl1 Ljava/lang/String;
3 75 3 ddl2 Ljava/lang/String;
7 75 4 ddl3 Ljava/lang/String;
10 75 5 ddl31 Ljava/lang/String;
11 75 6 ddl4 Ljava/lang/String;
12 75 7 ddl5 Ljava/lang/String;
14 75 8 ddl6 Ljava/lang/String;
15 75 9 ddl7 Ljava/lang/String;
16 75 10 mddl1 Ljava/lang/String;
22 75 11 mddl2 Ljava/lang/String;
25 75 12 mdd13 Ljava/lang/String;
35 71 13 randomgen Ljava/util/Random;
68 70 14 time J
73 74 13 e Ljava/sql/SQLException;
Exception table:
from to target type
25 71 72 Class java.sql.SQLException
private void fillUpBigTable(java.lang.String, java.util.Random);
descriptor: (Ljava/lang/String;Ljava/util/Random;)V
flags: (0x0002) ACC_PRIVATE
Code:
stack=7, locals=10, args_size=3
start local 0 start local 1 start local 2 0: new org.hsqldb.lib.StopWatch
dup
invokespecial org.hsqldb.lib.StopWatch.<init>:()V
astore 3
start local 3 1: aload 0
getfield org.hsqldb.test.TestCacheSize.cConnection:Ljava/sql/Connection;
ldc "INSERT INTO zip VALUES(?)"
invokeinterface java.sql.Connection.prepareStatement:(Ljava/lang/String;)Ljava/sql/PreparedStatement;
2: astore 5
start local 5 3: iconst_0
istore 4
start local 4 4: goto 8
5: StackMap locals: org.hsqldb.lib.StopWatch int java.sql.PreparedStatement
StackMap stack:
aload 5
iconst_1
iload 4
invokeinterface java.sql.PreparedStatement.setInt:(II)V
6: aload 5
invokeinterface java.sql.PreparedStatement.execute:()Z
pop
7: iinc 4 1
StackMap locals:
StackMap stack:
8: iload 4
aload 0
getfield org.hsqldb.test.TestCacheSize.smallrows:I
if_icmple 5
9: aload 5
invokeinterface java.sql.PreparedStatement.close:()V
10: aload 0
getfield org.hsqldb.test.TestCacheSize.sStatement:Ljava/sql/Statement;
new java.lang.StringBuilder
dup
ldc "SET DATABASE REFERENTIAL INTEGRITY "
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
11: aload 0
getfield org.hsqldb.test.TestCacheSize.refIntegrity:Z
invokevirtual java.lang.StringBuilder.append:(Z)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
12: invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
pop
13: aload 0
getfield org.hsqldb.test.TestCacheSize.cConnection:Ljava/sql/Connection;
14: ldc "INSERT INTO test (firstname,lastname,zip,filler) VALUES (?,?,?,?)"
15: invokeinterface java.sql.Connection.prepareStatement:(Ljava/lang/String;)Ljava/sql/PreparedStatement;
astore 5
16: aload 5
iconst_1
ldc "Julia"
invokeinterface java.sql.PreparedStatement.setString:(ILjava/lang/String;)V
17: aload 5
iconst_2
ldc "Clancy"
invokeinterface java.sql.PreparedStatement.setString:(ILjava/lang/String;)V
18: iconst_0
istore 4
goto 48
19: StackMap locals:
StackMap stack:
aload 5
iconst_3
aload 0
aload 2
aload 0
getfield org.hsqldb.test.TestCacheSize.smallrows:I
invokevirtual org.hsqldb.test.TestCacheSize.nextIntRandom:(Ljava/util/Random;I)I
invokeinterface java.sql.PreparedStatement.setInt:(II)V
20: aload 2
invokevirtual java.util.Random.nextLong:()J
lstore 6
start local 6 21: lload 6
l2i
bipush 127
iand
istore 8
start local 8 22: iload 8
aload 1
invokevirtual java.lang.String.length:()I
if_icmple 24
23: aload 1
invokevirtual java.lang.String.length:()I
istore 8
24: StackMap locals: long int
StackMap stack:
aload 1
iconst_0
iload 8
invokevirtual java.lang.String.substring:(II)Ljava/lang/String;
astore 9
start local 9 25: aload 5
iconst_4
new java.lang.StringBuilder
dup
lload 6
invokestatic java.lang.String.valueOf:(J)Ljava/lang/String;
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
aload 9
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
invokeinterface java.sql.PreparedStatement.setString:(ILjava/lang/String;)V
end local 9 end local 8 end local 6 26: aload 5
invokeinterface java.sql.PreparedStatement.execute:()Z
pop
27: aload 0
getfield org.hsqldb.test.TestCacheSize.reportProgress:Z
ifeq 31
iload 4
iconst_1
iadd
sipush 10000
irem
ifne 31
28: getstatic java.lang.System.out:Ljava/io/PrintStream;
new java.lang.StringBuilder
dup
ldc "insert "
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
iload 4
iconst_1
iadd
invokevirtual java.lang.StringBuilder.append:(I)Ljava/lang/StringBuilder;
ldc " : "
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
29: aload 3
invokevirtual org.hsqldb.lib.StopWatch.elapsedTime:()J
invokevirtual java.lang.StringBuilder.append:(J)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
30: invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
31: StackMap locals:
StackMap stack:
aload 0
getfield org.hsqldb.test.TestCacheSize.deleteWhileInsert:Z
ifeq 47
iload 4
ifeq 47
32: iload 4
aload 0
getfield org.hsqldb.test.TestCacheSize.deleteWhileInsertInterval:I
irem
ifne 47
33: aload 0
getfield org.hsqldb.test.TestCacheSize.sStatement:Ljava/sql/Statement;
ldc "CALL IDENTITY();"
invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
pop
34: aload 0
getfield org.hsqldb.test.TestCacheSize.sStatement:Ljava/sql/Statement;
invokeinterface java.sql.Statement.getResultSet:()Ljava/sql/ResultSet;
astore 6
start local 6 35: aload 6
invokeinterface java.sql.ResultSet.next:()Z
pop
36: aload 6
iconst_1
invokeinterface java.sql.ResultSet.getInt:(I)I
istore 7
start local 7 37: aload 0
getfield org.hsqldb.test.TestCacheSize.sStatement:Ljava/sql/Statement;
38: new java.lang.StringBuilder
dup
ldc "SELECT * INTO TEMP tempt FROM test WHERE id > "
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
39: iload 7
sipush 4000
isub
invokevirtual java.lang.StringBuilder.append:(I)Ljava/lang/StringBuilder;
40: invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
41: invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
pop
42: aload 0
getfield org.hsqldb.test.TestCacheSize.sStatement:Ljava/sql/Statement;
new java.lang.StringBuilder
dup
ldc "DELETE FROM test WHERE id > "
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
43: iload 7
sipush 4000
isub
invokevirtual java.lang.StringBuilder.append:(I)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
44: invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
pop
45: aload 0
getfield org.hsqldb.test.TestCacheSize.sStatement:Ljava/sql/Statement;
ldc "INSERT INTO test SELECT * FROM tempt"
invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
pop
46: aload 0
getfield org.hsqldb.test.TestCacheSize.sStatement:Ljava/sql/Statement;
ldc "DROP TABLE tempt"
invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
pop
end local 7 end local 6 47: StackMap locals:
StackMap stack:
iinc 4 1
StackMap locals:
StackMap stack:
48: iload 4
aload 0
getfield org.hsqldb.test.TestCacheSize.bigrows:I
if_icmplt 19
49: aload 5
invokeinterface java.sql.PreparedStatement.close:()V
50: aload 3
invokevirtual org.hsqldb.lib.StopWatch.elapsedTime:()J
lstore 6
start local 6 51: iload 4
i2l
ldc 1000
lmul
lload 6
lconst_1
ladd
ldiv
lstore 8
start local 8 52: aload 0
ldc "insert"
iload 4
lload 6
lload 8
invokevirtual org.hsqldb.test.TestCacheSize.storeResult:(Ljava/lang/String;IJJ)V
53: getstatic java.lang.System.out:Ljava/io/PrintStream;
new java.lang.StringBuilder
dup
ldc "insert time for "
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
iload 4
invokevirtual java.lang.StringBuilder.append:(I)Ljava/lang/StringBuilder;
ldc " rows -- "
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
lload 6
invokevirtual java.lang.StringBuilder.append:(J)Ljava/lang/StringBuilder;
54: ldc " ms -- "
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
lload 8
invokevirtual java.lang.StringBuilder.append:(J)Ljava/lang/StringBuilder;
ldc " tps"
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
55: invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
56: return
end local 8 end local 6 end local 5 end local 4 end local 3 end local 2 end local 1 end local 0 LocalVariableTable:
Start End Slot Name Signature
0 57 0 this Lorg/hsqldb/test/TestCacheSize;
0 57 1 filler Ljava/lang/String;
0 57 2 randomgen Ljava/util/Random;
1 57 3 sw Lorg/hsqldb/lib/StopWatch;
4 57 4 i I
3 57 5 ps Ljava/sql/PreparedStatement;
21 26 6 nextrandom J
22 26 8 randomlength I
25 26 9 varfiller Ljava/lang/String;
35 47 6 rs Ljava/sql/ResultSet;
37 47 7 lastId I
51 57 6 time J
52 57 8 rate J
Exceptions:
throws java.sql.SQLException
MethodParameters:
Name Flags
filler
randomgen
private void fillUpMultiTable(java.lang.String, java.util.Random);
descriptor: (Ljava/lang/String;Ljava/util/Random;)V
flags: (0x0002) ACC_PRIVATE
Code:
stack=8, locals=13, args_size=3
start local 0 start local 1 start local 2 0: new org.hsqldb.lib.StopWatch
dup
invokespecial org.hsqldb.lib.StopWatch.<init>:()V
astore 3
start local 3 1: aload 0
getfield org.hsqldb.test.TestCacheSize.cConnection:Ljava/sql/Connection;
2: ldc "INSERT INTO test2 (id1, id2, firstname,lastname,zip,filler) VALUES (?,?,?,?,?,?)"
3: invokeinterface java.sql.Connection.prepareStatement:(Ljava/lang/String;)Ljava/sql/PreparedStatement;
astore 5
start local 5 4: aload 5
iconst_3
ldc "Julia"
invokeinterface java.sql.PreparedStatement.setString:(ILjava/lang/String;)V
5: aload 5
iconst_4
ldc "Clancy"
invokeinterface java.sql.PreparedStatement.setString:(ILjava/lang/String;)V
6: iconst_0
istore 6
start local 6 7: iconst_0
istore 4
start local 4 8: goto 30
9: StackMap locals: org.hsqldb.test.TestCacheSize java.lang.String java.util.Random org.hsqldb.lib.StopWatch int java.sql.PreparedStatement int
StackMap stack:
aload 0
aload 2
ldc 2147483647
invokevirtual org.hsqldb.test.TestCacheSize.nextIntRandom:(Ljava/util/Random;I)I
istore 7
start local 7 10: iload 4
sipush 1000
irem
ifne 12
11: aload 0
aload 2
ldc 2147483647
invokevirtual org.hsqldb.test.TestCacheSize.nextIntRandom:(Ljava/util/Random;I)I
istore 6
12: StackMap locals: int
StackMap stack:
aload 5
iconst_1
iload 6
invokeinterface java.sql.PreparedStatement.setInt:(II)V
13: aload 5
iconst_2
iload 7
invokeinterface java.sql.PreparedStatement.setInt:(II)V
14: aload 5
iconst_5
aload 0
aload 2
aload 0
getfield org.hsqldb.test.TestCacheSize.smallrows:I
invokevirtual org.hsqldb.test.TestCacheSize.nextIntRandom:(Ljava/util/Random;I)I
invokeinterface java.sql.PreparedStatement.setInt:(II)V
15: aload 2
invokevirtual java.util.Random.nextLong:()J
lstore 8
start local 8 16: lload 8
l2i
bipush 127
iand
istore 10
start local 10 17: iload 10
aload 1
invokevirtual java.lang.String.length:()I
if_icmple 19
18: aload 1
invokevirtual java.lang.String.length:()I
istore 10
19: StackMap locals: long int
StackMap stack:
aload 1
iconst_0
iload 10
invokevirtual java.lang.String.substring:(II)Ljava/lang/String;
astore 11
start local 11 20: aload 5
bipush 6
new java.lang.StringBuilder
dup
lload 8
invokestatic java.lang.String.valueOf:(J)Ljava/lang/String;
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
aload 11
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
invokeinterface java.sql.PreparedStatement.setString:(ILjava/lang/String;)V
21: aload 5
invokeinterface java.sql.PreparedStatement.execute:()Z
pop
22: goto 25
StackMap locals: org.hsqldb.test.TestCacheSize java.lang.String java.util.Random org.hsqldb.lib.StopWatch int java.sql.PreparedStatement int int long int java.lang.String
StackMap stack: java.sql.SQLException
23: astore 12
start local 12 24: aload 12
invokevirtual java.sql.SQLException.printStackTrace:()V
end local 12 25: StackMap locals:
StackMap stack:
aload 0
getfield org.hsqldb.test.TestCacheSize.reportProgress:Z
ifeq 29
iload 4
iconst_1
iadd
sipush 10000
irem
ifne 29
26: getstatic java.lang.System.out:Ljava/io/PrintStream;
new java.lang.StringBuilder
dup
ldc "insert "
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
iload 4
iconst_1
iadd
invokevirtual java.lang.StringBuilder.append:(I)Ljava/lang/StringBuilder;
ldc " : "
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
27: aload 3
invokevirtual org.hsqldb.lib.StopWatch.elapsedTime:()J
invokevirtual java.lang.StringBuilder.append:(J)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
28: invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
end local 11 end local 10 end local 8 end local 7 29: StackMap locals: org.hsqldb.test.TestCacheSize java.lang.String java.util.Random org.hsqldb.lib.StopWatch int java.sql.PreparedStatement int
StackMap stack:
iinc 4 1
StackMap locals:
StackMap stack:
30: iload 4
aload 0
getfield org.hsqldb.test.TestCacheSize.bigrows:I
if_icmplt 9
31: aload 5
invokeinterface java.sql.PreparedStatement.close:()V
32: getstatic java.lang.System.out:Ljava/io/PrintStream;
new java.lang.StringBuilder
dup
ldc "total multi key rows inserted: "
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
iload 4
invokevirtual java.lang.StringBuilder.append:(I)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
33: getstatic java.lang.System.out:Ljava/io/PrintStream;
new java.lang.StringBuilder
dup
ldc "insert time: "
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
aload 3
invokevirtual org.hsqldb.lib.StopWatch.elapsedTime:()J
invokevirtual java.lang.StringBuilder.append:(J)Ljava/lang/StringBuilder;
ldc " rps: "
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
34: iload 4
sipush 1000
imul
i2l
aload 3
invokevirtual org.hsqldb.lib.StopWatch.elapsedTime:()J
lconst_1
ladd
ldiv
invokevirtual java.lang.StringBuilder.append:(J)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
35: invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
36: return
end local 6 end local 5 end local 4 end local 3 end local 2 end local 1 end local 0 LocalVariableTable:
Start End Slot Name Signature
0 37 0 this Lorg/hsqldb/test/TestCacheSize;
0 37 1 filler Ljava/lang/String;
0 37 2 randomgen Ljava/util/Random;
1 37 3 sw Lorg/hsqldb/lib/StopWatch;
8 37 4 i I
4 37 5 ps Ljava/sql/PreparedStatement;
7 37 6 id1 I
10 29 7 id2 I
16 29 8 nextrandom J
17 29 10 randomlength I
20 29 11 varfiller Ljava/lang/String;
24 25 12 e Ljava/sql/SQLException;
Exception table:
from to target type
21 22 23 Class java.sql.SQLException
Exceptions:
throws java.sql.SQLException
MethodParameters:
Name Flags
filler
randomgen
protected void tearDown();
descriptor: ()V
flags: (0x0004) ACC_PROTECTED
Code:
stack=2, locals=1, args_size=1
start local 0 0: aload 0
getfield org.hsqldb.test.TestCacheSize.writer:Ljava/io/FileWriter;
ldc "\n</table>\n"
invokevirtual java.io.FileWriter.write:(Ljava/lang/String;)V
1: aload 0
getfield org.hsqldb.test.TestCacheSize.writer:Ljava/io/FileWriter;
invokevirtual java.io.FileWriter.close:()V
2: goto 4
StackMap locals:
StackMap stack: java.lang.Exception
3: pop
4: StackMap locals:
StackMap stack:
return
end local 0 LocalVariableTable:
Start End Slot Name Signature
0 5 0 this Lorg/hsqldb/test/TestCacheSize;
Exception table:
from to target type
0 2 3 Class java.lang.Exception
protected void checkResults();
descriptor: ()V
flags: (0x0004) ACC_PROTECTED
Code:
stack=7, locals=4, args_size=1
start local 0 0: new org.hsqldb.lib.StopWatch
dup
invokespecial org.hsqldb.lib.StopWatch.<init>:()V
astore 1
start local 1 1: aload 0
new java.lang.StringBuilder
dup
aload 0
getfield org.hsqldb.test.TestCacheSize.url:Ljava/lang/String;
invokestatic java.lang.String.valueOf:(Ljava/lang/Object;)Ljava/lang/String;
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
aload 0
getfield org.hsqldb.test.TestCacheSize.filepath:Ljava/lang/String;
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
aload 0
getfield org.hsqldb.test.TestCacheSize.user:Ljava/lang/String;
2: aload 0
getfield org.hsqldb.test.TestCacheSize.password:Ljava/lang/String;
3: invokestatic java.sql.DriverManager.getConnection:(Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)Ljava/sql/Connection;
putfield org.hsqldb.test.TestCacheSize.cConnection:Ljava/sql/Connection;
4: aload 1
invokevirtual org.hsqldb.lib.StopWatch.elapsedTime:()J
lstore 2
start local 2 5: aload 0
ldc "reopen"
iconst_0
lload 2
lconst_0
invokevirtual org.hsqldb.test.TestCacheSize.storeResult:(Ljava/lang/String;IJJ)V
6: getstatic java.lang.System.out:Ljava/io/PrintStream;
new java.lang.StringBuilder
dup
ldc "database reopen time -- "
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
lload 2
invokevirtual java.lang.StringBuilder.append:(J)Ljava/lang/StringBuilder;
ldc " ms"
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
7: aload 1
invokevirtual org.hsqldb.lib.StopWatch.zero:()V
8: aload 0
aload 0
getfield org.hsqldb.test.TestCacheSize.cConnection:Ljava/sql/Connection;
invokeinterface java.sql.Connection.createStatement:()Ljava/sql/Statement;
putfield org.hsqldb.test.TestCacheSize.sStatement:Ljava/sql/Statement;
9: aload 0
invokevirtual org.hsqldb.test.TestCacheSize.checkSelects:()V
10: aload 0
invokevirtual org.hsqldb.test.TestCacheSize.checkUpdates:()V
11: aload 1
invokevirtual org.hsqldb.lib.StopWatch.zero:()V
12: aload 0
getfield org.hsqldb.test.TestCacheSize.shutdown:Z
ifeq 17
13: aload 0
getfield org.hsqldb.test.TestCacheSize.sStatement:Ljava/sql/Statement;
ldc "SHUTDOWN"
invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
pop
14: aload 1
invokevirtual org.hsqldb.lib.StopWatch.elapsedTime:()J
lstore 2
15: aload 0
ldc "shutdown"
iconst_0
lload 2
lconst_0
invokevirtual org.hsqldb.test.TestCacheSize.storeResult:(Ljava/lang/String;IJJ)V
16: getstatic java.lang.System.out:Ljava/io/PrintStream;
new java.lang.StringBuilder
dup
ldc "shutdown time -- "
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
lload 2
invokevirtual java.lang.StringBuilder.append:(J)Ljava/lang/StringBuilder;
ldc " ms"
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
17: StackMap locals: org.hsqldb.lib.StopWatch long
StackMap stack:
aload 0
getfield org.hsqldb.test.TestCacheSize.cConnection:Ljava/sql/Connection;
invokeinterface java.sql.Connection.close:()V
end local 2 end local 1 18: goto 21
StackMap locals: org.hsqldb.test.TestCacheSize
StackMap stack: java.sql.SQLException
19: astore 1
start local 1 20: aload 1
invokevirtual java.sql.SQLException.printStackTrace:()V
end local 1 21: StackMap locals:
StackMap stack:
return
end local 0 LocalVariableTable:
Start End Slot Name Signature
0 22 0 this Lorg/hsqldb/test/TestCacheSize;
1 18 1 sw Lorg/hsqldb/lib/StopWatch;
5 18 2 time J
20 21 1 e Ljava/sql/SQLException;
Exception table:
from to target type
0 18 19 Class java.sql.SQLException
void selectZip();
descriptor: ()V
flags: (0x0000)
Code:
stack=8, locals=9, args_size=1
start local 0 0: new org.hsqldb.lib.StopWatch
dup
invokespecial org.hsqldb.lib.StopWatch.<init>:()V
astore 1
start local 1 1: new java.util.Random
dup
invokespecial java.util.Random.<init>:()V
astore 2
start local 2 2: iconst_0
istore 3
start local 3 3: iconst_0
istore 4
start local 4 4: aload 0
getfield org.hsqldb.test.TestCacheSize.cConnection:Ljava/sql/Connection;
5: ldc "SELECT TOP 1 firstname,lastname,zip,filler FROM test WHERE zip = ?"
6: invokeinterface java.sql.Connection.prepareStatement:(Ljava/lang/String;)Ljava/sql/PreparedStatement;
astore 5
start local 5 7: goto 19
8: StackMap locals: org.hsqldb.test.TestCacheSize org.hsqldb.lib.StopWatch java.util.Random int int java.sql.PreparedStatement
StackMap stack:
aload 5
iconst_1
aload 0
aload 2
aload 0
getfield org.hsqldb.test.TestCacheSize.smallrows:I
invokevirtual org.hsqldb.test.TestCacheSize.nextIntRandom:(Ljava/util/Random;I)I
invokeinterface java.sql.PreparedStatement.setInt:(II)V
9: aload 5
invokeinterface java.sql.PreparedStatement.execute:()Z
pop
10: iload 3
iconst_1
iadd
bipush 100
if_icmpne 12
aload 1
invokevirtual org.hsqldb.lib.StopWatch.elapsedTime:()J
ldc 50000
lcmp
ifle 12
11: iconst_1
istore 4
12: StackMap locals:
StackMap stack:
aload 0
getfield org.hsqldb.test.TestCacheSize.reportProgress:Z
ifeq 13
iload 3
iconst_1
iadd
sipush 10000
irem
ifeq 14
13: StackMap locals:
StackMap stack:
iload 4
ifeq 18
iload 3
iconst_1
iadd
bipush 100
irem
ifne 18
14: StackMap locals:
StackMap stack:
getstatic java.lang.System.out:Ljava/io/PrintStream;
new java.lang.StringBuilder
dup
ldc "Select "
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
iload 3
iconst_1
iadd
invokevirtual java.lang.StringBuilder.append:(I)Ljava/lang/StringBuilder;
ldc " : "
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
15: aload 1
invokevirtual org.hsqldb.lib.StopWatch.elapsedTime:()J
invokevirtual java.lang.StringBuilder.append:(J)Ljava/lang/StringBuilder;
ldc " rps: "
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
16: iload 3
sipush 1000
imul
i2l
aload 1
invokevirtual org.hsqldb.lib.StopWatch.elapsedTime:()J
lconst_1
ladd
ldiv
invokevirtual java.lang.StringBuilder.append:(J)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
17: invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
18: StackMap locals:
StackMap stack:
iinc 3 1
StackMap locals:
StackMap stack:
19: iload 3
aload 0
getfield org.hsqldb.test.TestCacheSize.bigops:I
if_icmplt 8
end local 5 20: goto 23
StackMap locals: org.hsqldb.test.TestCacheSize org.hsqldb.lib.StopWatch java.util.Random int int
StackMap stack: java.sql.SQLException
21: astore 5
start local 5 22: aload 5
invokevirtual java.sql.SQLException.printStackTrace:()V
end local 5 23: StackMap locals:
StackMap stack:
aload 1
invokevirtual org.hsqldb.lib.StopWatch.elapsedTime:()J
lstore 5
start local 5 24: iload 3
i2l
ldc 1000
lmul
lload 5
lconst_1
ladd
ldiv
lstore 7
start local 7 25: aload 0
ldc "select random zip"
iload 3
lload 5
lload 7
invokevirtual org.hsqldb.test.TestCacheSize.storeResult:(Ljava/lang/String;IJJ)V
26: getstatic java.lang.System.out:Ljava/io/PrintStream;
new java.lang.StringBuilder
dup
ldc "select time for random zip "
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
iload 3
invokevirtual java.lang.StringBuilder.append:(I)Ljava/lang/StringBuilder;
ldc " rows -- "
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
27: lload 5
invokevirtual java.lang.StringBuilder.append:(J)Ljava/lang/StringBuilder;
ldc " ms -- "
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
lload 7
invokevirtual java.lang.StringBuilder.append:(J)Ljava/lang/StringBuilder;
ldc " tps"
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
28: invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
29: return
end local 7 end local 5 end local 4 end local 3 end local 2 end local 1 end local 0 LocalVariableTable:
Start End Slot Name Signature
0 30 0 this Lorg/hsqldb/test/TestCacheSize;
1 30 1 sw Lorg/hsqldb/lib/StopWatch;
2 30 2 randomgen Ljava/util/Random;
3 30 3 i I
4 30 4 slow Z
7 20 5 ps Ljava/sql/PreparedStatement;
22 23 5 e Ljava/sql/SQLException;
24 30 5 time J
25 30 7 rate J
Exception table:
from to target type
4 20 21 Class java.sql.SQLException
void selectID();
descriptor: ()V
flags: (0x0000)
Code:
stack=7, locals=9, args_size=1
start local 0 0: new org.hsqldb.lib.StopWatch
dup
invokespecial org.hsqldb.lib.StopWatch.<init>:()V
astore 1
start local 1 1: new java.util.Random
dup
invokespecial java.util.Random.<init>:()V
astore 2
start local 2 2: iconst_0
istore 3
start local 3 3: iconst_0
istore 4
start local 4 4: aload 0
getfield org.hsqldb.test.TestCacheSize.cConnection:Ljava/sql/Connection;
5: ldc "SELECT firstname,lastname,zip,filler FROM test WHERE id = ?"
6: invokeinterface java.sql.Connection.prepareStatement:(Ljava/lang/String;)Ljava/sql/PreparedStatement;
astore 5
start local 5 7: iconst_0
istore 3
goto 16
8: StackMap locals: org.hsqldb.test.TestCacheSize org.hsqldb.lib.StopWatch java.util.Random int int java.sql.PreparedStatement
StackMap stack:
aload 5
iconst_1
aload 0
aload 2
aload 0
getfield org.hsqldb.test.TestCacheSize.bigrows:I
iconst_1
isub
invokevirtual org.hsqldb.test.TestCacheSize.nextIntRandom:(Ljava/util/Random;I)I
invokeinterface java.sql.PreparedStatement.setInt:(II)V
9: aload 5
invokeinterface java.sql.PreparedStatement.execute:()Z
pop
10: aload 0
getfield org.hsqldb.test.TestCacheSize.reportProgress:Z
ifeq 11
iload 3
iconst_1
iadd
sipush 10000
irem
ifeq 12
11: StackMap locals:
StackMap stack:
iload 4
ifeq 15
iload 3
iconst_1
iadd
bipush 100
irem
ifne 15
12: StackMap locals:
StackMap stack:
getstatic java.lang.System.out:Ljava/io/PrintStream;
new java.lang.StringBuilder
dup
ldc "Select "
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
iload 3
iconst_1
iadd
invokevirtual java.lang.StringBuilder.append:(I)Ljava/lang/StringBuilder;
ldc " : "
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
13: aload 1
invokevirtual org.hsqldb.lib.StopWatch.elapsedTime:()J
lconst_1
ladd
invokevirtual java.lang.StringBuilder.append:(J)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
14: invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
15: StackMap locals:
StackMap stack:
iinc 3 1
StackMap locals:
StackMap stack:
16: iload 3
aload 0
getfield org.hsqldb.test.TestCacheSize.smallops:I
if_icmplt 8
17: aload 5
invokeinterface java.sql.PreparedStatement.close:()V
end local 5 18: goto 21
StackMap locals: org.hsqldb.test.TestCacheSize org.hsqldb.lib.StopWatch java.util.Random int int
StackMap stack: java.sql.SQLException
19: astore 5
start local 5 20: aload 5
invokevirtual java.sql.SQLException.printStackTrace:()V
end local 5 21: StackMap locals:
StackMap stack:
aload 1
invokevirtual org.hsqldb.lib.StopWatch.elapsedTime:()J
lstore 5
start local 5 22: iload 3
i2l
ldc 1000
lmul
lload 5
lconst_1
ladd
ldiv
lstore 7
start local 7 23: aload 0
ldc "select random id"
iload 3
lload 5
lload 7
invokevirtual org.hsqldb.test.TestCacheSize.storeResult:(Ljava/lang/String;IJJ)V
24: getstatic java.lang.System.out:Ljava/io/PrintStream;
new java.lang.StringBuilder
dup
ldc "select time for random id "
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
iload 3
invokevirtual java.lang.StringBuilder.append:(I)Ljava/lang/StringBuilder;
ldc " rows -- "
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
25: lload 5
invokevirtual java.lang.StringBuilder.append:(J)Ljava/lang/StringBuilder;
ldc " ms -- "
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
lload 7
invokevirtual java.lang.StringBuilder.append:(J)Ljava/lang/StringBuilder;
ldc " tps"
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
26: invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
27: return
end local 7 end local 5 end local 4 end local 3 end local 2 end local 1 end local 0 LocalVariableTable:
Start End Slot Name Signature
0 28 0 this Lorg/hsqldb/test/TestCacheSize;
1 28 1 sw Lorg/hsqldb/lib/StopWatch;
2 28 2 randomgen Ljava/util/Random;
3 28 3 i I
4 28 4 slow Z
7 18 5 ps Ljava/sql/PreparedStatement;
20 21 5 e Ljava/sql/SQLException;
22 28 5 time J
23 28 7 rate J
Exception table:
from to target type
4 18 19 Class java.sql.SQLException
void selectZipTable();
descriptor: ()V
flags: (0x0000)
Code:
stack=7, locals=9, args_size=1
start local 0 0: new org.hsqldb.lib.StopWatch
dup
invokespecial org.hsqldb.lib.StopWatch.<init>:()V
astore 1
start local 1 1: new java.util.Random
dup
invokespecial java.util.Random.<init>:()V
astore 2
start local 2 2: iconst_0
istore 3
start local 3 3: iconst_0
istore 4
start local 4 4: aload 0
getfield org.hsqldb.test.TestCacheSize.cConnection:Ljava/sql/Connection;
5: ldc "SELECT zip FROM zip WHERE zip = ?"
6: invokeinterface java.sql.Connection.prepareStatement:(Ljava/lang/String;)Ljava/sql/PreparedStatement;
astore 5
start local 5 7: iconst_0
istore 3
goto 16
8: StackMap locals: org.hsqldb.test.TestCacheSize org.hsqldb.lib.StopWatch java.util.Random int int java.sql.PreparedStatement
StackMap stack:
aload 5
iconst_1
aload 0
aload 2
aload 0
getfield org.hsqldb.test.TestCacheSize.smallrows:I
iconst_1
isub
invokevirtual org.hsqldb.test.TestCacheSize.nextIntRandom:(Ljava/util/Random;I)I
invokeinterface java.sql.PreparedStatement.setInt:(II)V
9: aload 5
invokeinterface java.sql.PreparedStatement.execute:()Z
pop
10: aload 0
getfield org.hsqldb.test.TestCacheSize.reportProgress:Z
ifeq 11
iload 3
iconst_1
iadd
sipush 10000
irem
ifeq 12
11: StackMap locals:
StackMap stack:
iload 4
ifeq 15
iload 3
iconst_1
iadd
bipush 100
irem
ifne 15
12: StackMap locals:
StackMap stack:
getstatic java.lang.System.out:Ljava/io/PrintStream;
new java.lang.StringBuilder
dup
ldc "Select "
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
iload 3
iconst_1
iadd
invokevirtual java.lang.StringBuilder.append:(I)Ljava/lang/StringBuilder;
ldc " : "
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
13: aload 1
invokevirtual org.hsqldb.lib.StopWatch.elapsedTime:()J
lconst_1
ladd
invokevirtual java.lang.StringBuilder.append:(J)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
14: invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
15: StackMap locals:
StackMap stack:
iinc 3 1
StackMap locals:
StackMap stack:
16: iload 3
aload 0
getfield org.hsqldb.test.TestCacheSize.bigops:I
if_icmplt 8
17: aload 5
invokeinterface java.sql.PreparedStatement.close:()V
end local 5 18: goto 21
StackMap locals: org.hsqldb.test.TestCacheSize org.hsqldb.lib.StopWatch java.util.Random int int
StackMap stack: java.sql.SQLException
19: astore 5
start local 5 20: aload 5
invokevirtual java.sql.SQLException.printStackTrace:()V
end local 5 21: StackMap locals:
StackMap stack:
aload 1
invokevirtual org.hsqldb.lib.StopWatch.elapsedTime:()J
lstore 5
start local 5 22: iload 3
i2l
ldc 1000
lmul
lload 5
lconst_1
ladd
ldiv
lstore 7
start local 7 23: aload 0
ldc "select random zip (zip table)"
iload 3
lload 5
lload 7
invokevirtual org.hsqldb.test.TestCacheSize.storeResult:(Ljava/lang/String;IJJ)V
24: getstatic java.lang.System.out:Ljava/io/PrintStream;
new java.lang.StringBuilder
dup
ldc "select time for random zip from zip table "
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
iload 3
invokevirtual java.lang.StringBuilder.append:(I)Ljava/lang/StringBuilder;
25: ldc " rows -- "
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
lload 5
invokevirtual java.lang.StringBuilder.append:(J)Ljava/lang/StringBuilder;
ldc " ms -- "
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
lload 7
invokevirtual java.lang.StringBuilder.append:(J)Ljava/lang/StringBuilder;
ldc " tps"
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
26: invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
27: return
end local 7 end local 5 end local 4 end local 3 end local 2 end local 1 end local 0 LocalVariableTable:
Start End Slot Name Signature
0 28 0 this Lorg/hsqldb/test/TestCacheSize;
1 28 1 sw Lorg/hsqldb/lib/StopWatch;
2 28 2 randomgen Ljava/util/Random;
3 28 3 i I
4 28 4 slow Z
7 18 5 ps Ljava/sql/PreparedStatement;
20 21 5 e Ljava/sql/SQLException;
22 28 5 time J
23 28 7 rate J
Exception table:
from to target type
4 18 19 Class java.sql.SQLException
private void countTestID();
descriptor: ()V
flags: (0x0002) ACC_PRIVATE
Code:
stack=7, locals=7, args_size=1
start local 0 0: new org.hsqldb.lib.StopWatch
dup
invokespecial org.hsqldb.lib.StopWatch.<init>:()V
astore 1
start local 1 1: aload 0
getfield org.hsqldb.test.TestCacheSize.sStatement:Ljava/sql/Statement;
ldc "SELECT count(*) from TEST where id > -1"
invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
pop
2: aload 0
getfield org.hsqldb.test.TestCacheSize.sStatement:Ljava/sql/Statement;
invokeinterface java.sql.Statement.getResultSet:()Ljava/sql/ResultSet;
astore 2
start local 2 3: aload 2
invokeinterface java.sql.ResultSet.next:()Z
pop
4: aload 1
invokevirtual org.hsqldb.lib.StopWatch.elapsedTime:()J
lstore 3
start local 3 5: aload 0
getfield org.hsqldb.test.TestCacheSize.bigrows:I
i2l
ldc 1000
lmul
lload 3
lconst_1
ladd
ldiv
lstore 5
start local 5 6: aload 0
ldc "count (index on id)"
aload 2
iconst_1
invokeinterface java.sql.ResultSet.getInt:(I)I
lload 3
lload 5
invokevirtual org.hsqldb.test.TestCacheSize.storeResult:(Ljava/lang/String;IJJ)V
7: getstatic java.lang.System.out:Ljava/io/PrintStream;
new java.lang.StringBuilder
dup
ldc "count time (index on id) "
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
aload 2
iconst_1
invokeinterface java.sql.ResultSet.getInt:(I)I
invokevirtual java.lang.StringBuilder.append:(I)Ljava/lang/StringBuilder;
8: ldc " rows -- "
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
lload 3
invokevirtual java.lang.StringBuilder.append:(J)Ljava/lang/StringBuilder;
ldc " ms -- "
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
lload 5
invokevirtual java.lang.StringBuilder.append:(J)Ljava/lang/StringBuilder;
9: ldc " tps"
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
10: invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
11: aload 1
invokevirtual org.hsqldb.lib.StopWatch.zero:()V
12: aload 0
getfield org.hsqldb.test.TestCacheSize.sStatement:Ljava/sql/Statement;
ldc "SELECT count(*) from TEST"
invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
pop
13: aload 0
getfield org.hsqldb.test.TestCacheSize.sStatement:Ljava/sql/Statement;
invokeinterface java.sql.Statement.getResultSet:()Ljava/sql/ResultSet;
astore 2
14: aload 2
invokeinterface java.sql.ResultSet.next:()Z
pop
15: aload 1
invokevirtual org.hsqldb.lib.StopWatch.elapsedTime:()J
lstore 3
16: ldc 1000
lload 3
lconst_1
ladd
ldiv
lstore 5
17: aload 0
ldc "count (index on id)"
aload 2
iconst_1
invokeinterface java.sql.ResultSet.getInt:(I)I
lload 3
lload 5
invokevirtual org.hsqldb.test.TestCacheSize.storeResult:(Ljava/lang/String;IJJ)V
18: getstatic java.lang.System.out:Ljava/io/PrintStream;
new java.lang.StringBuilder
dup
ldc "count time (full count) "
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
aload 2
iconst_1
invokeinterface java.sql.ResultSet.getInt:(I)I
invokevirtual java.lang.StringBuilder.append:(I)Ljava/lang/StringBuilder;
19: ldc " rows -- "
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
lload 3
invokevirtual java.lang.StringBuilder.append:(J)Ljava/lang/StringBuilder;
ldc " ms -- "
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
lload 5
invokevirtual java.lang.StringBuilder.append:(J)Ljava/lang/StringBuilder;
20: ldc " tps"
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
21: invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
end local 5 end local 3 end local 2 end local 1 22: goto 24
StackMap locals:
StackMap stack: java.sql.SQLException
23: pop
24: StackMap locals:
StackMap stack:
return
end local 0 LocalVariableTable:
Start End Slot Name Signature
0 25 0 this Lorg/hsqldb/test/TestCacheSize;
1 22 1 sw Lorg/hsqldb/lib/StopWatch;
3 22 2 rs Ljava/sql/ResultSet;
5 22 3 time J
6 22 5 rate J
Exception table:
from to target type
0 22 23 Class java.sql.SQLException
private void countTestZip();
descriptor: ()V
flags: (0x0002) ACC_PRIVATE
Code:
stack=7, locals=7, args_size=1
start local 0 0: new org.hsqldb.lib.StopWatch
dup
invokespecial org.hsqldb.lib.StopWatch.<init>:()V
astore 1
start local 1 1: aload 0
getfield org.hsqldb.test.TestCacheSize.sStatement:Ljava/sql/Statement;
ldc "SELECT count(*) from TEST where zip > -1"
invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
pop
2: aload 0
getfield org.hsqldb.test.TestCacheSize.sStatement:Ljava/sql/Statement;
invokeinterface java.sql.Statement.getResultSet:()Ljava/sql/ResultSet;
astore 2
start local 2 3: aload 2
invokeinterface java.sql.ResultSet.next:()Z
pop
4: aload 1
invokevirtual org.hsqldb.lib.StopWatch.elapsedTime:()J
lstore 3
start local 3 5: aload 0
getfield org.hsqldb.test.TestCacheSize.bigrows:I
i2l
ldc 1000
lmul
lload 3
lconst_1
ladd
ldiv
lstore 5
start local 5 6: aload 0
ldc "count (index on zip)"
aload 2
iconst_1
invokeinterface java.sql.ResultSet.getInt:(I)I
lload 3
lload 5
invokevirtual org.hsqldb.test.TestCacheSize.storeResult:(Ljava/lang/String;IJJ)V
7: getstatic java.lang.System.out:Ljava/io/PrintStream;
new java.lang.StringBuilder
dup
ldc "count time (index on zip) "
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
aload 2
iconst_1
invokeinterface java.sql.ResultSet.getInt:(I)I
invokevirtual java.lang.StringBuilder.append:(I)Ljava/lang/StringBuilder;
8: ldc " rows -- "
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
lload 3
invokevirtual java.lang.StringBuilder.append:(J)Ljava/lang/StringBuilder;
ldc " ms -- "
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
lload 5
invokevirtual java.lang.StringBuilder.append:(J)Ljava/lang/StringBuilder;
9: ldc " tps"
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
10: invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
end local 5 end local 3 end local 2 end local 1 11: goto 13
StackMap locals:
StackMap stack: java.sql.SQLException
12: pop
13: StackMap locals:
StackMap stack:
return
end local 0 LocalVariableTable:
Start End Slot Name Signature
0 14 0 this Lorg/hsqldb/test/TestCacheSize;
1 11 1 sw Lorg/hsqldb/lib/StopWatch;
3 11 2 rs Ljava/sql/ResultSet;
5 11 3 time J
6 11 5 rate J
Exception table:
from to target type
0 11 12 Class java.sql.SQLException
private void countZip();
descriptor: ()V
flags: (0x0002) ACC_PRIVATE
Code:
stack=4, locals=3, args_size=1
start local 0 0: new org.hsqldb.lib.StopWatch
dup
invokespecial org.hsqldb.lib.StopWatch.<init>:()V
astore 1
start local 1 1: aload 0
getfield org.hsqldb.test.TestCacheSize.sStatement:Ljava/sql/Statement;
ldc "SELECT count(*) from zip where zip > -1"
invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
pop
2: aload 0
getfield org.hsqldb.test.TestCacheSize.sStatement:Ljava/sql/Statement;
invokeinterface java.sql.Statement.getResultSet:()Ljava/sql/ResultSet;
astore 2
start local 2 3: aload 2
invokeinterface java.sql.ResultSet.next:()Z
pop
4: getstatic java.lang.System.out:Ljava/io/PrintStream;
new java.lang.StringBuilder
dup
ldc "count time (zip table) "
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
aload 2
iconst_1
invokeinterface java.sql.ResultSet.getInt:(I)I
invokevirtual java.lang.StringBuilder.append:(I)Ljava/lang/StringBuilder;
5: ldc " rows -- "
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
aload 1
invokevirtual org.hsqldb.lib.StopWatch.elapsedTime:()J
invokevirtual java.lang.StringBuilder.append:(J)Ljava/lang/StringBuilder;
ldc " ms"
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
6: invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
end local 2 end local 1 7: goto 9
StackMap locals:
StackMap stack: java.sql.SQLException
8: pop
9: StackMap locals:
StackMap stack:
return
end local 0 LocalVariableTable:
Start End Slot Name Signature
0 10 0 this Lorg/hsqldb/test/TestCacheSize;
1 7 1 sw Lorg/hsqldb/lib/StopWatch;
3 7 2 rs Ljava/sql/ResultSet;
Exception table:
from to target type
0 7 8 Class java.sql.SQLException
private void updateZip();
descriptor: ()V
flags: (0x0002) ACC_PRIVATE
Code:
stack=7, locals=10, args_size=1
start local 0 0: new org.hsqldb.lib.StopWatch
dup
invokespecial org.hsqldb.lib.StopWatch.<init>:()V
astore 1
start local 1 1: new java.util.Random
dup
invokespecial java.util.Random.<init>:()V
astore 2
start local 2 2: iconst_0
istore 3
start local 3 3: iconst_0
istore 4
start local 4 4: iconst_0
istore 5
start local 5 5: aload 0
getfield org.hsqldb.test.TestCacheSize.cConnection:Ljava/sql/Connection;
6: ldc "UPDATE test SET filler = filler || zip WHERE zip = ?"
7: invokeinterface java.sql.Connection.prepareStatement:(Ljava/lang/String;)Ljava/sql/PreparedStatement;
astore 6
start local 6 8: goto 17
9: StackMap locals: org.hsqldb.test.TestCacheSize org.hsqldb.lib.StopWatch java.util.Random int int int java.sql.PreparedStatement
StackMap stack:
aload 0
aload 2
aload 0
getfield org.hsqldb.test.TestCacheSize.smallrows:I
iconst_1
isub
invokevirtual org.hsqldb.test.TestCacheSize.nextIntRandom:(Ljava/util/Random;I)I
istore 5
10: aload 6
iconst_1
iload 5
invokeinterface java.sql.PreparedStatement.setInt:(II)V
11: iload 4
aload 6
invokeinterface java.sql.PreparedStatement.executeUpdate:()I
iadd
istore 4
12: aload 0
getfield org.hsqldb.test.TestCacheSize.reportProgress:Z
ifeq 16
iload 4
sipush 10000
irem
bipush 20
if_icmpge 16
13: getstatic java.lang.System.out:Ljava/io/PrintStream;
new java.lang.StringBuilder
dup
ldc "Update "
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
iload 4
invokevirtual java.lang.StringBuilder.append:(I)Ljava/lang/StringBuilder;
ldc " : "
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
14: aload 1
invokevirtual org.hsqldb.lib.StopWatch.elapsedTime:()J
lconst_1
ladd
invokevirtual java.lang.StringBuilder.append:(J)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
15: invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
16: StackMap locals:
StackMap stack:
iinc 3 1
StackMap locals:
StackMap stack:
17: iload 3
aload 0
getfield org.hsqldb.test.TestCacheSize.smallrows:I
if_icmplt 9
18: aload 6
invokeinterface java.sql.PreparedStatement.close:()V
end local 6 19: goto 23
StackMap locals: org.hsqldb.test.TestCacheSize org.hsqldb.lib.StopWatch java.util.Random int int int
StackMap stack: java.sql.SQLException
20: astore 6
start local 6 21: getstatic java.lang.System.out:Ljava/io/PrintStream;
new java.lang.StringBuilder
dup
ldc "error : "
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
iload 5
invokevirtual java.lang.StringBuilder.append:(I)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
22: aload 6
invokevirtual java.sql.SQLException.printStackTrace:()V
end local 6 23: StackMap locals:
StackMap stack:
aload 1
invokevirtual org.hsqldb.lib.StopWatch.elapsedTime:()J
lstore 6
start local 6 24: iload 3
sipush 1000
imul
i2l
lload 6
lconst_1
ladd
ldiv
lstore 8
start local 8 25: aload 0
ldc "update with random zip"
iload 3
lload 6
lload 8
invokevirtual org.hsqldb.test.TestCacheSize.storeResult:(Ljava/lang/String;IJJ)V
26: getstatic java.lang.System.out:Ljava/io/PrintStream;
new java.lang.StringBuilder
dup
ldc "update time with random zip "
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
iload 3
invokevirtual java.lang.StringBuilder.append:(I)Ljava/lang/StringBuilder;
ldc " rows -- "
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
27: lload 6
invokevirtual java.lang.StringBuilder.append:(J)Ljava/lang/StringBuilder;
ldc " ms -- "
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
lload 8
invokevirtual java.lang.StringBuilder.append:(J)Ljava/lang/StringBuilder;
ldc " tps"
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
28: invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
29: return
end local 8 end local 6 end local 5 end local 4 end local 3 end local 2 end local 1 end local 0 LocalVariableTable:
Start End Slot Name Signature
0 30 0 this Lorg/hsqldb/test/TestCacheSize;
1 30 1 sw Lorg/hsqldb/lib/StopWatch;
2 30 2 randomgen Ljava/util/Random;
3 30 3 i I
4 30 4 count I
5 30 5 random I
8 19 6 ps Ljava/sql/PreparedStatement;
21 23 6 e Ljava/sql/SQLException;
24 30 6 time J
25 30 8 rate J
Exception table:
from to target type
5 19 20 Class java.sql.SQLException
void updateID();
descriptor: ()V
flags: (0x0000)
Code:
stack=8, locals=10, args_size=1
start local 0 0: new org.hsqldb.lib.StopWatch
dup
invokespecial org.hsqldb.lib.StopWatch.<init>:()V
astore 1
start local 1 1: new java.util.Random
dup
invokespecial java.util.Random.<init>:()V
astore 2
start local 2 2: iconst_0
istore 3
start local 3 3: iconst_0
istore 4
start local 4 4: iconst_0
istore 5
start local 5 5: aload 0
getfield org.hsqldb.test.TestCacheSize.cConnection:Ljava/sql/Connection;
6: new java.lang.StringBuilder
dup
ldc "UPDATE test SET zip = zip + 1 WHERE id = ? and zip <> "
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
7: aload 0
getfield org.hsqldb.test.TestCacheSize.smallrows:I
invokevirtual java.lang.StringBuilder.append:(I)Ljava/lang/StringBuilder;
8: invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
9: invokeinterface java.sql.Connection.prepareStatement:(Ljava/lang/String;)Ljava/sql/PreparedStatement;
astore 6
start local 6 10: iconst_0
istore 3
goto 21
11: StackMap locals: org.hsqldb.test.TestCacheSize org.hsqldb.lib.StopWatch java.util.Random int int int java.sql.PreparedStatement
StackMap stack:
aload 0
aload 2
aload 0
getfield org.hsqldb.test.TestCacheSize.bigrows:I
iconst_1
isub
invokevirtual org.hsqldb.test.TestCacheSize.nextIntRandom:(Ljava/util/Random;I)I
istore 5
12: aload 6
iconst_1
iload 5
invokeinterface java.sql.PreparedStatement.setInt:(II)V
13: aload 6
invokeinterface java.sql.PreparedStatement.execute:()Z
pop
14: aload 0
getfield org.hsqldb.test.TestCacheSize.reportProgress:Z
ifeq 15
iload 3
iconst_1
iadd
sipush 10000
irem
ifeq 16
15: StackMap locals:
StackMap stack:
iload 4
ifeq 20
iload 3
iconst_1
iadd
bipush 100
irem
ifne 20
16: StackMap locals:
StackMap stack:
getstatic java.lang.System.out:Ljava/io/PrintStream;
new java.lang.StringBuilder
dup
ldc "Update "
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
iload 3
iconst_1
iadd
invokevirtual java.lang.StringBuilder.append:(I)Ljava/lang/StringBuilder;
ldc " : "
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
17: aload 1
invokevirtual org.hsqldb.lib.StopWatch.elapsedTime:()J
invokevirtual java.lang.StringBuilder.append:(J)Ljava/lang/StringBuilder;
ldc " rps: "
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
18: iload 3
sipush 1000
imul
i2l
aload 1
invokevirtual org.hsqldb.lib.StopWatch.elapsedTime:()J
lconst_1
ladd
ldiv
invokevirtual java.lang.StringBuilder.append:(J)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
19: invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
20: StackMap locals:
StackMap stack:
iinc 3 1
StackMap locals:
StackMap stack:
21: iload 3
aload 0
getfield org.hsqldb.test.TestCacheSize.smallops:I
if_icmplt 11
22: aload 6
invokeinterface java.sql.PreparedStatement.close:()V
end local 6 23: goto 27
StackMap locals: org.hsqldb.test.TestCacheSize org.hsqldb.lib.StopWatch java.util.Random int int int
StackMap stack: java.sql.SQLException
24: astore 6
start local 6 25: getstatic java.lang.System.out:Ljava/io/PrintStream;
new java.lang.StringBuilder
dup
ldc "error : "
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
iload 5
invokevirtual java.lang.StringBuilder.append:(I)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
26: aload 6
invokevirtual java.sql.SQLException.printStackTrace:()V
end local 6 27: StackMap locals:
StackMap stack:
aload 1
invokevirtual org.hsqldb.lib.StopWatch.elapsedTime:()J
lstore 6
start local 6 28: iload 3
sipush 1000
imul
i2l
lload 6
lconst_1
ladd
ldiv
lstore 8
start local 8 29: aload 0
ldc "update with random id"
iload 3
lload 6
lload 8
invokevirtual org.hsqldb.test.TestCacheSize.storeResult:(Ljava/lang/String;IJJ)V
30: getstatic java.lang.System.out:Ljava/io/PrintStream;
new java.lang.StringBuilder
dup
ldc "update time with random id "
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
iload 3
invokevirtual java.lang.StringBuilder.append:(I)Ljava/lang/StringBuilder;
ldc " rows -- "
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
31: lload 6
invokevirtual java.lang.StringBuilder.append:(J)Ljava/lang/StringBuilder;
ldc " ms -- "
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
lload 8
invokevirtual java.lang.StringBuilder.append:(J)Ljava/lang/StringBuilder;
ldc " tps"
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
32: invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
33: return
end local 8 end local 6 end local 5 end local 4 end local 3 end local 2 end local 1 end local 0 LocalVariableTable:
Start End Slot Name Signature
0 34 0 this Lorg/hsqldb/test/TestCacheSize;
1 34 1 sw Lorg/hsqldb/lib/StopWatch;
2 34 2 randomgen Ljava/util/Random;
3 34 3 i I
4 34 4 slow Z
5 34 5 random I
10 23 6 ps Ljava/sql/PreparedStatement;
25 27 6 e Ljava/sql/SQLException;
28 34 6 time J
29 34 8 rate J
Exception table:
from to target type
5 23 24 Class java.sql.SQLException
void updateTestString();
descriptor: ()V
flags: (0x0000)
Code:
stack=8, locals=10, args_size=1
start local 0 0: new org.hsqldb.lib.StopWatch
dup
invokespecial org.hsqldb.lib.StopWatch.<init>:()V
astore 1
start local 1 1: new java.util.Random
dup
invokespecial java.util.Random.<init>:()V
astore 2
start local 2 2: iconst_0
istore 3
start local 3 3: iconst_0
istore 4
start local 4 4: iconst_0
istore 5
start local 5 5: aload 0
getfield org.hsqldb.test.TestCacheSize.cConnection:Ljava/sql/Connection;
6: new java.lang.StringBuilder
dup
ldc "UPDATE test SET filler = ? WHERE id = ? and zip <> "
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
7: aload 0
getfield org.hsqldb.test.TestCacheSize.smallrows:I
invokevirtual java.lang.StringBuilder.append:(I)Ljava/lang/StringBuilder;
8: invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
9: invokeinterface java.sql.Connection.prepareStatement:(Ljava/lang/String;)Ljava/sql/PreparedStatement;
astore 6
start local 6 10: iconst_0
istore 3
goto 24
11: StackMap locals: org.hsqldb.test.TestCacheSize org.hsqldb.lib.StopWatch java.util.Random int int int java.sql.PreparedStatement
StackMap stack:
aload 0
aload 2
aload 0
getfield org.hsqldb.test.TestCacheSize.bigrows:I
iconst_1
isub
invokevirtual org.hsqldb.test.TestCacheSize.nextIntRandom:(Ljava/util/Random;I)I
istore 5
12: aload 0
aload 2
aload 0
getfield org.hsqldb.test.TestCacheSize.filler:Ljava/lang/String;
invokevirtual java.lang.String.length:()I
invokevirtual org.hsqldb.test.TestCacheSize.nextIntRandom:(Ljava/util/Random;I)I
istore 7
start local 7 13: aload 0
getfield org.hsqldb.test.TestCacheSize.filler:Ljava/lang/String;
iload 7
invokevirtual java.lang.String.substring:(I)Ljava/lang/String;
astore 8
start local 8 14: aload 6
iconst_1
aload 8
invokeinterface java.sql.PreparedStatement.setString:(ILjava/lang/String;)V
15: aload 6
iconst_2
iload 5
invokeinterface java.sql.PreparedStatement.setInt:(II)V
16: aload 6
invokeinterface java.sql.PreparedStatement.execute:()Z
pop
17: aload 0
getfield org.hsqldb.test.TestCacheSize.reportProgress:Z
ifeq 18
iload 3
iconst_1
iadd
sipush 10000
irem
ifeq 19
18: StackMap locals: int java.lang.String
StackMap stack:
iload 4
ifeq 23
iload 3
iconst_1
iadd
bipush 100
irem
ifne 23
19: StackMap locals:
StackMap stack:
getstatic java.lang.System.out:Ljava/io/PrintStream;
new java.lang.StringBuilder
dup
ldc "Update "
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
iload 3
iconst_1
iadd
invokevirtual java.lang.StringBuilder.append:(I)Ljava/lang/StringBuilder;
ldc " : "
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
20: aload 1
invokevirtual org.hsqldb.lib.StopWatch.elapsedTime:()J
invokevirtual java.lang.StringBuilder.append:(J)Ljava/lang/StringBuilder;
ldc " rps: "
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
21: iload 3
sipush 1000
imul
i2l
aload 1
invokevirtual org.hsqldb.lib.StopWatch.elapsedTime:()J
lconst_1
ladd
ldiv
invokevirtual java.lang.StringBuilder.append:(J)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
22: invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
end local 8 end local 7 23: StackMap locals:
StackMap stack:
iinc 3 1
StackMap locals:
StackMap stack:
24: iload 3
aload 0
getfield org.hsqldb.test.TestCacheSize.smallops:I
iconst_2
imul
if_icmplt 11
25: aload 6
invokeinterface java.sql.PreparedStatement.close:()V
end local 6 26: goto 30
StackMap locals: org.hsqldb.test.TestCacheSize org.hsqldb.lib.StopWatch java.util.Random int int int
StackMap stack: java.sql.SQLException
27: astore 6
start local 6 28: getstatic java.lang.System.out:Ljava/io/PrintStream;
new java.lang.StringBuilder
dup
ldc "error : "
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
iload 5
invokevirtual java.lang.StringBuilder.append:(I)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
29: aload 6
invokevirtual java.sql.SQLException.printStackTrace:()V
end local 6 30: StackMap locals:
StackMap stack:
aload 1
invokevirtual org.hsqldb.lib.StopWatch.elapsedTime:()J
lstore 6
start local 6 31: iload 3
sipush 1000
imul
i2l
lload 6
lconst_1
ladd
ldiv
lstore 8
start local 8 32: aload 0
ldc "update with random id"
iload 3
lload 6
lload 8
invokevirtual org.hsqldb.test.TestCacheSize.storeResult:(Ljava/lang/String;IJJ)V
33: getstatic java.lang.System.out:Ljava/io/PrintStream;
new java.lang.StringBuilder
dup
ldc "update time with random id "
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
iload 3
invokevirtual java.lang.StringBuilder.append:(I)Ljava/lang/StringBuilder;
ldc " rows -- "
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
34: lload 6
invokevirtual java.lang.StringBuilder.append:(J)Ljava/lang/StringBuilder;
ldc " ms -- "
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
lload 8
invokevirtual java.lang.StringBuilder.append:(J)Ljava/lang/StringBuilder;
ldc " tps"
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
35: invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
36: return
end local 8 end local 6 end local 5 end local 4 end local 3 end local 2 end local 1 end local 0 LocalVariableTable:
Start End Slot Name Signature
0 37 0 this Lorg/hsqldb/test/TestCacheSize;
1 37 1 sw Lorg/hsqldb/lib/StopWatch;
2 37 2 randomgen Ljava/util/Random;
3 37 3 i I
4 37 4 slow Z
5 37 5 random I
10 26 6 ps Ljava/sql/PreparedStatement;
13 23 7 randomLength I
14 23 8 newFiller Ljava/lang/String;
28 30 6 e Ljava/sql/SQLException;
31 37 6 time J
32 37 8 rate J
Exception table:
from to target type
5 26 27 Class java.sql.SQLException
void updateIDLinear();
descriptor: ()V
flags: (0x0000)
Code:
stack=8, locals=9, args_size=1
start local 0 0: new org.hsqldb.lib.StopWatch
dup
invokespecial org.hsqldb.lib.StopWatch.<init>:()V
astore 1
start local 1 1: new java.util.Random
invokespecial java.util.Random.<init>:()V
2: iconst_0
istore 2
start local 2 3: iconst_0
istore 3
start local 3 4: iconst_0
istore 4
start local 4 5: aload 0
getfield org.hsqldb.test.TestCacheSize.cConnection:Ljava/sql/Connection;
6: new java.lang.StringBuilder
dup
ldc "UPDATE test SET zip = zip + 1 WHERE id = ? and zip <> "
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
7: aload 0
getfield org.hsqldb.test.TestCacheSize.smallrows:I
invokevirtual java.lang.StringBuilder.append:(I)Ljava/lang/StringBuilder;
8: invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
9: invokeinterface java.sql.Connection.prepareStatement:(Ljava/lang/String;)Ljava/sql/PreparedStatement;
astore 5
start local 5 10: iconst_0
istore 2
goto 21
11: StackMap locals: org.hsqldb.test.TestCacheSize org.hsqldb.lib.StopWatch int int int java.sql.PreparedStatement
StackMap stack:
iload 2
istore 4
12: aload 5
iconst_1
iload 4
invokeinterface java.sql.PreparedStatement.setInt:(II)V
13: aload 5
invokeinterface java.sql.PreparedStatement.execute:()Z
pop
14: aload 0
getfield org.hsqldb.test.TestCacheSize.reportProgress:Z
ifeq 15
iload 2
iconst_1
iadd
sipush 10000
irem
ifeq 16
15: StackMap locals:
StackMap stack:
iload 3
ifeq 20
iload 2
iconst_1
iadd
bipush 100
irem
ifne 20
16: StackMap locals:
StackMap stack:
getstatic java.lang.System.out:Ljava/io/PrintStream;
new java.lang.StringBuilder
dup
ldc "Update "
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
iload 2
iconst_1
iadd
invokevirtual java.lang.StringBuilder.append:(I)Ljava/lang/StringBuilder;
ldc " : "
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
17: aload 1
invokevirtual org.hsqldb.lib.StopWatch.elapsedTime:()J
invokevirtual java.lang.StringBuilder.append:(J)Ljava/lang/StringBuilder;
ldc " rps: "
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
18: iload 2
sipush 1000
imul
i2l
aload 1
invokevirtual org.hsqldb.lib.StopWatch.elapsedTime:()J
lconst_1
ladd
ldiv
invokevirtual java.lang.StringBuilder.append:(J)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
19: invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
20: StackMap locals:
StackMap stack:
iinc 2 1
StackMap locals:
StackMap stack:
21: iload 2
aload 0
getfield org.hsqldb.test.TestCacheSize.bigops:I
if_icmplt 11
22: aload 5
invokeinterface java.sql.PreparedStatement.close:()V
end local 5 23: goto 27
StackMap locals: org.hsqldb.test.TestCacheSize org.hsqldb.lib.StopWatch int int int
StackMap stack: java.sql.SQLException
24: astore 5
start local 5 25: getstatic java.lang.System.out:Ljava/io/PrintStream;
new java.lang.StringBuilder
dup
ldc "error : "
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
iload 4
invokevirtual java.lang.StringBuilder.append:(I)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
26: aload 5
invokevirtual java.sql.SQLException.printStackTrace:()V
end local 5 27: StackMap locals:
StackMap stack:
aload 1
invokevirtual org.hsqldb.lib.StopWatch.elapsedTime:()J
lstore 5
start local 5 28: iload 2
sipush 1000
imul
i2l
lload 5
lconst_1
ladd
ldiv
lstore 7
start local 7 29: aload 0
ldc "update with sequential id"
iload 2
lload 5
lload 7
invokevirtual org.hsqldb.test.TestCacheSize.storeResult:(Ljava/lang/String;IJJ)V
30: getstatic java.lang.System.out:Ljava/io/PrintStream;
new java.lang.StringBuilder
dup
ldc "update time with sequential id "
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
iload 2
invokevirtual java.lang.StringBuilder.append:(I)Ljava/lang/StringBuilder;
31: ldc " rows -- "
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
lload 5
invokevirtual java.lang.StringBuilder.append:(J)Ljava/lang/StringBuilder;
ldc " ms -- "
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
lload 7
invokevirtual java.lang.StringBuilder.append:(J)Ljava/lang/StringBuilder;
ldc " tps"
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
32: invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
33: return
end local 7 end local 5 end local 4 end local 3 end local 2 end local 1 end local 0 LocalVariableTable:
Start End Slot Name Signature
0 34 0 this Lorg/hsqldb/test/TestCacheSize;
1 34 1 sw Lorg/hsqldb/lib/StopWatch;
3 34 2 i I
4 34 3 slow Z
5 34 4 random I
10 23 5 ps Ljava/sql/PreparedStatement;
25 27 5 e Ljava/sql/SQLException;
28 34 5 time J
29 34 7 rate J
Exception table:
from to target type
5 23 24 Class java.sql.SQLException
void deleteTest();
descriptor: ()V
flags: (0x0000)
Code:
stack=8, locals=11, args_size=1
start local 0 0: new org.hsqldb.lib.StopWatch
dup
invokespecial org.hsqldb.lib.StopWatch.<init>:()V
astore 1
start local 1 1: new java.util.Random
dup
invokespecial java.util.Random.<init>:()V
astore 2
start local 2 2: iconst_0
istore 3
start local 3 3: iconst_0
istore 4
start local 4 4: iconst_0
istore 5
start local 5 5: iconst_0
istore 6
start local 6 6: aload 0
getfield org.hsqldb.test.TestCacheSize.cConnection:Ljava/sql/Connection;
ldc "DELETE FROM test WHERE id = ?"
invokeinterface java.sql.Connection.prepareStatement:(Ljava/lang/String;)Ljava/sql/PreparedStatement;
7: astore 7
start local 7 8: iconst_0
istore 3
goto 19
9: StackMap locals: org.hsqldb.test.TestCacheSize org.hsqldb.lib.StopWatch java.util.Random int int int int java.sql.PreparedStatement
StackMap stack:
aload 0
aload 2
aload 0
getfield org.hsqldb.test.TestCacheSize.bigrows:I
invokevirtual org.hsqldb.test.TestCacheSize.nextIntRandom:(Ljava/util/Random;I)I
istore 6
10: aload 7
iconst_1
iload 6
invokeinterface java.sql.PreparedStatement.setInt:(II)V
11: iload 5
aload 7
invokeinterface java.sql.PreparedStatement.executeUpdate:()I
iadd
istore 5
12: aload 0
getfield org.hsqldb.test.TestCacheSize.reportProgress:Z
ifeq 13
iload 3
iconst_1
iadd
sipush 10000
irem
ifeq 14
13: StackMap locals:
StackMap stack:
iload 4
ifeq 18
iload 3
iconst_1
iadd
bipush 100
irem
ifne 18
14: StackMap locals:
StackMap stack:
getstatic java.lang.System.out:Ljava/io/PrintStream;
new java.lang.StringBuilder
dup
ldc "delete "
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
iload 3
iconst_1
iadd
invokevirtual java.lang.StringBuilder.append:(I)Ljava/lang/StringBuilder;
ldc " : "
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
15: aload 1
invokevirtual org.hsqldb.lib.StopWatch.elapsedTime:()J
invokevirtual java.lang.StringBuilder.append:(J)Ljava/lang/StringBuilder;
ldc " rps: "
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
16: iload 3
sipush 1000
imul
i2l
aload 1
invokevirtual org.hsqldb.lib.StopWatch.elapsedTime:()J
lconst_1
ladd
ldiv
invokevirtual java.lang.StringBuilder.append:(J)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
17: invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
18: StackMap locals:
StackMap stack:
iinc 3 1
StackMap locals:
StackMap stack:
19: iload 5
aload 0
getfield org.hsqldb.test.TestCacheSize.smallops:I
if_icmplt 9
20: aload 7
invokeinterface java.sql.PreparedStatement.close:()V
end local 7 21: goto 25
StackMap locals: org.hsqldb.test.TestCacheSize org.hsqldb.lib.StopWatch java.util.Random int int int int
StackMap stack: java.sql.SQLException
22: astore 7
start local 7 23: getstatic java.lang.System.out:Ljava/io/PrintStream;
new java.lang.StringBuilder
dup
ldc "error : "
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
iload 6
invokevirtual java.lang.StringBuilder.append:(I)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
24: aload 7
invokevirtual java.sql.SQLException.printStackTrace:()V
end local 7 25: StackMap locals:
StackMap stack:
aload 1
invokevirtual org.hsqldb.lib.StopWatch.elapsedTime:()J
lstore 7
start local 7 26: iload 5
sipush 1000
imul
i2l
lload 7
lconst_1
ladd
ldiv
lstore 9
start local 9 27: aload 0
ldc "delete with random id"
iload 5
lload 7
lload 9
invokevirtual org.hsqldb.test.TestCacheSize.storeResult:(Ljava/lang/String;IJJ)V
28: getstatic java.lang.System.out:Ljava/io/PrintStream;
new java.lang.StringBuilder
dup
ldc "delete time for random id "
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
iload 5
invokevirtual java.lang.StringBuilder.append:(I)Ljava/lang/StringBuilder;
ldc " rows -- "
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
29: lload 7
invokevirtual java.lang.StringBuilder.append:(J)Ljava/lang/StringBuilder;
ldc " ms -- "
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
lload 9
invokevirtual java.lang.StringBuilder.append:(J)Ljava/lang/StringBuilder;
ldc " tps"
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
30: invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
31: return
end local 9 end local 7 end local 6 end local 5 end local 4 end local 3 end local 2 end local 1 end local 0 LocalVariableTable:
Start End Slot Name Signature
0 32 0 this Lorg/hsqldb/test/TestCacheSize;
1 32 1 sw Lorg/hsqldb/lib/StopWatch;
2 32 2 randomgen Ljava/util/Random;
3 32 3 i I
4 32 4 slow Z
5 32 5 count I
6 32 6 random I
8 21 7 ps Ljava/sql/PreparedStatement;
23 25 7 e Ljava/sql/SQLException;
26 32 7 time J
27 32 9 rate J
Exception table:
from to target type
6 21 22 Class java.sql.SQLException
void deleteZipTable();
descriptor: ()V
flags: (0x0000)
Code:
stack=8, locals=10, args_size=1
start local 0 0: new org.hsqldb.lib.StopWatch
dup
invokespecial org.hsqldb.lib.StopWatch.<init>:()V
astore 1
start local 1 1: new java.util.Random
invokespecial java.util.Random.<init>:()V
2: iconst_0
istore 2
start local 2 3: iconst_0
istore 3
start local 3 4: iconst_0
istore 4
start local 4 5: iconst_0
istore 5
start local 5 6: aload 0
getfield org.hsqldb.test.TestCacheSize.cConnection:Ljava/sql/Connection;
ldc "DELETE FROM zip WHERE zip = ?"
invokeinterface java.sql.Connection.prepareStatement:(Ljava/lang/String;)Ljava/sql/PreparedStatement;
7: astore 6
start local 6 8: iconst_0
istore 2
goto 19
9: StackMap locals: org.hsqldb.test.TestCacheSize org.hsqldb.lib.StopWatch int int int int java.sql.PreparedStatement
StackMap stack:
iload 2
istore 5
10: aload 6
iconst_1
iload 5
invokeinterface java.sql.PreparedStatement.setInt:(II)V
11: iload 4
aload 6
invokeinterface java.sql.PreparedStatement.executeUpdate:()I
iadd
istore 4
12: aload 0
getfield org.hsqldb.test.TestCacheSize.reportProgress:Z
ifeq 13
iload 2
iconst_1
iadd
sipush 10000
irem
ifeq 14
13: StackMap locals:
StackMap stack:
iload 3
ifeq 18
iload 2
iconst_1
iadd
bipush 100
irem
ifne 18
14: StackMap locals:
StackMap stack:
getstatic java.lang.System.out:Ljava/io/PrintStream;
new java.lang.StringBuilder
dup
ldc "delete "
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
iload 2
iconst_1
iadd
invokevirtual java.lang.StringBuilder.append:(I)Ljava/lang/StringBuilder;
ldc " : "
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
15: aload 1
invokevirtual org.hsqldb.lib.StopWatch.elapsedTime:()J
invokevirtual java.lang.StringBuilder.append:(J)Ljava/lang/StringBuilder;
ldc " rps: "
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
16: iload 2
sipush 1000
imul
i2l
aload 1
invokevirtual org.hsqldb.lib.StopWatch.elapsedTime:()J
lconst_1
ladd
ldiv
invokevirtual java.lang.StringBuilder.append:(J)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
17: invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
18: StackMap locals:
StackMap stack:
iinc 2 1
StackMap locals:
StackMap stack:
19: iload 2
aload 0
getfield org.hsqldb.test.TestCacheSize.smallrows:I
if_icmple 9
20: aload 6
invokeinterface java.sql.PreparedStatement.close:()V
end local 6 21: goto 25
StackMap locals: org.hsqldb.test.TestCacheSize org.hsqldb.lib.StopWatch int int int int
StackMap stack: java.sql.SQLException
22: astore 6
start local 6 23: getstatic java.lang.System.out:Ljava/io/PrintStream;
new java.lang.StringBuilder
dup
ldc "error : "
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
iload 5
invokevirtual java.lang.StringBuilder.append:(I)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
24: aload 6
invokevirtual java.sql.SQLException.printStackTrace:()V
end local 6 25: StackMap locals:
StackMap stack:
aload 1
invokevirtual org.hsqldb.lib.StopWatch.elapsedTime:()J
lstore 6
start local 6 26: iload 4
i2l
ldc 1000
lmul
lload 6
lconst_1
ladd
ldiv
lstore 8
start local 8 27: aload 0
ldc "delete with random zip"
iload 4
lload 6
lload 8
invokevirtual org.hsqldb.test.TestCacheSize.storeResult:(Ljava/lang/String;IJJ)V
28: getstatic java.lang.System.out:Ljava/io/PrintStream;
new java.lang.StringBuilder
dup
ldc "delete time for random zip "
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
iload 4
invokevirtual java.lang.StringBuilder.append:(I)Ljava/lang/StringBuilder;
29: ldc " rows -- "
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
lload 6
invokevirtual java.lang.StringBuilder.append:(J)Ljava/lang/StringBuilder;
ldc " ms -- "
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
lload 8
invokevirtual java.lang.StringBuilder.append:(J)Ljava/lang/StringBuilder;
ldc " tps"
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
30: invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
31: return
end local 8 end local 6 end local 5 end local 4 end local 3 end local 2 end local 1 end local 0 LocalVariableTable:
Start End Slot Name Signature
0 32 0 this Lorg/hsqldb/test/TestCacheSize;
1 32 1 sw Lorg/hsqldb/lib/StopWatch;
3 32 2 i I
4 32 3 slow Z
5 32 4 count I
6 32 5 random I
8 21 6 ps Ljava/sql/PreparedStatement;
23 25 6 e Ljava/sql/SQLException;
26 32 6 time J
27 32 8 rate J
Exception table:
from to target type
6 21 22 Class java.sql.SQLException
void storeResult(java.lang.String, int, long, long);
descriptor: (Ljava/lang/String;IJJ)V
flags: (0x0000)
Code:
stack=4, locals=7, args_size=5
start local 0 start local 1 start local 2 start local 3 start local 5 0: aload 0
getfield org.hsqldb.test.TestCacheSize.writer:Ljava/io/FileWriter;
new java.lang.StringBuilder
dup
ldc "<tr><td>"
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
aload 1
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
ldc "</td><td>"
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
iload 2
invokevirtual java.lang.StringBuilder.append:(I)Ljava/lang/StringBuilder;
1: ldc "</td><td>"
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
lload 3
invokevirtual java.lang.StringBuilder.append:(J)Ljava/lang/StringBuilder;
ldc "</td><td>"
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
lload 5
invokevirtual java.lang.StringBuilder.append:(J)Ljava/lang/StringBuilder;
2: ldc "</td></tr>\n"
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
3: invokevirtual java.io.FileWriter.write:(Ljava/lang/String;)V
4: goto 6
StackMap locals:
StackMap stack: java.lang.Exception
5: pop
6: StackMap locals:
StackMap stack:
return
end local 5 end local 3 end local 2 end local 1 end local 0 LocalVariableTable:
Start End Slot Name Signature
0 7 0 this Lorg/hsqldb/test/TestCacheSize;
0 7 1 description Ljava/lang/String;
0 7 2 count I
0 7 3 time J
0 7 5 rate J
Exception table:
from to target type
0 4 5 Class java.lang.Exception
MethodParameters:
Name Flags
description
count
time
rate
static void deleteDatabase(java.lang.String);
descriptor: (Ljava/lang/String;)V
flags: (0x0008) ACC_STATIC
Code:
stack=4, locals=2, args_size=1
start local 0 0: invokestatic org.hsqldb.lib.FileUtil.getFileUtil:()Lorg/hsqldb/lib/FileUtil;
astore 1
start local 1 1: aload 1
new java.lang.StringBuilder
dup
aload 0
invokestatic java.lang.String.valueOf:(Ljava/lang/Object;)Ljava/lang/String;
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
ldc ".backup"
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
invokevirtual org.hsqldb.lib.FileUtil.delete:(Ljava/lang/String;)Z
pop
2: aload 1
new java.lang.StringBuilder
dup
aload 0
invokestatic java.lang.String.valueOf:(Ljava/lang/Object;)Ljava/lang/String;
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
ldc ".properties"
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
invokevirtual org.hsqldb.lib.FileUtil.delete:(Ljava/lang/String;)Z
pop
3: aload 1
new java.lang.StringBuilder
dup
aload 0
invokestatic java.lang.String.valueOf:(Ljava/lang/Object;)Ljava/lang/String;
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
ldc ".script"
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
invokevirtual org.hsqldb.lib.FileUtil.delete:(Ljava/lang/String;)Z
pop
4: aload 1
new java.lang.StringBuilder
dup
aload 0
invokestatic java.lang.String.valueOf:(Ljava/lang/Object;)Ljava/lang/String;
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
ldc ".data"
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
invokevirtual org.hsqldb.lib.FileUtil.delete:(Ljava/lang/String;)Z
pop
5: aload 1
new java.lang.StringBuilder
dup
aload 0
invokestatic java.lang.String.valueOf:(Ljava/lang/Object;)Ljava/lang/String;
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
ldc ".log"
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
invokevirtual org.hsqldb.lib.FileUtil.delete:(Ljava/lang/String;)Z
pop
6: aload 1
new java.lang.StringBuilder
dup
aload 0
invokestatic java.lang.String.valueOf:(Ljava/lang/Object;)Ljava/lang/String;
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
ldc ".lck"
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
invokevirtual org.hsqldb.lib.FileUtil.delete:(Ljava/lang/String;)Z
pop
7: aload 1
new java.lang.StringBuilder
dup
aload 0
invokestatic java.lang.String.valueOf:(Ljava/lang/Object;)Ljava/lang/String;
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
ldc ".csv"
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
invokevirtual org.hsqldb.lib.FileUtil.delete:(Ljava/lang/String;)Z
pop
8: return
end local 1 end local 0 LocalVariableTable:
Start End Slot Name Signature
0 9 0 path Ljava/lang/String;
1 9 1 fileUtil Lorg/hsqldb/lib/FileUtil;
MethodParameters:
Name Flags
path
int nextIntRandom(java.util.Random, int);
descriptor: (Ljava/util/Random;I)I
flags: (0x0000)
Code:
stack=2, locals=4, args_size=3
start local 0 start local 1 start local 2 0: aload 1
invokevirtual java.util.Random.nextInt:()I
istore 3
start local 3 1: iload 3
ldc -2147483648
if_icmpne 3
2: ldc 2147483647
istore 3
3: StackMap locals: int
StackMap stack:
iload 3
invokestatic java.lang.Math.abs:(I)I
istore 3
4: iload 3
iload 2
irem
ireturn
end local 3 end local 2 end local 1 end local 0 LocalVariableTable:
Start End Slot Name Signature
0 5 0 this Lorg/hsqldb/test/TestCacheSize;
0 5 1 r Ljava/util/Random;
0 5 2 range I
1 5 3 b I
MethodParameters:
Name Flags
r
range
public static void main(java.lang.String[]);
descriptor: ([Ljava/lang/String;)V
flags: (0x0009) ACC_PUBLIC, ACC_STATIC
Code:
stack=7, locals=6, args_size=1
start local 0 0: new org.hsqldb.test.TestCacheSize
dup
invokespecial org.hsqldb.test.TestCacheSize.<init>:()V
astore 1
start local 1 1: aload 0
ldc "test"
invokestatic org.hsqldb.persist.HsqlProperties.argArrayToProps:([Ljava/lang/String;Ljava/lang/String;)Lorg/hsqldb/persist/HsqlProperties;
astore 2
start local 2 2: aload 1
aload 2
ldc "test.bigops"
aload 1
getfield org.hsqldb.test.TestCacheSize.bigops:I
invokevirtual org.hsqldb.persist.HsqlProperties.getIntegerProperty:(Ljava/lang/String;I)I
putfield org.hsqldb.test.TestCacheSize.bigops:I
3: aload 1
aload 1
getfield org.hsqldb.test.TestCacheSize.bigops:I
putfield org.hsqldb.test.TestCacheSize.bigrows:I
4: aload 1
aload 1
getfield org.hsqldb.test.TestCacheSize.bigops:I
bipush 8
idiv
putfield org.hsqldb.test.TestCacheSize.smallops:I
5: aload 1
aload 2
ldc "test.scale"
6: aload 1
getfield org.hsqldb.test.TestCacheSize.cacheScale:I
7: invokevirtual org.hsqldb.persist.HsqlProperties.getIntegerProperty:(Ljava/lang/String;I)I
putfield org.hsqldb.test.TestCacheSize.cacheScale:I
8: aload 1
aload 2
ldc "test.tabletype"
aload 1
getfield org.hsqldb.test.TestCacheSize.tableType:Ljava/lang/String;
invokevirtual org.hsqldb.persist.HsqlProperties.getProperty:(Ljava/lang/String;Ljava/lang/String;)Ljava/lang/String;
putfield org.hsqldb.test.TestCacheSize.tableType:Ljava/lang/String;
9: aload 1
aload 2
ldc "test.nio"
aload 1
getfield org.hsqldb.test.TestCacheSize.nioMode:Z
invokevirtual org.hsqldb.persist.HsqlProperties.isPropertyTrue:(Ljava/lang/String;Z)Z
putfield org.hsqldb.test.TestCacheSize.nioMode:Z
10: aload 2
ldc "test.dbtype"
ldc ""
invokevirtual org.hsqldb.persist.HsqlProperties.getProperty:(Ljava/lang/String;Ljava/lang/String;)Ljava/lang/String;
ldc "mem"
invokevirtual java.lang.String.equals:(Ljava/lang/Object;)Z
ifeq 14
11: aload 1
ldc "mem:test"
putfield org.hsqldb.test.TestCacheSize.filepath:Ljava/lang/String;
12: aload 1
iconst_0
putfield org.hsqldb.test.TestCacheSize.filedb:Z
13: aload 1
iconst_0
putfield org.hsqldb.test.TestCacheSize.shutdown:Z
14: StackMap locals: org.hsqldb.test.TestCacheSize org.hsqldb.persist.HsqlProperties
StackMap stack:
aload 1
invokevirtual org.hsqldb.test.TestCacheSize.setUp:()V
15: new org.hsqldb.lib.StopWatch
dup
invokespecial org.hsqldb.lib.StopWatch.<init>:()V
astore 3
start local 3 16: aload 1
invokevirtual org.hsqldb.test.TestCacheSize.testFillUp:()V
17: aload 1
invokevirtual org.hsqldb.test.TestCacheSize.checkResults:()V
18: aload 3
invokevirtual org.hsqldb.lib.StopWatch.elapsedTime:()J
lstore 4
start local 4 19: aload 1
ldc "total test time"
iconst_0
lload 4
l2i
i2l
lconst_0
invokevirtual org.hsqldb.test.TestCacheSize.storeResult:(Ljava/lang/String;IJJ)V
20: getstatic java.lang.System.out:Ljava/io/PrintStream;
new java.lang.StringBuilder
dup
ldc "total test time -- "
invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
aload 3
invokevirtual org.hsqldb.lib.StopWatch.elapsedTime:()J
invokevirtual java.lang.StringBuilder.append:(J)Ljava/lang/StringBuilder;
ldc " ms"
invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
21: aload 1
invokevirtual org.hsqldb.test.TestCacheSize.tearDown:()V
22: return
end local 4 end local 3 end local 2 end local 1 end local 0 LocalVariableTable:
Start End Slot Name Signature
0 23 0 argv [Ljava/lang/String;
1 23 1 test Lorg/hsqldb/test/TestCacheSize;
2 23 2 props Lorg/hsqldb/persist/HsqlProperties;
16 23 3 sw Lorg/hsqldb/lib/StopWatch;
19 23 4 time J
MethodParameters:
Name Flags
argv
}
SourceFile: "TestCacheSize.java"