hsqldbcachedbenchmark.java

多种开源数据库（mysql、hsqldb、derby等等）性能比较源文件

/*
 * HsqldbCachedBenchmark.java
 *
 * Created on 07 March 2005, 13:04
 */

package com.ideasasylum.dbbenchmark;

/**
 *
 * @author jel03r
 */
public class HsqldbCachedBenchmark extends HsqldbBenchmark {
    private static final String CREATE = "CREATE CACHED TABLE test (" +
            "id INTEGER GENERATED BY DEFAULT AS IDENTITY," +
            "name VARCHAR( 254 ) NOT NULL," +
            "value INT NOT NULL," +
            "date DATE NOT NULL," +
            "longnumber BIGINT NOT NULL," +
            "floatnumber FLOAT NOT NULL," +
            "PRIMARY KEY ( id ))";
    
    /** Creates a new instance of HsqldbCachedBenchmark */
    public HsqldbCachedBenchmark() {
    }

    protected String getCreateSQL() {
        return CREATE;
    }
}