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 // org.hsqldb.test.TestCacheSize this
         0: .line 70
            aload 0 /* this */
            invokespecial java.lang.Object.<init>:()V
         1: .line 73
            aload 0 /* this */
            iconst_1
            putfield org.hsqldb.test.TestCacheSize.filedb:Z
         2: .line 76
            aload 0 /* this */
            iconst_1
            putfield org.hsqldb.test.TestCacheSize.shutdown:Z
         3: .line 79
            aload 0 /* this */
            ldc "jdbc:hsqldb:"
            putfield org.hsqldb.test.TestCacheSize.url:Ljava/lang/String;
         4: .line 83
            aload 0 /* this */
            ldc "/hsql/testcache/test"
            putfield org.hsqldb.test.TestCacheSize.filepath:Ljava/lang/String;
         5: .line 86
            aload 0 /* this */
            iconst_1
            putfield org.hsqldb.test.TestCacheSize.reportProgress:Z
         6: .line 89
            aload 0 /* this */
            ldc "CACHED"
            putfield org.hsqldb.test.TestCacheSize.tableType:Ljava/lang/String;
         7: .line 90
            aload 0 /* this */
            bipush 14
            putfield org.hsqldb.test.TestCacheSize.cacheScale:I
         8: .line 91
            aload 0 /* this */
            bipush 10
            putfield org.hsqldb.test.TestCacheSize.cacheSizeScale:I
         9: .line 92
            aload 0 /* this */
            iconst_1
            putfield org.hsqldb.test.TestCacheSize.nioMode:Z
        10: .line 93
            aload 0 /* this */
            bipush 60
            putfield org.hsqldb.test.TestCacheSize.writeDelay:I
        11: .line 94
            aload 0 /* this */
            iconst_0
            putfield org.hsqldb.test.TestCacheSize.indexZip:Z
        12: .line 95
            aload 0 /* this */
            iconst_0
            putfield org.hsqldb.test.TestCacheSize.indexLastName:Z
        13: .line 96
            aload 0 /* this */
            iconst_0
            putfield org.hsqldb.test.TestCacheSize.addForeignKey:Z
        14: .line 97
            aload 0 /* this */
            iconst_1
            putfield org.hsqldb.test.TestCacheSize.refIntegrity:Z
        15: .line 100
            aload 0 /* this */
            iconst_0
            putfield org.hsqldb.test.TestCacheSize.createTempTable:Z
        16: .line 103
            aload 0 /* this */
            iconst_0
            putfield org.hsqldb.test.TestCacheSize.deleteWhileInsert:Z
        17: .line 104
            aload 0 /* this */
            sipush 10000
            putfield org.hsqldb.test.TestCacheSize.deleteWhileInsertInterval:I
        18: .line 107
            aload 0 /* this */
            ldc 1024000
            putfield org.hsqldb.test.TestCacheSize.bigrows:I
        19: .line 110
            aload 0 /* this */
            ldc 1024000
            putfield org.hsqldb.test.TestCacheSize.bigops:I
        20: .line 111
            aload 0 /* this */
            sipush 32000
            putfield org.hsqldb.test.TestCacheSize.smallops:I
        21: .line 112
            aload 0 /* this */
            sipush 4095
            putfield org.hsqldb.test.TestCacheSize.smallrows:I
        22: .line 115
            aload 0 /* this */
            iconst_0
            putfield org.hsqldb.test.TestCacheSize.multikeytable:Z
        23: .line 125
            aload 0 /* this */
            ldc "ABCDEFGHIJKLMNOPQRSTUVWXYZABCDEFGHIJKLMNOPQRSTUVWXYZABCDEFGHIJKLMNOPQRSTUVWXYZABCDEFGHIJKLMNOPQRSTUVWXYZ"
            putfield org.hsqldb.test.TestCacheSize.filler:Ljava/lang/String;
        24: .line 70
            return
        end local 0 // org.hsqldb.test.TestCacheSize this
      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 // org.hsqldb.test.TestCacheSize this
         0: .line 130
            aload 0 /* this */
            invokevirtual org.hsqldb.test.TestCacheSize.countTestID:()V
         1: .line 131
            aload 0 /* this */
            invokevirtual org.hsqldb.test.TestCacheSize.selectID:()V
         2: .line 134
            return
        end local 0 // org.hsqldb.test.TestCacheSize this
      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 // org.hsqldb.test.TestCacheSize this
         0: .line 140
            aload 0 /* this */
            invokevirtual org.hsqldb.test.TestCacheSize.updateTestString:()V
         1: .line 141
            aload 0 /* this */
            invokevirtual org.hsqldb.test.TestCacheSize.countTestID:()V
         2: .line 142
            aload 0 /* this */
            invokevirtual org.hsqldb.test.TestCacheSize.deleteTest:()V
         3: .line 143
            aload 0 /* this */
            invokevirtual org.hsqldb.test.TestCacheSize.countTestID:()V
         4: .line 144
            aload 0 /* this */
            invokevirtual org.hsqldb.test.TestCacheSize.countZip:()V
         5: .line 145
            return
        end local 0 // org.hsqldb.test.TestCacheSize this
      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 // org.hsqldb.test.TestCacheSize this
         0: .line 150
            aload 0 /* this */
            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: .line 152
            aload 0 /* this */
            getfield org.hsqldb.test.TestCacheSize.writer:Ljava/io/FileWriter;
            ldc "<table>\n"
            invokevirtual java.io.FileWriter.write:(Ljava/lang/String;)V
         2: .line 153
            aload 0 /* this */
            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: .line 154
            aload 0 /* this */
            new java.lang.StringBuilder
            dup
            aload 0 /* this */
            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 /* this */
            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 /* this */
            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: .line 155
            aload 0 /* this */
            getfield org.hsqldb.test.TestCacheSize.cacheScale:I
            lconst_0
            lconst_0
         5: .line 154
            invokevirtual org.hsqldb.test.TestCacheSize.storeResult:(Ljava/lang/String;IJJ)V
         6: .line 156
            goto 8
      StackMap locals:
      StackMap stack: java.lang.Exception
         7: pop
         8: .line 158
      StackMap locals:
      StackMap stack:
            aload 0 /* this */
            ldc "sa"
            putfield org.hsqldb.test.TestCacheSize.user:Ljava/lang/String;
         9: .line 159
            aload 0 /* this */
            ldc ""
            putfield org.hsqldb.test.TestCacheSize.password:Ljava/lang/String;
        10: .line 162
            aload 0 /* this */
            aconst_null
            putfield org.hsqldb.test.TestCacheSize.sStatement:Ljava/sql/Statement;
        11: .line 163
            aload 0 /* this */
            aconst_null
            putfield org.hsqldb.test.TestCacheSize.cConnection:Ljava/sql/Connection;
        12: .line 165
            ldc "org.hsqldb.jdbc.JDBCDriver"
            invokestatic java.lang.Class.forName:(Ljava/lang/String;)Ljava/lang/Class;
            pop
        13: .line 167
            aload 0 /* this */
            getfield org.hsqldb.test.TestCacheSize.filedb:Z
            ifeq 34
        14: .line 168
            aload 0 /* this */
            getfield org.hsqldb.test.TestCacheSize.filepath:Ljava/lang/String;
            invokestatic org.hsqldb.test.TestCacheSize.deleteDatabase:(Ljava/lang/String;)V
        15: .line 170
            aload 0 /* this */
            new java.lang.StringBuilder
            dup
            aload 0 /* this */
            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 /* this */
            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: .line 171
            aload 0 /* this */
            getfield org.hsqldb.test.TestCacheSize.user:Ljava/lang/String;
            aload 0 /* this */
            getfield org.hsqldb.test.TestCacheSize.password:Ljava/lang/String;
        17: .line 170
            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: .line 172
            aload 0 /* this */
            aload 0 /* this */
            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: .line 175
            aload 0 /* this */
            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: .line 176
            aload 0 /* this */
            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: .line 179
            aload 0 /* this */
            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: .line 181
            iconst_1
            aload 0 /* this */
            getfield org.hsqldb.test.TestCacheSize.cacheScale:I
            ishl
            iconst_3
            imul
            istore 1 /* cacheRows */
        start local 1 // int cacheRows
        23: .line 182
            iconst_1
            aload 0 /* this */
            getfield org.hsqldb.test.TestCacheSize.cacheSizeScale:I
            ishl
            iload 1 /* cacheRows */
            imul
            sipush 1024
            idiv
            istore 2 /* cacheSize */
        start local 2 // int cacheSize
        24: .line 184
            aload 0 /* this */
            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 /* cacheRows */
            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: .line 185
            aload 0 /* this */
            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 /* cacheSize */
            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: .line 186
            aload 0 /* this */
            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 /* this */
            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: .line 187
            aload 0 /* this */
            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: .line 188
            aload 0 /* this */
            getfield org.hsqldb.test.TestCacheSize.sStatement:Ljava/sql/Statement;
            ldc "SHUTDOWN"
            invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
            pop
        29: .line 189
            aload 0 /* this */
            getfield org.hsqldb.test.TestCacheSize.cConnection:Ljava/sql/Connection;
            invokeinterface java.sql.Connection.close:()V
        end local 2 // int cacheSize
        end local 1 // int cacheRows
        30: .line 191
            goto 34
      StackMap locals:
      StackMap stack: java.lang.Exception
        31: astore 1 /* e */
        start local 1 // java.lang.Exception e
        32: .line 192
            aload 1 /* e */
            invokevirtual java.lang.Exception.printStackTrace:()V
        33: .line 193
            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 /* e */
            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 // java.lang.Exception e
        34: .line 195
      StackMap locals:
      StackMap stack:
            return
        end local 0 // org.hsqldb.test.TestCacheSize this
      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 // org.hsqldb.test.TestCacheSize this
         0: .line 204
            new org.hsqldb.lib.StopWatch
            dup
            invokespecial org.hsqldb.lib.StopWatch.<init>:()V
            astore 1 /* sw */
        start local 1 // org.hsqldb.lib.StopWatch sw
         1: .line 205
            ldc "DROP TABLE test IF EXISTS"
            astore 2 /* ddl1 */
        start local 2 // java.lang.String ddl1
         2: .line 207
            ldc "CREATE TABLE zip( zip INT IDENTITY )"
            astore 3 /* ddl2 */
        start local 3 // java.lang.String ddl2
         3: .line 208
            new java.lang.StringBuilder
            dup
            ldc "CREATE "
            invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
            aload 0 /* this */
            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: .line 209
            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: .line 210
            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: .line 208
            invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
            astore 4 /* ddl3 */
        start local 4 // java.lang.String ddl3
         7: .line 211
            new java.lang.StringBuilder
            dup
            ldc "SET TABLE test SOURCE \"test.csv;cache_scale="
            invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
         8: .line 212
            aload 0 /* this */
            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: .line 211
            invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
            astore 5 /* ddl31 */
        start local 5 // java.lang.String ddl31
        10: .line 215
            ldc "CREATE INDEX idx1 ON TEST (lastname)"
            astore 6 /* ddl4 */
        start local 6 // java.lang.String ddl4
        11: .line 218
            ldc "CREATE INDEX idx2 ON TEST (zip)"
            astore 7 /* ddl5 */
        start local 7 // java.lang.String ddl5
        12: .line 222
            ldc "ALTER TABLE test add constraint c1 FOREIGN KEY (zip) REFERENCES zip(zip) ON DELETE CASCADE;"
        13: .line 221
            astore 8 /* ddl6 */
        start local 8 // java.lang.String ddl6
        14: .line 223
            ldc "CREATE TEMP TABLE temptest( id INT, firstname VARCHAR,  lastname VARCHAR,  zip INTEGER,  filler VARCHAR)"
            astore 9 /* ddl7 */
        start local 9 // java.lang.String ddl7
        15: .line 226
            ldc "DROP TABLE test2 IF EXISTS"
            astore 10 /* mddl1 */
        start local 10 // java.lang.String mddl1
        16: .line 227
            new java.lang.StringBuilder
            dup
            ldc "CREATE "
            invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
            aload 0 /* this */
            getfield org.hsqldb.test.TestCacheSize.tableType:Ljava/lang/String;
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
        17: .line 228
            ldc " TABLE test2( id1 INT, id2 INT,"
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
        18: .line 229
            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: .line 230
            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: .line 231
            ldc " PRIMARY KEY (id1,id2) )"
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
        21: .line 227
            invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
            astore 11 /* mddl2 */
        start local 11 // java.lang.String mddl2
        22: .line 232
            new java.lang.StringBuilder
            dup
            ldc "SET TABLE test2 SOURCE \"test2.csv;cache_scale="
            invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
        23: .line 233
            aload 0 /* this */
            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: .line 232
            invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
            astore 12 /* mdd13 */
        start local 12 // java.lang.String mdd13
        25: .line 238
            aload 1 /* sw */
            invokevirtual org.hsqldb.lib.StopWatch.zero:()V
        26: .line 240
            aload 0 /* this */
            aconst_null
            putfield org.hsqldb.test.TestCacheSize.cConnection:Ljava/sql/Connection;
        27: .line 241
            aload 0 /* this */
            aconst_null
            putfield org.hsqldb.test.TestCacheSize.sStatement:Ljava/sql/Statement;
        28: .line 242
            aload 0 /* this */
            new java.lang.StringBuilder
            dup
            aload 0 /* this */
            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 /* this */
            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 /* this */
            getfield org.hsqldb.test.TestCacheSize.user:Ljava/lang/String;
        29: .line 243
            aload 0 /* this */
            getfield org.hsqldb.test.TestCacheSize.password:Ljava/lang/String;
        30: .line 242
            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: .line 245
            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 /* sw */
            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: .line 246
            aload 1 /* sw */
            invokevirtual org.hsqldb.lib.StopWatch.zero:()V
        33: .line 248
            aload 0 /* this */
            aload 0 /* this */
            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: .line 250
            new java.util.Random
            dup
            invokespecial java.util.Random.<init>:()V
            astore 13 /* randomgen */
        start local 13 // java.util.Random randomgen
        35: .line 253
            aload 0 /* this */
            getfield org.hsqldb.test.TestCacheSize.sStatement:Ljava/sql/Statement;
            aload 2 /* ddl1 */
            invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
            pop
        36: .line 254
            aload 0 /* this */
            getfield org.hsqldb.test.TestCacheSize.sStatement:Ljava/sql/Statement;
            aload 3 /* ddl2 */
            invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
            pop
        37: .line 255
            aload 0 /* this */
            getfield org.hsqldb.test.TestCacheSize.sStatement:Ljava/sql/Statement;
            aload 4 /* ddl3 */
            invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
            pop
        38: .line 257
            aload 0 /* this */
            getfield org.hsqldb.test.TestCacheSize.tableType:Ljava/lang/String;
            ldc "TEXT"
            invokevirtual java.lang.String.equals:(Ljava/lang/Object;)Z
            ifeq 40
        39: .line 258
            aload 0 /* this */
            getfield org.hsqldb.test.TestCacheSize.sStatement:Ljava/sql/Statement;
            aload 5 /* ddl31 */
            invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
            pop
        40: .line 262
      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 /* this */
            getfield org.hsqldb.test.TestCacheSize.indexLastName:Z
            ifeq 43
        41: .line 263
            aload 0 /* this */
            getfield org.hsqldb.test.TestCacheSize.sStatement:Ljava/sql/Statement;
            aload 6 /* ddl4 */
            invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
            pop
        42: .line 264
            getstatic java.lang.System.out:Ljava/io/PrintStream;
            ldc "created index on lastname"
            invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
        43: .line 267
      StackMap locals:
      StackMap stack:
            aload 0 /* this */
            getfield org.hsqldb.test.TestCacheSize.indexZip:Z
            ifeq 46
        44: .line 268
            aload 0 /* this */
            getfield org.hsqldb.test.TestCacheSize.sStatement:Ljava/sql/Statement;
            aload 7 /* ddl5 */
            invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
            pop
        45: .line 269
            getstatic java.lang.System.out:Ljava/io/PrintStream;
            ldc "created index on zip"
            invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
        46: .line 272
      StackMap locals:
      StackMap stack:
            aload 0 /* this */
            getfield org.hsqldb.test.TestCacheSize.addForeignKey:Z
            ifeq 49
        47: .line 273
            aload 0 /* this */
            getfield org.hsqldb.test.TestCacheSize.sStatement:Ljava/sql/Statement;
            aload 8 /* ddl6 */
            invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
            pop
        48: .line 274
            getstatic java.lang.System.out:Ljava/io/PrintStream;
            ldc "added foreign key"
            invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
        49: .line 277
      StackMap locals:
      StackMap stack:
            aload 0 /* this */
            getfield org.hsqldb.test.TestCacheSize.createTempTable:Z
            ifeq 52
        50: .line 278
            aload 0 /* this */
            getfield org.hsqldb.test.TestCacheSize.sStatement:Ljava/sql/Statement;
            aload 9 /* ddl7 */
            invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
            pop
        51: .line 279
            getstatic java.lang.System.out:Ljava/io/PrintStream;
            ldc "created temp table"
            invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
        52: .line 282
      StackMap locals:
      StackMap stack:
            aload 0 /* this */
            getfield org.hsqldb.test.TestCacheSize.multikeytable:Z
            ifeq 58
        53: .line 283
            aload 0 /* this */
            getfield org.hsqldb.test.TestCacheSize.sStatement:Ljava/sql/Statement;
            aload 10 /* mddl1 */
            invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
            pop
        54: .line 284
            aload 0 /* this */
            getfield org.hsqldb.test.TestCacheSize.sStatement:Ljava/sql/Statement;
            aload 11 /* mddl2 */
            invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
            pop
        55: .line 286
            aload 0 /* this */
            getfield org.hsqldb.test.TestCacheSize.tableType:Ljava/lang/String;
            ldc "TEXT"
            invokevirtual java.lang.String.equals:(Ljava/lang/Object;)Z
            ifeq 57
        56: .line 287
            aload 0 /* this */
            getfield org.hsqldb.test.TestCacheSize.sStatement:Ljava/sql/Statement;
            aload 12 /* mdd13 */
            invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
            pop
        57: .line 290
      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: .line 294
      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 /* sw */
            invokevirtual org.hsqldb.lib.StopWatch.elapsedTime:()J
            invokevirtual java.lang.StringBuilder.append:(J)Ljava/lang/StringBuilder;
        59: .line 295
            ldc " ms"
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
            invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
        60: .line 294
            invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
        61: .line 296
            aload 0 /* this */
            aload 0 /* this */
            getfield org.hsqldb.test.TestCacheSize.filler:Ljava/lang/String;
            aload 13 /* randomgen */
            invokevirtual org.hsqldb.test.TestCacheSize.fillUpBigTable:(Ljava/lang/String;Ljava/util/Random;)V
        62: .line 298
            aload 0 /* this */
            getfield org.hsqldb.test.TestCacheSize.multikeytable:Z
            ifeq 64
        63: .line 299
            aload 0 /* this */
            aload 0 /* this */
            getfield org.hsqldb.test.TestCacheSize.filler:Ljava/lang/String;
            aload 13 /* randomgen */
            invokevirtual org.hsqldb.test.TestCacheSize.fillUpMultiTable:(Ljava/lang/String;Ljava/util/Random;)V
        64: .line 302
      StackMap locals:
      StackMap stack:
            aload 1 /* sw */
            invokevirtual org.hsqldb.lib.StopWatch.zero:()V
        65: .line 304
            aload 0 /* this */
            getfield org.hsqldb.test.TestCacheSize.shutdown:Z
            ifeq 70
        66: .line 305
            aload 0 /* this */
            getfield org.hsqldb.test.TestCacheSize.sStatement:Ljava/sql/Statement;
            ldc "SHUTDOWN"
            invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
            pop
        67: .line 307
            aload 1 /* sw */
            invokevirtual org.hsqldb.lib.StopWatch.elapsedTime:()J
            lstore 14 /* time */
        start local 14 // long time
        68: .line 309
            aload 0 /* this */
            ldc "shutdown"
            iconst_0
            lload 14 /* time */
            lconst_0
            invokevirtual org.hsqldb.test.TestCacheSize.storeResult:(Ljava/lang/String;IJJ)V
        69: .line 310
            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 /* time */
            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 // long time
        70: .line 313
      StackMap locals:
      StackMap stack:
            aload 0 /* this */
            getfield org.hsqldb.test.TestCacheSize.cConnection:Ljava/sql/Connection;
            invokeinterface java.sql.Connection.close:()V
        end local 13 // java.util.Random randomgen
        71: .line 314
            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 /* e */
        start local 13 // java.sql.SQLException e
        73: .line 315
            getstatic java.lang.System.out:Ljava/io/PrintStream;
            aload 13 /* e */
            invokevirtual java.sql.SQLException.getMessage:()Ljava/lang/String;
            invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
        end local 13 // java.sql.SQLException e
        74: .line 317
      StackMap locals:
      StackMap stack:
            return
        end local 12 // java.lang.String mdd13
        end local 11 // java.lang.String mddl2
        end local 10 // java.lang.String mddl1
        end local 9 // java.lang.String ddl7
        end local 8 // java.lang.String ddl6
        end local 7 // java.lang.String ddl5
        end local 6 // java.lang.String ddl4
        end local 5 // java.lang.String ddl31
        end local 4 // java.lang.String ddl3
        end local 3 // java.lang.String ddl2
        end local 2 // java.lang.String ddl1
        end local 1 // org.hsqldb.lib.StopWatch sw
        end local 0 // org.hsqldb.test.TestCacheSize this
      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 // org.hsqldb.test.TestCacheSize this
        start local 1 // java.lang.String filler
        start local 2 // java.util.Random randomgen
         0: .line 322
            new org.hsqldb.lib.StopWatch
            dup
            invokespecial org.hsqldb.lib.StopWatch.<init>:()V
            astore 3 /* sw */
        start local 3 // org.hsqldb.lib.StopWatch sw
         1: .line 325
            aload 0 /* this */
            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: .line 324
            astore 5 /* ps */
        start local 5 // java.sql.PreparedStatement ps
         3: .line 327
            iconst_0
            istore 4 /* i */
        start local 4 // int i
         4: goto 8
         5: .line 328
      StackMap locals: org.hsqldb.lib.StopWatch int java.sql.PreparedStatement
      StackMap stack:
            aload 5 /* ps */
            iconst_1
            iload 4 /* i */
            invokeinterface java.sql.PreparedStatement.setInt:(II)V
         6: .line 329
            aload 5 /* ps */
            invokeinterface java.sql.PreparedStatement.execute:()Z
            pop
         7: .line 327
            iinc 4 /* i */ 1
      StackMap locals:
      StackMap stack:
         8: iload 4 /* i */
            aload 0 /* this */
            getfield org.hsqldb.test.TestCacheSize.smallrows:I
            if_icmple 5
         9: .line 332
            aload 5 /* ps */
            invokeinterface java.sql.PreparedStatement.close:()V
        10: .line 333
            aload 0 /* this */
            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: .line 334
            aload 0 /* this */
            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: .line 333
            invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
            pop
        13: .line 336
            aload 0 /* this */
            getfield org.hsqldb.test.TestCacheSize.cConnection:Ljava/sql/Connection;
        14: .line 337
            ldc "INSERT INTO test (firstname,lastname,zip,filler) VALUES (?,?,?,?)"
        15: .line 336
            invokeinterface java.sql.Connection.prepareStatement:(Ljava/lang/String;)Ljava/sql/PreparedStatement;
            astore 5 /* ps */
        16: .line 339
            aload 5 /* ps */
            iconst_1
            ldc "Julia"
            invokeinterface java.sql.PreparedStatement.setString:(ILjava/lang/String;)V
        17: .line 340
            aload 5 /* ps */
            iconst_2
            ldc "Clancy"
            invokeinterface java.sql.PreparedStatement.setString:(ILjava/lang/String;)V
        18: .line 342
            iconst_0
            istore 4 /* i */
            goto 48
        19: .line 343
      StackMap locals:
      StackMap stack:
            aload 5 /* ps */
            iconst_3
            aload 0 /* this */
            aload 2 /* randomgen */
            aload 0 /* this */
            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: .line 348
            aload 2 /* randomgen */
            invokevirtual java.util.Random.nextLong:()J
            lstore 6 /* nextrandom */
        start local 6 // long nextrandom
        21: .line 349
            lload 6 /* nextrandom */
            l2i
            bipush 127
            iand
            istore 8 /* randomlength */
        start local 8 // int randomlength
        22: .line 351
            iload 8 /* randomlength */
            aload 1 /* filler */
            invokevirtual java.lang.String.length:()I
            if_icmple 24
        23: .line 352
            aload 1 /* filler */
            invokevirtual java.lang.String.length:()I
            istore 8 /* randomlength */
        24: .line 355
      StackMap locals: long int
      StackMap stack:
            aload 1 /* filler */
            iconst_0
            iload 8 /* randomlength */
            invokevirtual java.lang.String.substring:(II)Ljava/lang/String;
            astore 9 /* varfiller */
        start local 9 // java.lang.String varfiller
        25: .line 357
            aload 5 /* ps */
            iconst_4
            new java.lang.StringBuilder
            dup
            lload 6 /* nextrandom */
            invokestatic java.lang.String.valueOf:(J)Ljava/lang/String;
            invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
            aload 9 /* varfiller */
            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 // java.lang.String varfiller
        end local 8 // int randomlength
        end local 6 // long nextrandom
        26: .line 381
            aload 5 /* ps */
            invokeinterface java.sql.PreparedStatement.execute:()Z
            pop
        27: .line 383
            aload 0 /* this */
            getfield org.hsqldb.test.TestCacheSize.reportProgress:Z
            ifeq 31
            iload 4 /* i */
            iconst_1
            iadd
            sipush 10000
            irem
            ifne 31
        28: .line 384
            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 /* i */
            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: .line 385
            aload 3 /* sw */
            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: .line 384
            invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
        31: .line 389
      StackMap locals:
      StackMap stack:
            aload 0 /* this */
            getfield org.hsqldb.test.TestCacheSize.deleteWhileInsert:Z
            ifeq 47
            iload 4 /* i */
            ifeq 47
        32: .line 390
            iload 4 /* i */
            aload 0 /* this */
            getfield org.hsqldb.test.TestCacheSize.deleteWhileInsertInterval:I
            irem
            ifne 47
        33: .line 391
            aload 0 /* this */
            getfield org.hsqldb.test.TestCacheSize.sStatement:Ljava/sql/Statement;
            ldc "CALL IDENTITY();"
            invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
            pop
        34: .line 393
            aload 0 /* this */
            getfield org.hsqldb.test.TestCacheSize.sStatement:Ljava/sql/Statement;
            invokeinterface java.sql.Statement.getResultSet:()Ljava/sql/ResultSet;
            astore 6 /* rs */
        start local 6 // java.sql.ResultSet rs
        35: .line 395
            aload 6 /* rs */
            invokeinterface java.sql.ResultSet.next:()Z
            pop
        36: .line 397
            aload 6 /* rs */
            iconst_1
            invokeinterface java.sql.ResultSet.getInt:(I)I
            istore 7 /* lastId */
        start local 7 // int lastId
        37: .line 399
            aload 0 /* this */
            getfield org.hsqldb.test.TestCacheSize.sStatement:Ljava/sql/Statement;
        38: .line 400
            new java.lang.StringBuilder
            dup
            ldc "SELECT * INTO TEMP tempt FROM test WHERE id > "
            invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
        39: .line 401
            iload 7 /* lastId */
            sipush 4000
            isub
            invokevirtual java.lang.StringBuilder.append:(I)Ljava/lang/StringBuilder;
        40: .line 400
            invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
        41: .line 399
            invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
            pop
        42: .line 402
            aload 0 /* this */
            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: .line 403
            iload 7 /* lastId */
            sipush 4000
            isub
            invokevirtual java.lang.StringBuilder.append:(I)Ljava/lang/StringBuilder;
            invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
        44: .line 402
            invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
            pop
        45: .line 404
            aload 0 /* this */
            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: .line 405
            aload 0 /* this */
            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 // int lastId
        end local 6 // java.sql.ResultSet rs
        47: .line 342
      StackMap locals:
      StackMap stack:
            iinc 4 /* i */ 1
      StackMap locals:
      StackMap stack:
        48: iload 4 /* i */
            aload 0 /* this */
            getfield org.hsqldb.test.TestCacheSize.bigrows:I
            if_icmplt 19
        49: .line 409
            aload 5 /* ps */
            invokeinterface java.sql.PreparedStatement.close:()V
        50: .line 414
            aload 3 /* sw */
            invokevirtual org.hsqldb.lib.StopWatch.elapsedTime:()J
            lstore 6 /* time */
        start local 6 // long time
        51: .line 415
            iload 4 /* i */
            i2l
            ldc 1000
            lmul
            lload 6 /* time */
            lconst_1
            ladd
            ldiv
            lstore 8 /* rate */
        start local 8 // long rate
        52: .line 417
            aload 0 /* this */
            ldc "insert"
            iload 4 /* i */
            lload 6 /* time */
            lload 8 /* rate */
            invokevirtual org.hsqldb.test.TestCacheSize.storeResult:(Ljava/lang/String;IJJ)V
        53: .line 418
            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 /* i */
            invokevirtual java.lang.StringBuilder.append:(I)Ljava/lang/StringBuilder;
            ldc " rows -- "
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
            lload 6 /* time */
            invokevirtual java.lang.StringBuilder.append:(J)Ljava/lang/StringBuilder;
        54: .line 419
            ldc " ms -- "
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
            lload 8 /* rate */
            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: .line 418
            invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
        56: .line 420
            return
        end local 8 // long rate
        end local 6 // long time
        end local 5 // java.sql.PreparedStatement ps
        end local 4 // int i
        end local 3 // org.hsqldb.lib.StopWatch sw
        end local 2 // java.util.Random randomgen
        end local 1 // java.lang.String filler
        end local 0 // org.hsqldb.test.TestCacheSize this
      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 // org.hsqldb.test.TestCacheSize this
        start local 1 // java.lang.String filler
        start local 2 // java.util.Random randomgen
         0: .line 425
            new org.hsqldb.lib.StopWatch
            dup
            invokespecial org.hsqldb.lib.StopWatch.<init>:()V
            astore 3 /* sw */
        start local 3 // org.hsqldb.lib.StopWatch sw
         1: .line 427
            aload 0 /* this */
            getfield org.hsqldb.test.TestCacheSize.cConnection:Ljava/sql/Connection;
         2: .line 428
            ldc "INSERT INTO test2 (id1, id2, firstname,lastname,zip,filler) VALUES (?,?,?,?,?,?)"
         3: .line 427
            invokeinterface java.sql.Connection.prepareStatement:(Ljava/lang/String;)Ljava/sql/PreparedStatement;
            astore 5 /* ps */
        start local 5 // java.sql.PreparedStatement ps
         4: .line 430
            aload 5 /* ps */
            iconst_3
            ldc "Julia"
            invokeinterface java.sql.PreparedStatement.setString:(ILjava/lang/String;)V
         5: .line 431
            aload 5 /* ps */
            iconst_4
            ldc "Clancy"
            invokeinterface java.sql.PreparedStatement.setString:(ILjava/lang/String;)V
         6: .line 433
            iconst_0
            istore 6 /* id1 */
        start local 6 // int id1
         7: .line 435
            iconst_0
            istore 4 /* i */
        start local 4 // int i
         8: goto 30
         9: .line 436
      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 /* this */
            aload 2 /* randomgen */
            ldc 2147483647
            invokevirtual org.hsqldb.test.TestCacheSize.nextIntRandom:(Ljava/util/Random;I)I
            istore 7 /* id2 */
        start local 7 // int id2
        10: .line 438
            iload 4 /* i */
            sipush 1000
            irem
            ifne 12
        11: .line 439
            aload 0 /* this */
            aload 2 /* randomgen */
            ldc 2147483647
            invokevirtual org.hsqldb.test.TestCacheSize.nextIntRandom:(Ljava/util/Random;I)I
            istore 6 /* id1 */
        12: .line 442
      StackMap locals: int
      StackMap stack:
            aload 5 /* ps */
            iconst_1
            iload 6 /* id1 */
            invokeinterface java.sql.PreparedStatement.setInt:(II)V
        13: .line 443
            aload 5 /* ps */
            iconst_2
            iload 7 /* id2 */
            invokeinterface java.sql.PreparedStatement.setInt:(II)V
        14: .line 444
            aload 5 /* ps */
            iconst_5
            aload 0 /* this */
            aload 2 /* randomgen */
            aload 0 /* this */
            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: .line 446
            aload 2 /* randomgen */
            invokevirtual java.util.Random.nextLong:()J
            lstore 8 /* nextrandom */
        start local 8 // long nextrandom
        16: .line 447
            lload 8 /* nextrandom */
            l2i
            bipush 127
            iand
            istore 10 /* randomlength */
        start local 10 // int randomlength
        17: .line 449
            iload 10 /* randomlength */
            aload 1 /* filler */
            invokevirtual java.lang.String.length:()I
            if_icmple 19
        18: .line 450
            aload 1 /* filler */
            invokevirtual java.lang.String.length:()I
            istore 10 /* randomlength */
        19: .line 453
      StackMap locals: long int
      StackMap stack:
            aload 1 /* filler */
            iconst_0
            iload 10 /* randomlength */
            invokevirtual java.lang.String.substring:(II)Ljava/lang/String;
            astore 11 /* varfiller */
        start local 11 // java.lang.String varfiller
        20: .line 455
            aload 5 /* ps */
            bipush 6
            new java.lang.StringBuilder
            dup
            lload 8 /* nextrandom */
            invokestatic java.lang.String.valueOf:(J)Ljava/lang/String;
            invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
            aload 11 /* varfiller */
            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: .line 458
            aload 5 /* ps */
            invokeinterface java.sql.PreparedStatement.execute:()Z
            pop
        22: .line 459
            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 /* e */
        start local 12 // java.sql.SQLException e
        24: .line 460
            aload 12 /* e */
            invokevirtual java.sql.SQLException.printStackTrace:()V
        end local 12 // java.sql.SQLException e
        25: .line 463
      StackMap locals:
      StackMap stack:
            aload 0 /* this */
            getfield org.hsqldb.test.TestCacheSize.reportProgress:Z
            ifeq 29
            iload 4 /* i */
            iconst_1
            iadd
            sipush 10000
            irem
            ifne 29
        26: .line 464
            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 /* i */
            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: .line 465
            aload 3 /* sw */
            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: .line 464
            invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
        end local 11 // java.lang.String varfiller
        end local 10 // int randomlength
        end local 8 // long nextrandom
        end local 7 // int id2
        29: .line 435
      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 /* i */ 1
      StackMap locals:
      StackMap stack:
        30: iload 4 /* i */
            aload 0 /* this */
            getfield org.hsqldb.test.TestCacheSize.bigrows:I
            if_icmplt 9
        31: .line 469
            aload 5 /* ps */
            invokeinterface java.sql.PreparedStatement.close:()V
        32: .line 470
            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 /* i */
            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: .line 471
            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 /* sw */
            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: .line 472
            iload 4 /* i */
            sipush 1000
            imul
            i2l
            aload 3 /* sw */
            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: .line 471
            invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
        36: .line 473
            return
        end local 6 // int id1
        end local 5 // java.sql.PreparedStatement ps
        end local 4 // int i
        end local 3 // org.hsqldb.lib.StopWatch sw
        end local 2 // java.util.Random randomgen
        end local 1 // java.lang.String filler
        end local 0 // org.hsqldb.test.TestCacheSize this
      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 // org.hsqldb.test.TestCacheSize this
         0: .line 478
            aload 0 /* this */
            getfield org.hsqldb.test.TestCacheSize.writer:Ljava/io/FileWriter;
            ldc "\n</table>\n"
            invokevirtual java.io.FileWriter.write:(Ljava/lang/String;)V
         1: .line 479
            aload 0 /* this */
            getfield org.hsqldb.test.TestCacheSize.writer:Ljava/io/FileWriter;
            invokevirtual java.io.FileWriter.close:()V
         2: .line 480
            goto 4
      StackMap locals:
      StackMap stack: java.lang.Exception
         3: pop
         4: .line 481
      StackMap locals:
      StackMap stack:
            return
        end local 0 // org.hsqldb.test.TestCacheSize this
      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 // org.hsqldb.test.TestCacheSize this
         0: .line 486
            new org.hsqldb.lib.StopWatch
            dup
            invokespecial org.hsqldb.lib.StopWatch.<init>:()V
            astore 1 /* sw */
        start local 1 // org.hsqldb.lib.StopWatch sw
         1: .line 489
            aload 0 /* this */
            new java.lang.StringBuilder
            dup
            aload 0 /* this */
            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 /* this */
            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 /* this */
            getfield org.hsqldb.test.TestCacheSize.user:Ljava/lang/String;
         2: .line 490
            aload 0 /* this */
            getfield org.hsqldb.test.TestCacheSize.password:Ljava/lang/String;
         3: .line 489
            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: .line 492
            aload 1 /* sw */
            invokevirtual org.hsqldb.lib.StopWatch.elapsedTime:()J
            lstore 2 /* time */
        start local 2 // long time
         5: .line 494
            aload 0 /* this */
            ldc "reopen"
            iconst_0
            lload 2 /* time */
            lconst_0
            invokevirtual org.hsqldb.test.TestCacheSize.storeResult:(Ljava/lang/String;IJJ)V
         6: .line 495
            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 /* time */
            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: .line 496
            aload 1 /* sw */
            invokevirtual org.hsqldb.lib.StopWatch.zero:()V
         8: .line 498
            aload 0 /* this */
            aload 0 /* this */
            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: .line 501
            aload 0 /* this */
            invokevirtual org.hsqldb.test.TestCacheSize.checkSelects:()V
        10: .line 502
            aload 0 /* this */
            invokevirtual org.hsqldb.test.TestCacheSize.checkUpdates:()V
        11: .line 503
            aload 1 /* sw */
            invokevirtual org.hsqldb.lib.StopWatch.zero:()V
        12: .line 505
            aload 0 /* this */
            getfield org.hsqldb.test.TestCacheSize.shutdown:Z
            ifeq 17
        13: .line 506
            aload 0 /* this */
            getfield org.hsqldb.test.TestCacheSize.sStatement:Ljava/sql/Statement;
            ldc "SHUTDOWN"
            invokeinterface java.sql.Statement.execute:(Ljava/lang/String;)Z
            pop
        14: .line 508
            aload 1 /* sw */
            invokevirtual org.hsqldb.lib.StopWatch.elapsedTime:()J
            lstore 2 /* time */
        15: .line 510
            aload 0 /* this */
            ldc "shutdown"
            iconst_0
            lload 2 /* time */
            lconst_0
            invokevirtual org.hsqldb.test.TestCacheSize.storeResult:(Ljava/lang/String;IJJ)V
        16: .line 511
            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 /* time */
            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: .line 514
      StackMap locals: org.hsqldb.lib.StopWatch long
      StackMap stack:
            aload 0 /* this */
            getfield org.hsqldb.test.TestCacheSize.cConnection:Ljava/sql/Connection;
            invokeinterface java.sql.Connection.close:()V
        end local 2 // long time
        end local 1 // org.hsqldb.lib.StopWatch sw
        18: .line 517
            goto 21
      StackMap locals: org.hsqldb.test.TestCacheSize
      StackMap stack: java.sql.SQLException
        19: astore 1 /* e */
        start local 1 // java.sql.SQLException e
        20: .line 518
            aload 1 /* e */
            invokevirtual java.sql.SQLException.printStackTrace:()V
        end local 1 // java.sql.SQLException e
        21: .line 520
      StackMap locals:
      StackMap stack:
            return
        end local 0 // org.hsqldb.test.TestCacheSize this
      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 // org.hsqldb.test.TestCacheSize this
         0: .line 524
            new org.hsqldb.lib.StopWatch
            dup
            invokespecial org.hsqldb.lib.StopWatch.<init>:()V
            astore 1 /* sw */
        start local 1 // org.hsqldb.lib.StopWatch sw
         1: .line 525
            new java.util.Random
            dup
            invokespecial java.util.Random.<init>:()V
            astore 2 /* randomgen */
        start local 2 // java.util.Random randomgen
         2: .line 526
            iconst_0
            istore 3 /* i */
        start local 3 // int i
         3: .line 527
            iconst_0
            istore 4 /* slow */
        start local 4 // boolean slow
         4: .line 530
            aload 0 /* this */
            getfield org.hsqldb.test.TestCacheSize.cConnection:Ljava/sql/Connection;
         5: .line 531
            ldc "SELECT TOP 1 firstname,lastname,zip,filler FROM test WHERE zip = ?"
         6: .line 530
            invokeinterface java.sql.Connection.prepareStatement:(Ljava/lang/String;)Ljava/sql/PreparedStatement;
            astore 5 /* ps */
        start local 5 // java.sql.PreparedStatement ps
         7: .line 533
            goto 19
         8: .line 534
      StackMap locals: org.hsqldb.test.TestCacheSize org.hsqldb.lib.StopWatch java.util.Random int int java.sql.PreparedStatement
      StackMap stack:
            aload 5 /* ps */
            iconst_1
            aload 0 /* this */
            aload 2 /* randomgen */
            aload 0 /* this */
            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: .line 535
            aload 5 /* ps */
            invokeinterface java.sql.PreparedStatement.execute:()Z
            pop
        10: .line 537
            iload 3 /* i */
            iconst_1
            iadd
            bipush 100
            if_icmpne 12
            aload 1 /* sw */
            invokevirtual org.hsqldb.lib.StopWatch.elapsedTime:()J
            ldc 50000
            lcmp
            ifle 12
        11: .line 538
            iconst_1
            istore 4 /* slow */
        12: .line 541
      StackMap locals:
      StackMap stack:
            aload 0 /* this */
            getfield org.hsqldb.test.TestCacheSize.reportProgress:Z
            ifeq 13
            iload 3 /* i */
            iconst_1
            iadd
            sipush 10000
            irem
            ifeq 14
        13: .line 542
      StackMap locals:
      StackMap stack:
            iload 4 /* slow */
            ifeq 18
            iload 3 /* i */
            iconst_1
            iadd
            bipush 100
            irem
            ifne 18
        14: .line 543
      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 /* i */
            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: .line 544
            aload 1 /* sw */
            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: .line 545
            iload 3 /* i */
            sipush 1000
            imul
            i2l
            aload 1 /* sw */
            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: .line 543
            invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
        18: .line 533
      StackMap locals:
      StackMap stack:
            iinc 3 /* i */ 1
      StackMap locals:
      StackMap stack:
        19: iload 3 /* i */
            aload 0 /* this */
            getfield org.hsqldb.test.TestCacheSize.bigops:I
            if_icmplt 8
        end local 5 // java.sql.PreparedStatement ps
        20: .line 548
            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 /* e */
        start local 5 // java.sql.SQLException e
        22: .line 549
            aload 5 /* e */
            invokevirtual java.sql.SQLException.printStackTrace:()V
        end local 5 // java.sql.SQLException e
        23: .line 552
      StackMap locals:
      StackMap stack:
            aload 1 /* sw */
            invokevirtual org.hsqldb.lib.StopWatch.elapsedTime:()J
            lstore 5 /* time */
        start local 5 // long time
        24: .line 553
            iload 3 /* i */
            i2l
            ldc 1000
            lmul
            lload 5 /* time */
            lconst_1
            ladd
            ldiv
            lstore 7 /* rate */
        start local 7 // long rate
        25: .line 555
            aload 0 /* this */
            ldc "select random zip"
            iload 3 /* i */
            lload 5 /* time */
            lload 7 /* rate */
            invokevirtual org.hsqldb.test.TestCacheSize.storeResult:(Ljava/lang/String;IJJ)V
        26: .line 556
            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 /* i */
            invokevirtual java.lang.StringBuilder.append:(I)Ljava/lang/StringBuilder;
            ldc " rows  -- "
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
        27: .line 557
            lload 5 /* time */
            invokevirtual java.lang.StringBuilder.append:(J)Ljava/lang/StringBuilder;
            ldc " ms -- "
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
            lload 7 /* rate */
            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: .line 556
            invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
        29: .line 558
            return
        end local 7 // long rate
        end local 5 // long time
        end local 4 // boolean slow
        end local 3 // int i
        end local 2 // java.util.Random randomgen
        end local 1 // org.hsqldb.lib.StopWatch sw
        end local 0 // org.hsqldb.test.TestCacheSize this
      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 // org.hsqldb.test.TestCacheSize this
         0: .line 562
            new org.hsqldb.lib.StopWatch
            dup
            invokespecial org.hsqldb.lib.StopWatch.<init>:()V
            astore 1 /* sw */
        start local 1 // org.hsqldb.lib.StopWatch sw
         1: .line 563
            new java.util.Random
            dup
            invokespecial java.util.Random.<init>:()V
            astore 2 /* randomgen */
        start local 2 // java.util.Random randomgen
         2: .line 564
            iconst_0
            istore 3 /* i */
        start local 3 // int i
         3: .line 565
            iconst_0
            istore 4 /* slow */
        start local 4 // boolean slow
         4: .line 568
            aload 0 /* this */
            getfield org.hsqldb.test.TestCacheSize.cConnection:Ljava/sql/Connection;
         5: .line 569
            ldc "SELECT firstname,lastname,zip,filler FROM test WHERE id = ?"
         6: .line 568
            invokeinterface java.sql.Connection.prepareStatement:(Ljava/lang/String;)Ljava/sql/PreparedStatement;
            astore 5 /* ps */
        start local 5 // java.sql.PreparedStatement ps
         7: .line 571
            iconst_0
            istore 3 /* i */
            goto 16
         8: .line 572
      StackMap locals: org.hsqldb.test.TestCacheSize org.hsqldb.lib.StopWatch java.util.Random int int java.sql.PreparedStatement
      StackMap stack:
            aload 5 /* ps */
            iconst_1
            aload 0 /* this */
            aload 2 /* randomgen */
            aload 0 /* this */
            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: .line 573
            aload 5 /* ps */
            invokeinterface java.sql.PreparedStatement.execute:()Z
            pop
        10: .line 575
            aload 0 /* this */
            getfield org.hsqldb.test.TestCacheSize.reportProgress:Z
            ifeq 11
            iload 3 /* i */
            iconst_1
            iadd
            sipush 10000
            irem
            ifeq 12
        11: .line 576
      StackMap locals:
      StackMap stack:
            iload 4 /* slow */
            ifeq 15
            iload 3 /* i */
            iconst_1
            iadd
            bipush 100
            irem
            ifne 15
        12: .line 577
      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 /* i */
            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: .line 578
            aload 1 /* sw */
            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: .line 577
            invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
        15: .line 571
      StackMap locals:
      StackMap stack:
            iinc 3 /* i */ 1
      StackMap locals:
      StackMap stack:
        16: iload 3 /* i */
            aload 0 /* this */
            getfield org.hsqldb.test.TestCacheSize.smallops:I
            if_icmplt 8
        17: .line 582
            aload 5 /* ps */
            invokeinterface java.sql.PreparedStatement.close:()V
        end local 5 // java.sql.PreparedStatement ps
        18: .line 583
            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 /* e */
        start local 5 // java.sql.SQLException e
        20: .line 584
            aload 5 /* e */
            invokevirtual java.sql.SQLException.printStackTrace:()V
        end local 5 // java.sql.SQLException e
        21: .line 587
      StackMap locals:
      StackMap stack:
            aload 1 /* sw */
            invokevirtual org.hsqldb.lib.StopWatch.elapsedTime:()J
            lstore 5 /* time */
        start local 5 // long time
        22: .line 588
            iload 3 /* i */
            i2l
            ldc 1000
            lmul
            lload 5 /* time */
            lconst_1
            ladd
            ldiv
            lstore 7 /* rate */
        start local 7 // long rate
        23: .line 590
            aload 0 /* this */
            ldc "select random id"
            iload 3 /* i */
            lload 5 /* time */
            lload 7 /* rate */
            invokevirtual org.hsqldb.test.TestCacheSize.storeResult:(Ljava/lang/String;IJJ)V
        24: .line 591
            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 /* i */
            invokevirtual java.lang.StringBuilder.append:(I)Ljava/lang/StringBuilder;
            ldc " rows  -- "
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
        25: .line 592
            lload 5 /* time */
            invokevirtual java.lang.StringBuilder.append:(J)Ljava/lang/StringBuilder;
            ldc " ms -- "
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
            lload 7 /* rate */
            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: .line 591
            invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
        27: .line 593
            return
        end local 7 // long rate
        end local 5 // long time
        end local 4 // boolean slow
        end local 3 // int i
        end local 2 // java.util.Random randomgen
        end local 1 // org.hsqldb.lib.StopWatch sw
        end local 0 // org.hsqldb.test.TestCacheSize this
      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 // org.hsqldb.test.TestCacheSize this
         0: .line 597
            new org.hsqldb.lib.StopWatch
            dup
            invokespecial org.hsqldb.lib.StopWatch.<init>:()V
            astore 1 /* sw */
        start local 1 // org.hsqldb.lib.StopWatch sw
         1: .line 598
            new java.util.Random
            dup
            invokespecial java.util.Random.<init>:()V
            astore 2 /* randomgen */
        start local 2 // java.util.Random randomgen
         2: .line 599
            iconst_0
            istore 3 /* i */
        start local 3 // int i
         3: .line 600
            iconst_0
            istore 4 /* slow */
        start local 4 // boolean slow
         4: .line 603
            aload 0 /* this */
            getfield org.hsqldb.test.TestCacheSize.cConnection:Ljava/sql/Connection;
         5: .line 604
            ldc "SELECT zip FROM zip WHERE zip = ?"
         6: .line 603
            invokeinterface java.sql.Connection.prepareStatement:(Ljava/lang/String;)Ljava/sql/PreparedStatement;
            astore 5 /* ps */
        start local 5 // java.sql.PreparedStatement ps
         7: .line 606
            iconst_0
            istore 3 /* i */
            goto 16
         8: .line 607
      StackMap locals: org.hsqldb.test.TestCacheSize org.hsqldb.lib.StopWatch java.util.Random int int java.sql.PreparedStatement
      StackMap stack:
            aload 5 /* ps */
            iconst_1
            aload 0 /* this */
            aload 2 /* randomgen */
            aload 0 /* this */
            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: .line 608
            aload 5 /* ps */
            invokeinterface java.sql.PreparedStatement.execute:()Z
            pop
        10: .line 610
            aload 0 /* this */
            getfield org.hsqldb.test.TestCacheSize.reportProgress:Z
            ifeq 11
            iload 3 /* i */
            iconst_1
            iadd
            sipush 10000
            irem
            ifeq 12
        11: .line 611
      StackMap locals:
      StackMap stack:
            iload 4 /* slow */
            ifeq 15
            iload 3 /* i */
            iconst_1
            iadd
            bipush 100
            irem
            ifne 15
        12: .line 612
      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 /* i */
            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: .line 613
            aload 1 /* sw */
            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: .line 612
            invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
        15: .line 606
      StackMap locals:
      StackMap stack:
            iinc 3 /* i */ 1
      StackMap locals:
      StackMap stack:
        16: iload 3 /* i */
            aload 0 /* this */
            getfield org.hsqldb.test.TestCacheSize.bigops:I
            if_icmplt 8
        17: .line 617
            aload 5 /* ps */
            invokeinterface java.sql.PreparedStatement.close:()V
        end local 5 // java.sql.PreparedStatement ps
        18: .line 618
            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 /* e */
        start local 5 // java.sql.SQLException e
        20: .line 619
            aload 5 /* e */
            invokevirtual java.sql.SQLException.printStackTrace:()V
        end local 5 // java.sql.SQLException e
        21: .line 622
      StackMap locals:
      StackMap stack:
            aload 1 /* sw */
            invokevirtual org.hsqldb.lib.StopWatch.elapsedTime:()J
            lstore 5 /* time */
        start local 5 // long time
        22: .line 623
            iload 3 /* i */
            i2l
            ldc 1000
            lmul
            lload 5 /* time */
            lconst_1
            ladd
            ldiv
            lstore 7 /* rate */
        start local 7 // long rate
        23: .line 625
            aload 0 /* this */
            ldc "select random zip (zip table)"
            iload 3 /* i */
            lload 5 /* time */
            lload 7 /* rate */
            invokevirtual org.hsqldb.test.TestCacheSize.storeResult:(Ljava/lang/String;IJJ)V
        24: .line 626
            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 /* i */
            invokevirtual java.lang.StringBuilder.append:(I)Ljava/lang/StringBuilder;
        25: .line 627
            ldc " rows  -- "
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
            lload 5 /* time */
            invokevirtual java.lang.StringBuilder.append:(J)Ljava/lang/StringBuilder;
            ldc " ms -- "
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
            lload 7 /* rate */
            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: .line 626
            invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
        27: .line 628
            return
        end local 7 // long rate
        end local 5 // long time
        end local 4 // boolean slow
        end local 3 // int i
        end local 2 // java.util.Random randomgen
        end local 1 // org.hsqldb.lib.StopWatch sw
        end local 0 // org.hsqldb.test.TestCacheSize this
      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 // org.hsqldb.test.TestCacheSize this
         0: .line 633
            new org.hsqldb.lib.StopWatch
            dup
            invokespecial org.hsqldb.lib.StopWatch.<init>:()V
            astore 1 /* sw */
        start local 1 // org.hsqldb.lib.StopWatch sw
         1: .line 637
            aload 0 /* this */
            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: .line 639
            aload 0 /* this */
            getfield org.hsqldb.test.TestCacheSize.sStatement:Ljava/sql/Statement;
            invokeinterface java.sql.Statement.getResultSet:()Ljava/sql/ResultSet;
            astore 2 /* rs */
        start local 2 // java.sql.ResultSet rs
         3: .line 641
            aload 2 /* rs */
            invokeinterface java.sql.ResultSet.next:()Z
            pop
         4: .line 643
            aload 1 /* sw */
            invokevirtual org.hsqldb.lib.StopWatch.elapsedTime:()J
            lstore 3 /* time */
        start local 3 // long time
         5: .line 644
            aload 0 /* this */
            getfield org.hsqldb.test.TestCacheSize.bigrows:I
            i2l
            ldc 1000
            lmul
            lload 3 /* time */
            lconst_1
            ladd
            ldiv
            lstore 5 /* rate */
        start local 5 // long rate
         6: .line 646
            aload 0 /* this */
            ldc "count (index on id)"
            aload 2 /* rs */
            iconst_1
            invokeinterface java.sql.ResultSet.getInt:(I)I
            lload 3 /* time */
            lload 5 /* rate */
            invokevirtual org.hsqldb.test.TestCacheSize.storeResult:(Ljava/lang/String;IJJ)V
         7: .line 647
            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 /* rs */
            iconst_1
            invokeinterface java.sql.ResultSet.getInt:(I)I
            invokevirtual java.lang.StringBuilder.append:(I)Ljava/lang/StringBuilder;
         8: .line 648
            ldc " rows  -- "
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
            lload 3 /* time */
            invokevirtual java.lang.StringBuilder.append:(J)Ljava/lang/StringBuilder;
            ldc " ms -- "
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
            lload 5 /* rate */
            invokevirtual java.lang.StringBuilder.append:(J)Ljava/lang/StringBuilder;
         9: .line 649
            ldc " tps"
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
            invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
        10: .line 647
            invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
        11: .line 651
            aload 1 /* sw */
            invokevirtual org.hsqldb.lib.StopWatch.zero:()V
        12: .line 653
            aload 0 /* this */
            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: .line 655
            aload 0 /* this */
            getfield org.hsqldb.test.TestCacheSize.sStatement:Ljava/sql/Statement;
            invokeinterface java.sql.Statement.getResultSet:()Ljava/sql/ResultSet;
            astore 2 /* rs */
        14: .line 657
            aload 2 /* rs */
            invokeinterface java.sql.ResultSet.next:()Z
            pop
        15: .line 659
            aload 1 /* sw */
            invokevirtual org.hsqldb.lib.StopWatch.elapsedTime:()J
            lstore 3 /* time */
        16: .line 660
            ldc 1000
            lload 3 /* time */
            lconst_1
            ladd
            ldiv
            lstore 5 /* rate */
        17: .line 662
            aload 0 /* this */
            ldc "count (index on id)"
            aload 2 /* rs */
            iconst_1
            invokeinterface java.sql.ResultSet.getInt:(I)I
            lload 3 /* time */
            lload 5 /* rate */
            invokevirtual org.hsqldb.test.TestCacheSize.storeResult:(Ljava/lang/String;IJJ)V
        18: .line 663
            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 /* rs */
            iconst_1
            invokeinterface java.sql.ResultSet.getInt:(I)I
            invokevirtual java.lang.StringBuilder.append:(I)Ljava/lang/StringBuilder;
        19: .line 664
            ldc " rows  -- "
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
            lload 3 /* time */
            invokevirtual java.lang.StringBuilder.append:(J)Ljava/lang/StringBuilder;
            ldc " ms -- "
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
            lload 5 /* rate */
            invokevirtual java.lang.StringBuilder.append:(J)Ljava/lang/StringBuilder;
        20: .line 665
            ldc " tps"
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
            invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
        21: .line 663
            invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
        end local 5 // long rate
        end local 3 // long time
        end local 2 // java.sql.ResultSet rs
        end local 1 // org.hsqldb.lib.StopWatch sw
        22: .line 667
            goto 24
      StackMap locals:
      StackMap stack: java.sql.SQLException
        23: pop
        24: .line 668
      StackMap locals:
      StackMap stack:
            return
        end local 0 // org.hsqldb.test.TestCacheSize this
      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 // org.hsqldb.test.TestCacheSize this
         0: .line 673
            new org.hsqldb.lib.StopWatch
            dup
            invokespecial org.hsqldb.lib.StopWatch.<init>:()V
            astore 1 /* sw */
        start local 1 // org.hsqldb.lib.StopWatch sw
         1: .line 675
            aload 0 /* this */
            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: .line 677
            aload 0 /* this */
            getfield org.hsqldb.test.TestCacheSize.sStatement:Ljava/sql/Statement;
            invokeinterface java.sql.Statement.getResultSet:()Ljava/sql/ResultSet;
            astore 2 /* rs */
        start local 2 // java.sql.ResultSet rs
         3: .line 679
            aload 2 /* rs */
            invokeinterface java.sql.ResultSet.next:()Z
            pop
         4: .line 681
            aload 1 /* sw */
            invokevirtual org.hsqldb.lib.StopWatch.elapsedTime:()J
            lstore 3 /* time */
        start local 3 // long time
         5: .line 682
            aload 0 /* this */
            getfield org.hsqldb.test.TestCacheSize.bigrows:I
            i2l
            ldc 1000
            lmul
            lload 3 /* time */
            lconst_1
            ladd
            ldiv
            lstore 5 /* rate */
        start local 5 // long rate
         6: .line 684
            aload 0 /* this */
            ldc "count (index on zip)"
            aload 2 /* rs */
            iconst_1
            invokeinterface java.sql.ResultSet.getInt:(I)I
            lload 3 /* time */
            lload 5 /* rate */
            invokevirtual org.hsqldb.test.TestCacheSize.storeResult:(Ljava/lang/String;IJJ)V
         7: .line 685
            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 /* rs */
            iconst_1
            invokeinterface java.sql.ResultSet.getInt:(I)I
            invokevirtual java.lang.StringBuilder.append:(I)Ljava/lang/StringBuilder;
         8: .line 686
            ldc " rows  -- "
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
            lload 3 /* time */
            invokevirtual java.lang.StringBuilder.append:(J)Ljava/lang/StringBuilder;
            ldc " ms -- "
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
            lload 5 /* rate */
            invokevirtual java.lang.StringBuilder.append:(J)Ljava/lang/StringBuilder;
         9: .line 687
            ldc " tps"
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
            invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
        10: .line 685
            invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
        end local 5 // long rate
        end local 3 // long time
        end local 2 // java.sql.ResultSet rs
        end local 1 // org.hsqldb.lib.StopWatch sw
        11: .line 688
            goto 13
      StackMap locals:
      StackMap stack: java.sql.SQLException
        12: pop
        13: .line 689
      StackMap locals:
      StackMap stack:
            return
        end local 0 // org.hsqldb.test.TestCacheSize this
      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 // org.hsqldb.test.TestCacheSize this
         0: .line 694
            new org.hsqldb.lib.StopWatch
            dup
            invokespecial org.hsqldb.lib.StopWatch.<init>:()V
            astore 1 /* sw */
        start local 1 // org.hsqldb.lib.StopWatch sw
         1: .line 696
            aload 0 /* this */
            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: .line 698
            aload 0 /* this */
            getfield org.hsqldb.test.TestCacheSize.sStatement:Ljava/sql/Statement;
            invokeinterface java.sql.Statement.getResultSet:()Ljava/sql/ResultSet;
            astore 2 /* rs */
        start local 2 // java.sql.ResultSet rs
         3: .line 700
            aload 2 /* rs */
            invokeinterface java.sql.ResultSet.next:()Z
            pop
         4: .line 701
            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 /* rs */
            iconst_1
            invokeinterface java.sql.ResultSet.getInt:(I)I
            invokevirtual java.lang.StringBuilder.append:(I)Ljava/lang/StringBuilder;
         5: .line 702
            ldc " rows  -- "
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
            aload 1 /* sw */
            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: .line 701
            invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
        end local 2 // java.sql.ResultSet rs
        end local 1 // org.hsqldb.lib.StopWatch sw
         7: .line 703
            goto 9
      StackMap locals:
      StackMap stack: java.sql.SQLException
         8: pop
         9: .line 704
      StackMap locals:
      StackMap stack:
            return
        end local 0 // org.hsqldb.test.TestCacheSize this
      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 // org.hsqldb.test.TestCacheSize this
         0: .line 708
            new org.hsqldb.lib.StopWatch
            dup
            invokespecial org.hsqldb.lib.StopWatch.<init>:()V
            astore 1 /* sw */
        start local 1 // org.hsqldb.lib.StopWatch sw
         1: .line 709
            new java.util.Random
            dup
            invokespecial java.util.Random.<init>:()V
            astore 2 /* randomgen */
        start local 2 // java.util.Random randomgen
         2: .line 710
            iconst_0
            istore 3 /* i */
        start local 3 // int i
         3: .line 712
            iconst_0
            istore 4 /* count */
        start local 4 // int count
         4: .line 713
            iconst_0
            istore 5 /* random */
        start local 5 // int random
         5: .line 716
            aload 0 /* this */
            getfield org.hsqldb.test.TestCacheSize.cConnection:Ljava/sql/Connection;
         6: .line 717
            ldc "UPDATE test SET filler = filler || zip WHERE zip = ?"
         7: .line 716
            invokeinterface java.sql.Connection.prepareStatement:(Ljava/lang/String;)Ljava/sql/PreparedStatement;
            astore 6 /* ps */
        start local 6 // java.sql.PreparedStatement ps
         8: .line 719
            goto 17
         9: .line 720
      StackMap locals: org.hsqldb.test.TestCacheSize org.hsqldb.lib.StopWatch java.util.Random int int int java.sql.PreparedStatement
      StackMap stack:
            aload 0 /* this */
            aload 2 /* randomgen */
            aload 0 /* this */
            getfield org.hsqldb.test.TestCacheSize.smallrows:I
            iconst_1
            isub
            invokevirtual org.hsqldb.test.TestCacheSize.nextIntRandom:(Ljava/util/Random;I)I
            istore 5 /* random */
        10: .line 722
            aload 6 /* ps */
            iconst_1
            iload 5 /* random */
            invokeinterface java.sql.PreparedStatement.setInt:(II)V
        11: .line 724
            iload 4 /* count */
            aload 6 /* ps */
            invokeinterface java.sql.PreparedStatement.executeUpdate:()I
            iadd
            istore 4 /* count */
        12: .line 726
            aload 0 /* this */
            getfield org.hsqldb.test.TestCacheSize.reportProgress:Z
            ifeq 16
            iload 4 /* count */
            sipush 10000
            irem
            bipush 20
            if_icmpge 16
        13: .line 727
            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 /* count */
            invokevirtual java.lang.StringBuilder.append:(I)Ljava/lang/StringBuilder;
            ldc " : "
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
        14: .line 728
            aload 1 /* sw */
            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: .line 727
            invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
        16: .line 719
      StackMap locals:
      StackMap stack:
            iinc 3 /* i */ 1
      StackMap locals:
      StackMap stack:
        17: iload 3 /* i */
            aload 0 /* this */
            getfield org.hsqldb.test.TestCacheSize.smallrows:I
            if_icmplt 9
        18: .line 732
            aload 6 /* ps */
            invokeinterface java.sql.PreparedStatement.close:()V
        end local 6 // java.sql.PreparedStatement ps
        19: .line 733
            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 /* e */
        start local 6 // java.sql.SQLException e
        21: .line 734
            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 /* random */
            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: .line 735
            aload 6 /* e */
            invokevirtual java.sql.SQLException.printStackTrace:()V
        end local 6 // java.sql.SQLException e
        23: .line 738
      StackMap locals:
      StackMap stack:
            aload 1 /* sw */
            invokevirtual org.hsqldb.lib.StopWatch.elapsedTime:()J
            lstore 6 /* time */
        start local 6 // long time
        24: .line 739
            iload 3 /* i */
            sipush 1000
            imul
            i2l
            lload 6 /* time */
            lconst_1
            ladd
            ldiv
            lstore 8 /* rate */
        start local 8 // long rate
        25: .line 741
            aload 0 /* this */
            ldc "update with random zip"
            iload 3 /* i */
            lload 6 /* time */
            lload 8 /* rate */
            invokevirtual org.hsqldb.test.TestCacheSize.storeResult:(Ljava/lang/String;IJJ)V
        26: .line 742
            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 /* i */
            invokevirtual java.lang.StringBuilder.append:(I)Ljava/lang/StringBuilder;
            ldc " rows  -- "
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
        27: .line 743
            lload 6 /* time */
            invokevirtual java.lang.StringBuilder.append:(J)Ljava/lang/StringBuilder;
            ldc " ms -- "
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
            lload 8 /* rate */
            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: .line 742
            invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
        29: .line 744
            return
        end local 8 // long rate
        end local 6 // long time
        end local 5 // int random
        end local 4 // int count
        end local 3 // int i
        end local 2 // java.util.Random randomgen
        end local 1 // org.hsqldb.lib.StopWatch sw
        end local 0 // org.hsqldb.test.TestCacheSize this
      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 // org.hsqldb.test.TestCacheSize this
         0: .line 748
            new org.hsqldb.lib.StopWatch
            dup
            invokespecial org.hsqldb.lib.StopWatch.<init>:()V
            astore 1 /* sw */
        start local 1 // org.hsqldb.lib.StopWatch sw
         1: .line 749
            new java.util.Random
            dup
            invokespecial java.util.Random.<init>:()V
            astore 2 /* randomgen */
        start local 2 // java.util.Random randomgen
         2: .line 750
            iconst_0
            istore 3 /* i */
        start local 3 // int i
         3: .line 751
            iconst_0
            istore 4 /* slow */
        start local 4 // boolean slow
         4: .line 753
            iconst_0
            istore 5 /* random */
        start local 5 // int random
         5: .line 756
            aload 0 /* this */
            getfield org.hsqldb.test.TestCacheSize.cConnection:Ljava/sql/Connection;
         6: .line 757
            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: .line 758
            aload 0 /* this */
            getfield org.hsqldb.test.TestCacheSize.smallrows:I
            invokevirtual java.lang.StringBuilder.append:(I)Ljava/lang/StringBuilder;
         8: .line 757
            invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
         9: .line 756
            invokeinterface java.sql.Connection.prepareStatement:(Ljava/lang/String;)Ljava/sql/PreparedStatement;
            astore 6 /* ps */
        start local 6 // java.sql.PreparedStatement ps
        10: .line 760
            iconst_0
            istore 3 /* i */
            goto 21
        11: .line 761
      StackMap locals: org.hsqldb.test.TestCacheSize org.hsqldb.lib.StopWatch java.util.Random int int int java.sql.PreparedStatement
      StackMap stack:
            aload 0 /* this */
            aload 2 /* randomgen */
            aload 0 /* this */
            getfield org.hsqldb.test.TestCacheSize.bigrows:I
            iconst_1
            isub
            invokevirtual org.hsqldb.test.TestCacheSize.nextIntRandom:(Ljava/util/Random;I)I
            istore 5 /* random */
        12: .line 763
            aload 6 /* ps */
            iconst_1
            iload 5 /* random */
            invokeinterface java.sql.PreparedStatement.setInt:(II)V
        13: .line 764
            aload 6 /* ps */
            invokeinterface java.sql.PreparedStatement.execute:()Z
            pop
        14: .line 766
            aload 0 /* this */
            getfield org.hsqldb.test.TestCacheSize.reportProgress:Z
            ifeq 15
            iload 3 /* i */
            iconst_1
            iadd
            sipush 10000
            irem
            ifeq 16
        15: .line 767
      StackMap locals:
      StackMap stack:
            iload 4 /* slow */
            ifeq 20
            iload 3 /* i */
            iconst_1
            iadd
            bipush 100
            irem
            ifne 20
        16: .line 768
      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 /* i */
            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: .line 769
            aload 1 /* sw */
            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: .line 770
            iload 3 /* i */
            sipush 1000
            imul
            i2l
            aload 1 /* sw */
            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: .line 768
            invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
        20: .line 760
      StackMap locals:
      StackMap stack:
            iinc 3 /* i */ 1
      StackMap locals:
      StackMap stack:
        21: iload 3 /* i */
            aload 0 /* this */
            getfield org.hsqldb.test.TestCacheSize.smallops:I
            if_icmplt 11
        22: .line 774
            aload 6 /* ps */
            invokeinterface java.sql.PreparedStatement.close:()V
        end local 6 // java.sql.PreparedStatement ps
        23: .line 775
            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 /* e */
        start local 6 // java.sql.SQLException e
        25: .line 776
            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 /* random */
            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: .line 777
            aload 6 /* e */
            invokevirtual java.sql.SQLException.printStackTrace:()V
        end local 6 // java.sql.SQLException e
        27: .line 780
      StackMap locals:
      StackMap stack:
            aload 1 /* sw */
            invokevirtual org.hsqldb.lib.StopWatch.elapsedTime:()J
            lstore 6 /* time */
        start local 6 // long time
        28: .line 781
            iload 3 /* i */
            sipush 1000
            imul
            i2l
            lload 6 /* time */
            lconst_1
            ladd
            ldiv
            lstore 8 /* rate */
        start local 8 // long rate
        29: .line 783
            aload 0 /* this */
            ldc "update with random id"
            iload 3 /* i */
            lload 6 /* time */
            lload 8 /* rate */
            invokevirtual org.hsqldb.test.TestCacheSize.storeResult:(Ljava/lang/String;IJJ)V
        30: .line 784
            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 /* i */
            invokevirtual java.lang.StringBuilder.append:(I)Ljava/lang/StringBuilder;
            ldc " rows  -- "
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
        31: .line 785
            lload 6 /* time */
            invokevirtual java.lang.StringBuilder.append:(J)Ljava/lang/StringBuilder;
            ldc " ms -- "
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
            lload 8 /* rate */
            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: .line 784
            invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
        33: .line 786
            return
        end local 8 // long rate
        end local 6 // long time
        end local 5 // int random
        end local 4 // boolean slow
        end local 3 // int i
        end local 2 // java.util.Random randomgen
        end local 1 // org.hsqldb.lib.StopWatch sw
        end local 0 // org.hsqldb.test.TestCacheSize this
      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 // org.hsqldb.test.TestCacheSize this
         0: .line 790
            new org.hsqldb.lib.StopWatch
            dup
            invokespecial org.hsqldb.lib.StopWatch.<init>:()V
            astore 1 /* sw */
        start local 1 // org.hsqldb.lib.StopWatch sw
         1: .line 791
            new java.util.Random
            dup
            invokespecial java.util.Random.<init>:()V
            astore 2 /* randomgen */
        start local 2 // java.util.Random randomgen
         2: .line 792
            iconst_0
            istore 3 /* i */
        start local 3 // int i
         3: .line 793
            iconst_0
            istore 4 /* slow */
        start local 4 // boolean slow
         4: .line 795
            iconst_0
            istore 5 /* random */
        start local 5 // int random
         5: .line 798
            aload 0 /* this */
            getfield org.hsqldb.test.TestCacheSize.cConnection:Ljava/sql/Connection;
         6: .line 799
            new java.lang.StringBuilder
            dup
            ldc "UPDATE test SET filler = ? WHERE id = ? and zip <> "
            invokespecial java.lang.StringBuilder.<init>:(Ljava/lang/String;)V
         7: .line 800
            aload 0 /* this */
            getfield org.hsqldb.test.TestCacheSize.smallrows:I
            invokevirtual java.lang.StringBuilder.append:(I)Ljava/lang/StringBuilder;
         8: .line 799
            invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
         9: .line 798
            invokeinterface java.sql.Connection.prepareStatement:(Ljava/lang/String;)Ljava/sql/PreparedStatement;
            astore 6 /* ps */
        start local 6 // java.sql.PreparedStatement ps
        10: .line 802
            iconst_0
            istore 3 /* i */
            goto 24
        11: .line 803
      StackMap locals: org.hsqldb.test.TestCacheSize org.hsqldb.lib.StopWatch java.util.Random int int int java.sql.PreparedStatement
      StackMap stack:
            aload 0 /* this */
            aload 2 /* randomgen */
            aload 0 /* this */
            getfield org.hsqldb.test.TestCacheSize.bigrows:I
            iconst_1
            isub
            invokevirtual org.hsqldb.test.TestCacheSize.nextIntRandom:(Ljava/util/Random;I)I
            istore 5 /* random */
        12: .line 805
            aload 0 /* this */
            aload 2 /* randomgen */
            aload 0 /* this */
            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 /* randomLength */
        start local 7 // int randomLength
        13: .line 806
            aload 0 /* this */
            getfield org.hsqldb.test.TestCacheSize.filler:Ljava/lang/String;
            iload 7 /* randomLength */
            invokevirtual java.lang.String.substring:(I)Ljava/lang/String;
            astore 8 /* newFiller */
        start local 8 // java.lang.String newFiller
        14: .line 808
            aload 6 /* ps */
            iconst_1
            aload 8 /* newFiller */
            invokeinterface java.sql.PreparedStatement.setString:(ILjava/lang/String;)V
        15: .line 809
            aload 6 /* ps */
            iconst_2
            iload 5 /* random */
            invokeinterface java.sql.PreparedStatement.setInt:(II)V
        16: .line 810
            aload 6 /* ps */
            invokeinterface java.sql.PreparedStatement.execute:()Z
            pop
        17: .line 812
            aload 0 /* this */
            getfield org.hsqldb.test.TestCacheSize.reportProgress:Z
            ifeq 18
            iload 3 /* i */
            iconst_1
            iadd
            sipush 10000
            irem
            ifeq 19
        18: .line 813
      StackMap locals: int java.lang.String
      StackMap stack:
            iload 4 /* slow */
            ifeq 23
            iload 3 /* i */
            iconst_1
            iadd
            bipush 100
            irem
            ifne 23
        19: .line 814
      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 /* i */
            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: .line 815
            aload 1 /* sw */
            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: .line 816
            iload 3 /* i */
            sipush 1000
            imul
            i2l
            aload 1 /* sw */
            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: .line 814
            invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
        end local 8 // java.lang.String newFiller
        end local 7 // int randomLength
        23: .line 802
      StackMap locals:
      StackMap stack:
            iinc 3 /* i */ 1
      StackMap locals:
      StackMap stack:
        24: iload 3 /* i */
            aload 0 /* this */
            getfield org.hsqldb.test.TestCacheSize.smallops:I
            iconst_2
            imul
            if_icmplt 11
        25: .line 820
            aload 6 /* ps */
            invokeinterface java.sql.PreparedStatement.close:()V
        end local 6 // java.sql.PreparedStatement ps
        26: .line 821
            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 /* e */
        start local 6 // java.sql.SQLException e
        28: .line 822
            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 /* random */
            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: .line 823
            aload 6 /* e */
            invokevirtual java.sql.SQLException.printStackTrace:()V
        end local 6 // java.sql.SQLException e
        30: .line 826
      StackMap locals:
      StackMap stack:
            aload 1 /* sw */
            invokevirtual org.hsqldb.lib.StopWatch.elapsedTime:()J
            lstore 6 /* time */
        start local 6 // long time
        31: .line 827
            iload 3 /* i */
            sipush 1000
            imul
            i2l
            lload 6 /* time */
            lconst_1
            ladd
            ldiv
            lstore 8 /* rate */
        start local 8 // long rate
        32: .line 829
            aload 0 /* this */
            ldc "update with random id"
            iload 3 /* i */
            lload 6 /* time */
            lload 8 /* rate */
            invokevirtual org.hsqldb.test.TestCacheSize.storeResult:(Ljava/lang/String;IJJ)V
        33: .line 830
            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 /* i */
            invokevirtual java.lang.StringBuilder.append:(I)Ljava/lang/StringBuilder;
            ldc " rows  -- "
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
        34: .line 831
            lload 6 /* time */
            invokevirtual java.lang.StringBuilder.append:(J)Ljava/lang/StringBuilder;
            ldc " ms -- "
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
            lload 8 /* rate */
            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: .line 830
            invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
        36: .line 832
            return
        end local 8 // long rate
        end local 6 // long time
        end local 5 // int random
        end local 4 // boolean slow
        end local 3 // int i
        end local 2 // java.util.Random randomgen
        end local 1 // org.hsqldb.lib.StopWatch sw
        end local 0 // org.hsqldb.test.TestCacheSize this
      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 // org.hsqldb.test.TestCacheSize this
         0: .line 836
            new org.hsqldb.lib.StopWatch
            dup
            invokespecial org.hsqldb.lib.StopWatch.<init>:()V
            astore 1 /* sw */
        start local 1 // org.hsqldb.lib.StopWatch sw
         1: .line 837
            new java.util.Random
            invokespecial java.util.Random.<init>:()V
         2: .line 838
            iconst_0
            istore 2 /* i */
        start local 2 // int i
         3: .line 839
            iconst_0
            istore 3 /* slow */
        start local 3 // boolean slow
         4: .line 841
            iconst_0
            istore 4 /* random */
        start local 4 // int random
         5: .line 844
            aload 0 /* this */
            getfield org.hsqldb.test.TestCacheSize.cConnection:Ljava/sql/Connection;
         6: .line 845
            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: .line 846
            aload 0 /* this */
            getfield org.hsqldb.test.TestCacheSize.smallrows:I
            invokevirtual java.lang.StringBuilder.append:(I)Ljava/lang/StringBuilder;
         8: .line 845
            invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
         9: .line 844
            invokeinterface java.sql.Connection.prepareStatement:(Ljava/lang/String;)Ljava/sql/PreparedStatement;
            astore 5 /* ps */
        start local 5 // java.sql.PreparedStatement ps
        10: .line 848
            iconst_0
            istore 2 /* i */
            goto 21
        11: .line 849
      StackMap locals: org.hsqldb.test.TestCacheSize org.hsqldb.lib.StopWatch int int int java.sql.PreparedStatement
      StackMap stack:
            iload 2 /* i */
            istore 4 /* random */
        12: .line 851
            aload 5 /* ps */
            iconst_1
            iload 4 /* random */
            invokeinterface java.sql.PreparedStatement.setInt:(II)V
        13: .line 852
            aload 5 /* ps */
            invokeinterface java.sql.PreparedStatement.execute:()Z
            pop
        14: .line 854
            aload 0 /* this */
            getfield org.hsqldb.test.TestCacheSize.reportProgress:Z
            ifeq 15
            iload 2 /* i */
            iconst_1
            iadd
            sipush 10000
            irem
            ifeq 16
        15: .line 855
      StackMap locals:
      StackMap stack:
            iload 3 /* slow */
            ifeq 20
            iload 2 /* i */
            iconst_1
            iadd
            bipush 100
            irem
            ifne 20
        16: .line 856
      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 /* i */
            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: .line 857
            aload 1 /* sw */
            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: .line 858
            iload 2 /* i */
            sipush 1000
            imul
            i2l
            aload 1 /* sw */
            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: .line 856
            invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
        20: .line 848
      StackMap locals:
      StackMap stack:
            iinc 2 /* i */ 1
      StackMap locals:
      StackMap stack:
        21: iload 2 /* i */
            aload 0 /* this */
            getfield org.hsqldb.test.TestCacheSize.bigops:I
            if_icmplt 11
        22: .line 862
            aload 5 /* ps */
            invokeinterface java.sql.PreparedStatement.close:()V
        end local 5 // java.sql.PreparedStatement ps
        23: .line 863
            goto 27
      StackMap locals: org.hsqldb.test.TestCacheSize org.hsqldb.lib.StopWatch int int int
      StackMap stack: java.sql.SQLException
        24: astore 5 /* e */
        start local 5 // java.sql.SQLException e
        25: .line 864
            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 /* random */
            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: .line 865
            aload 5 /* e */
            invokevirtual java.sql.SQLException.printStackTrace:()V
        end local 5 // java.sql.SQLException e
        27: .line 868
      StackMap locals:
      StackMap stack:
            aload 1 /* sw */
            invokevirtual org.hsqldb.lib.StopWatch.elapsedTime:()J
            lstore 5 /* time */
        start local 5 // long time
        28: .line 869
            iload 2 /* i */
            sipush 1000
            imul
            i2l
            lload 5 /* time */
            lconst_1
            ladd
            ldiv
            lstore 7 /* rate */
        start local 7 // long rate
        29: .line 871
            aload 0 /* this */
            ldc "update with sequential id"
            iload 2 /* i */
            lload 5 /* time */
            lload 7 /* rate */
            invokevirtual org.hsqldb.test.TestCacheSize.storeResult:(Ljava/lang/String;IJJ)V
        30: .line 872
            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 /* i */
            invokevirtual java.lang.StringBuilder.append:(I)Ljava/lang/StringBuilder;
        31: .line 873
            ldc " rows  -- "
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
            lload 5 /* time */
            invokevirtual java.lang.StringBuilder.append:(J)Ljava/lang/StringBuilder;
            ldc " ms -- "
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
            lload 7 /* rate */
            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: .line 872
            invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
        33: .line 874
            return
        end local 7 // long rate
        end local 5 // long time
        end local 4 // int random
        end local 3 // boolean slow
        end local 2 // int i
        end local 1 // org.hsqldb.lib.StopWatch sw
        end local 0 // org.hsqldb.test.TestCacheSize this
      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 // org.hsqldb.test.TestCacheSize this
         0: .line 878
            new org.hsqldb.lib.StopWatch
            dup
            invokespecial org.hsqldb.lib.StopWatch.<init>:()V
            astore 1 /* sw */
        start local 1 // org.hsqldb.lib.StopWatch sw
         1: .line 879
            new java.util.Random
            dup
            invokespecial java.util.Random.<init>:()V
            astore 2 /* randomgen */
        start local 2 // java.util.Random randomgen
         2: .line 880
            iconst_0
            istore 3 /* i */
        start local 3 // int i
         3: .line 881
            iconst_0
            istore 4 /* slow */
        start local 4 // boolean slow
         4: .line 882
            iconst_0
            istore 5 /* count */
        start local 5 // int count
         5: .line 883
            iconst_0
            istore 6 /* random */
        start local 6 // int random
         6: .line 887
            aload 0 /* this */
            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: .line 886
            astore 7 /* ps */
        start local 7 // java.sql.PreparedStatement ps
         8: .line 889
            iconst_0
            istore 3 /* i */
            goto 19
         9: .line 890
      StackMap locals: org.hsqldb.test.TestCacheSize org.hsqldb.lib.StopWatch java.util.Random int int int int java.sql.PreparedStatement
      StackMap stack:
            aload 0 /* this */
            aload 2 /* randomgen */
            aload 0 /* this */
            getfield org.hsqldb.test.TestCacheSize.bigrows:I
            invokevirtual org.hsqldb.test.TestCacheSize.nextIntRandom:(Ljava/util/Random;I)I
            istore 6 /* random */
        10: .line 893
            aload 7 /* ps */
            iconst_1
            iload 6 /* random */
            invokeinterface java.sql.PreparedStatement.setInt:(II)V
        11: .line 895
            iload 5 /* count */
            aload 7 /* ps */
            invokeinterface java.sql.PreparedStatement.executeUpdate:()I
            iadd
            istore 5 /* count */
        12: .line 905
            aload 0 /* this */
            getfield org.hsqldb.test.TestCacheSize.reportProgress:Z
            ifeq 13
            iload 3 /* i */
            iconst_1
            iadd
            sipush 10000
            irem
            ifeq 14
        13: .line 906
      StackMap locals:
      StackMap stack:
            iload 4 /* slow */
            ifeq 18
            iload 3 /* i */
            iconst_1
            iadd
            bipush 100
            irem
            ifne 18
        14: .line 907
      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 /* i */
            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: .line 908
            aload 1 /* sw */
            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: .line 909
            iload 3 /* i */
            sipush 1000
            imul
            i2l
            aload 1 /* sw */
            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: .line 907
            invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
        18: .line 889
      StackMap locals:
      StackMap stack:
            iinc 3 /* i */ 1
      StackMap locals:
      StackMap stack:
        19: iload 5 /* count */
            aload 0 /* this */
            getfield org.hsqldb.test.TestCacheSize.smallops:I
            if_icmplt 9
        20: .line 913
            aload 7 /* ps */
            invokeinterface java.sql.PreparedStatement.close:()V
        end local 7 // java.sql.PreparedStatement ps
        21: .line 914
            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 /* e */
        start local 7 // java.sql.SQLException e
        23: .line 915
            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 /* random */
            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: .line 916
            aload 7 /* e */
            invokevirtual java.sql.SQLException.printStackTrace:()V
        end local 7 // java.sql.SQLException e
        25: .line 919
      StackMap locals:
      StackMap stack:
            aload 1 /* sw */
            invokevirtual org.hsqldb.lib.StopWatch.elapsedTime:()J
            lstore 7 /* time */
        start local 7 // long time
        26: .line 920
            iload 5 /* count */
            sipush 1000
            imul
            i2l
            lload 7 /* time */
            lconst_1
            ladd
            ldiv
            lstore 9 /* rate */
        start local 9 // long rate
        27: .line 922
            aload 0 /* this */
            ldc "delete with random id"
            iload 5 /* count */
            lload 7 /* time */
            lload 9 /* rate */
            invokevirtual org.hsqldb.test.TestCacheSize.storeResult:(Ljava/lang/String;IJJ)V
        28: .line 923
            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 /* count */
            invokevirtual java.lang.StringBuilder.append:(I)Ljava/lang/StringBuilder;
            ldc " rows  -- "
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
        29: .line 924
            lload 7 /* time */
            invokevirtual java.lang.StringBuilder.append:(J)Ljava/lang/StringBuilder;
            ldc " ms -- "
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
            lload 9 /* rate */
            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: .line 923
            invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
        31: .line 925
            return
        end local 9 // long rate
        end local 7 // long time
        end local 6 // int random
        end local 5 // int count
        end local 4 // boolean slow
        end local 3 // int i
        end local 2 // java.util.Random randomgen
        end local 1 // org.hsqldb.lib.StopWatch sw
        end local 0 // org.hsqldb.test.TestCacheSize this
      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 // org.hsqldb.test.TestCacheSize this
         0: .line 929
            new org.hsqldb.lib.StopWatch
            dup
            invokespecial org.hsqldb.lib.StopWatch.<init>:()V
            astore 1 /* sw */
        start local 1 // org.hsqldb.lib.StopWatch sw
         1: .line 930
            new java.util.Random
            invokespecial java.util.Random.<init>:()V
         2: .line 931
            iconst_0
            istore 2 /* i */
        start local 2 // int i
         3: .line 932
            iconst_0
            istore 3 /* slow */
        start local 3 // boolean slow
         4: .line 933
            iconst_0
            istore 4 /* count */
        start local 4 // int count
         5: .line 934
            iconst_0
            istore 5 /* random */
        start local 5 // int random
         6: .line 938
            aload 0 /* this */
            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: .line 937
            astore 6 /* ps */
        start local 6 // java.sql.PreparedStatement ps
         8: .line 940
            iconst_0
            istore 2 /* i */
            goto 19
         9: .line 943
      StackMap locals: org.hsqldb.test.TestCacheSize org.hsqldb.lib.StopWatch int int int int java.sql.PreparedStatement
      StackMap stack:
            iload 2 /* i */
            istore 5 /* random */
        10: .line 945
            aload 6 /* ps */
            iconst_1
            iload 5 /* random */
            invokeinterface java.sql.PreparedStatement.setInt:(II)V
        11: .line 947
            iload 4 /* count */
            aload 6 /* ps */
            invokeinterface java.sql.PreparedStatement.executeUpdate:()I
            iadd
            istore 4 /* count */
        12: .line 949
            aload 0 /* this */
            getfield org.hsqldb.test.TestCacheSize.reportProgress:Z
            ifeq 13
            iload 2 /* i */
            iconst_1
            iadd
            sipush 10000
            irem
            ifeq 14
        13: .line 950
      StackMap locals:
      StackMap stack:
            iload 3 /* slow */
            ifeq 18
            iload 2 /* i */
            iconst_1
            iadd
            bipush 100
            irem
            ifne 18
        14: .line 951
      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 /* i */
            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: .line 952
            aload 1 /* sw */
            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: .line 953
            iload 2 /* i */
            sipush 1000
            imul
            i2l
            aload 1 /* sw */
            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: .line 951
            invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
        18: .line 940
      StackMap locals:
      StackMap stack:
            iinc 2 /* i */ 1
      StackMap locals:
      StackMap stack:
        19: iload 2 /* i */
            aload 0 /* this */
            getfield org.hsqldb.test.TestCacheSize.smallrows:I
            if_icmple 9
        20: .line 957
            aload 6 /* ps */
            invokeinterface java.sql.PreparedStatement.close:()V
        end local 6 // java.sql.PreparedStatement ps
        21: .line 958
            goto 25
      StackMap locals: org.hsqldb.test.TestCacheSize org.hsqldb.lib.StopWatch int int int int
      StackMap stack: java.sql.SQLException
        22: astore 6 /* e */
        start local 6 // java.sql.SQLException e
        23: .line 959
            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 /* random */
            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: .line 960
            aload 6 /* e */
            invokevirtual java.sql.SQLException.printStackTrace:()V
        end local 6 // java.sql.SQLException e
        25: .line 963
      StackMap locals:
      StackMap stack:
            aload 1 /* sw */
            invokevirtual org.hsqldb.lib.StopWatch.elapsedTime:()J
            lstore 6 /* time */
        start local 6 // long time
        26: .line 964
            iload 4 /* count */
            i2l
            ldc 1000
            lmul
            lload 6 /* time */
            lconst_1
            ladd
            ldiv
            lstore 8 /* rate */
        start local 8 // long rate
        27: .line 966
            aload 0 /* this */
            ldc "delete with random zip"
            iload 4 /* count */
            lload 6 /* time */
            lload 8 /* rate */
            invokevirtual org.hsqldb.test.TestCacheSize.storeResult:(Ljava/lang/String;IJJ)V
        28: .line 967
            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 /* count */
            invokevirtual java.lang.StringBuilder.append:(I)Ljava/lang/StringBuilder;
        29: .line 968
            ldc " rows  -- "
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
            lload 6 /* time */
            invokevirtual java.lang.StringBuilder.append:(J)Ljava/lang/StringBuilder;
            ldc " ms -- "
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
            lload 8 /* rate */
            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: .line 967
            invokevirtual java.io.PrintStream.println:(Ljava/lang/String;)V
        31: .line 969
            return
        end local 8 // long rate
        end local 6 // long time
        end local 5 // int random
        end local 4 // int count
        end local 3 // boolean slow
        end local 2 // int i
        end local 1 // org.hsqldb.lib.StopWatch sw
        end local 0 // org.hsqldb.test.TestCacheSize this
      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 // org.hsqldb.test.TestCacheSize this
        start local 1 // java.lang.String description
        start local 2 // int count
        start local 3 // long time
        start local 5 // long rate
         0: .line 974
            aload 0 /* this */
            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 /* description */
            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 /* count */
            invokevirtual java.lang.StringBuilder.append:(I)Ljava/lang/StringBuilder;
         1: .line 975
            ldc "</td><td>"
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
            lload 3 /* time */
            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 /* rate */
            invokevirtual java.lang.StringBuilder.append:(J)Ljava/lang/StringBuilder;
         2: .line 976
            ldc "</td></tr>\n"
            invokevirtual java.lang.StringBuilder.append:(Ljava/lang/String;)Ljava/lang/StringBuilder;
            invokevirtual java.lang.StringBuilder.toString:()Ljava/lang/String;
         3: .line 974
            invokevirtual java.io.FileWriter.write:(Ljava/lang/String;)V
         4: .line 977
            goto 6
      StackMap locals:
      StackMap stack: java.lang.Exception
         5: pop
         6: .line 978
      StackMap locals:
      StackMap stack:
            return
        end local 5 // long rate
        end local 3 // long time
        end local 2 // int count
        end local 1 // java.lang.String description
        end local 0 // org.hsqldb.test.TestCacheSize this
      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 // java.lang.String path
         0: .line 982
            invokestatic org.hsqldb.lib.FileUtil.getFileUtil:()Lorg/hsqldb/lib/FileUtil;
            astore 1 /* fileUtil */
        start local 1 // org.hsqldb.lib.FileUtil fileUtil
         1: .line 984
            aload 1 /* fileUtil */
            new java.lang.StringBuilder
            dup
            aload 0 /* path */
            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: .line 985
            aload 1 /* fileUtil */
            new java.lang.StringBuilder
            dup
            aload 0 /* path */
            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: .line 986
            aload 1 /* fileUtil */
            new java.lang.StringBuilder
            dup
            aload 0 /* path */
            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: .line 987
            aload 1 /* fileUtil */
            new java.lang.StringBuilder
            dup
            aload 0 /* path */
            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: .line 988
            aload 1 /* fileUtil */
            new java.lang.StringBuilder
            dup
            aload 0 /* path */
            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: .line 989
            aload 1 /* fileUtil */
            new java.lang.StringBuilder
            dup
            aload 0 /* path */
            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: .line 990
            aload 1 /* fileUtil */
            new java.lang.StringBuilder
            dup
            aload 0 /* path */
            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: .line 991
            return
        end local 1 // org.hsqldb.lib.FileUtil fileUtil
        end local 0 // java.lang.String path
      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 // org.hsqldb.test.TestCacheSize this
        start local 1 // java.util.Random r
        start local 2 // int range
         0: .line 995
            aload 1 /* r */
            invokevirtual java.util.Random.nextInt:()I
            istore 3 /* b */
        start local 3 // int b
         1: .line 997
            iload 3 /* b */
            ldc -2147483648
            if_icmpne 3
         2: .line 998
            ldc 2147483647
            istore 3 /* b */
         3: .line 1001
      StackMap locals: int
      StackMap stack:
            iload 3 /* b */
            invokestatic java.lang.Math.abs:(I)I
            istore 3 /* b */
         4: .line 1003
            iload 3 /* b */
            iload 2 /* range */
            irem
            ireturn
        end local 3 // int b
        end local 2 // int range
        end local 1 // java.util.Random r
        end local 0 // org.hsqldb.test.TestCacheSize this
      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 // java.lang.String[] argv
         0: .line 1008
            new org.hsqldb.test.TestCacheSize
            dup
            invokespecial org.hsqldb.test.TestCacheSize.<init>:()V
            astore 1 /* test */
        start local 1 // org.hsqldb.test.TestCacheSize test
         1: .line 1009
            aload 0 /* argv */
            ldc "test"
            invokestatic org.hsqldb.persist.HsqlProperties.argArrayToProps:([Ljava/lang/String;Ljava/lang/String;)Lorg/hsqldb/persist/HsqlProperties;
            astore 2 /* props */
        start local 2 // org.hsqldb.persist.HsqlProperties props
         2: .line 1011
            aload 1 /* test */
            aload 2 /* props */
            ldc "test.bigops"
            aload 1 /* test */
            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: .line 1012
            aload 1 /* test */
            aload 1 /* test */
            getfield org.hsqldb.test.TestCacheSize.bigops:I
            putfield org.hsqldb.test.TestCacheSize.bigrows:I
         4: .line 1013
            aload 1 /* test */
            aload 1 /* test */
            getfield org.hsqldb.test.TestCacheSize.bigops:I
            bipush 8
            idiv
            putfield org.hsqldb.test.TestCacheSize.smallops:I
         5: .line 1014
            aload 1 /* test */
            aload 2 /* props */
            ldc "test.scale"
         6: .line 1015
            aload 1 /* test */
            getfield org.hsqldb.test.TestCacheSize.cacheScale:I
         7: .line 1014
            invokevirtual org.hsqldb.persist.HsqlProperties.getIntegerProperty:(Ljava/lang/String;I)I
            putfield org.hsqldb.test.TestCacheSize.cacheScale:I
         8: .line 1016
            aload 1 /* test */
            aload 2 /* props */
            ldc "test.tabletype"
            aload 1 /* test */
            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: .line 1017
            aload 1 /* test */
            aload 2 /* props */
            ldc "test.nio"
            aload 1 /* test */
            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: .line 1019
            aload 2 /* props */
            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: .line 1020
            aload 1 /* test */
            ldc "mem:test"
            putfield org.hsqldb.test.TestCacheSize.filepath:Ljava/lang/String;
        12: .line 1021
            aload 1 /* test */
            iconst_0
            putfield org.hsqldb.test.TestCacheSize.filedb:Z
        13: .line 1022
            aload 1 /* test */
            iconst_0
            putfield org.hsqldb.test.TestCacheSize.shutdown:Z
        14: .line 1025
      StackMap locals: org.hsqldb.test.TestCacheSize org.hsqldb.persist.HsqlProperties
      StackMap stack:
            aload 1 /* test */
            invokevirtual org.hsqldb.test.TestCacheSize.setUp:()V
        15: .line 1027
            new org.hsqldb.lib.StopWatch
            dup
            invokespecial org.hsqldb.lib.StopWatch.<init>:()V
            astore 3 /* sw */
        start local 3 // org.hsqldb.lib.StopWatch sw
        16: .line 1029
            aload 1 /* test */
            invokevirtual org.hsqldb.test.TestCacheSize.testFillUp:()V
        17: .line 1030
            aload 1 /* test */
            invokevirtual org.hsqldb.test.TestCacheSize.checkResults:()V
        18: .line 1032
            aload 3 /* sw */
            invokevirtual org.hsqldb.lib.StopWatch.elapsedTime:()J
            lstore 4 /* time */
        start local 4 // long time
        19: .line 1034
            aload 1 /* test */
            ldc "total test time"
            iconst_0
            lload 4 /* time */
            l2i
            i2l
            lconst_0
            invokevirtual org.hsqldb.test.TestCacheSize.storeResult:(Ljava/lang/String;IJJ)V
        20: .line 1035
            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 /* sw */
            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: .line 1036
            aload 1 /* test */
            invokevirtual org.hsqldb.test.TestCacheSize.tearDown:()V
        22: .line 1037
            return
        end local 4 // long time
        end local 3 // org.hsqldb.lib.StopWatch sw
        end local 2 // org.hsqldb.persist.HsqlProperties props
        end local 1 // org.hsqldb.test.TestCacheSize test
        end local 0 // java.lang.String[] argv
      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"