Examples of org.hsqldb.lib.StopWatch

org.hsqldb.lib.StopWatch
Provides the programatic analog of a physical stop watch.
The watch can be started, stopped and zeroed and can be queried for elapsed running time. The watch accumulates elapsed time over starts and stops such that only the time actually spent running is recorded. If the watch is zeroed, then the accumulated time is discarded and the watch starts again with zero acumulated time.
@author boucherb@users @version 1.7.2 @since 1.7.2


        int[]     sample     = getSampleIntArray(intLookup, 100);
        int[]     sampleVals = new int[sample.length];
        int       i          = 0;
        int       j          = 0;
        StopWatch sw         = new StopWatch();


        try {
            for (j = 0; j < 10000; j++) {
                for (i = 0; i < sample.length; i++) {
                    int pos = intLookup.findFirstEqualKeyIndex(sample[i]);


                    sampleVals[i] = intLookup.getValue(pos);


                    intLookup.remove(pos);
                }


                for (i = 0; i < sample.length; i++) {
                    intLookup.addUnique(sample[i], sampleVals[i]);
                }
            }


            System.out.println(
                sw.elapsedTimeToMessage("Double int table times"));
            intLookup.findFirstEqualKeyIndex(0);    // sort
            compareByHIteratorInt(intLookup, hIntMap);
        } catch (Exception e) {
            System.out.println(
                sw.elapsedTimeToMessage("Double int table error: i =" + i));


            failed = true;
        }


        assertTrue(!failed);

View Full Code Here

        Statement dummy = new StatementDML(StatementTypes.UPDATE_CURSOR,
                                           StatementTypes.X_SQL_DATA_CHANGE,
                                           null);


        try {
            StopWatch sw     = new StopWatch();
            Crypto    crypto = database.logger.getCrypto();


            if (crypto == null) {
                scr = new ScriptReaderText(database, logFilename);
            } else {

View Full Code Here

    static int count = 100000;


    public TestLibSpeed() {


        java.util.Random randomgen = new java.util.Random();
        StopWatch        sw        = new StopWatch();
        int              dummy     = 0;


        System.out.println("set lookup ");


        for (int k = 0; k < 3; k++) {
            sw.zero();


            for (int j = 0; j < count; j++) {
                for (int i = 0; i < sNumeric.length; i++) {
                    int r = randomgen.nextInt(sNumeric.length);


                    hashSet.contains(sNumeric[r][0]);


                    dummy += r;
                }
            }


            System.out.println("HashSet contains " + sw.elapsedTime());
            sw.zero();


            for (int j = 0; j < count; j++) {
                for (int i = 0; i < sNumeric.length; i++) {
                    int r = randomgen.nextInt(sNumeric.length);


                    intKeyIntValueHashLookup.get(r, -1);


                    dummy += r;
                }
            }


            System.out.println("IntKeyIntValueHashMap Lookup with array "
                               + sw.elapsedTime());
            sw.zero();


            for (int j = 0; j < count; j++) {
                for (int i = 0; i < sNumeric.length; i++) {
                    int r = randomgen.nextInt(sNumeric.length);


                    intKeyHashLookup.get(r);


                    dummy += r;
                }
            }


            System.out.println("IntKeyHashMap Lookup " + sw.elapsedTime());
            sw.zero();


            for (int j = 0; j < count; j++) {
                for (int i = 0; i < sNumeric.length; i++) {
                    int r = randomgen.nextInt(sNumeric.length);


                    doubleIntLookup.findFirstEqualKeyIndex(r);


                    dummy += r;
                }
            }


            System.out.println("DoubleIntTable Lookup " + sw.elapsedTime());
            sw.zero();


            for (int j = 0; j < count; j++) {
                for (int i = 0; i < sNumeric.length; i++) {
                    int r = randomgen.nextInt(sNumeric.length);


                    intValueHashLookup.get(sNumeric[r][0], 0);


                    dummy += r;
                }
            }


            System.out.println("IntKeyIntValueHashMap Lookup "
                               + sw.elapsedTime());
            sw.zero();


            for (int j = 0; j < count; j++) {
                for (int i = 0; i < sNumeric.length; i++) {
                    int r = randomgen.nextInt(sNumeric.length);


                    dummy += r;
                }
            }


            System.out.println("emptyOp " + sw.elapsedTime());
            sw.zero();


            for (int j = 0; j < count; j++) {
                for (int i = 0; i < sNumeric.length; i++) {
                    int r = randomgen.nextInt(sNumeric.length);


                    doubleIntLookup.findFirstEqualKeyIndex(r);


                    dummy += r;
                }
            }


            System.out.println("DoubleIntTable Lookup " + sw.elapsedTime());
            sw.zero();
            System.out.println("Object Cache Test " + sw.elapsedTime());
        }
    }

View Full Code Here

        PreparedStatement insertStmnt;
        PreparedStatement updateStmnt;
        PreparedStatement selectStmnt;
        PreparedStatement deleteStmnt;
        PreparedStatement callStmnt;
        StopWatch         sw;


        println("---------------------------------------");
        println("Preparing Statements:");
        println("---------------------------------------");
        println(insert_sql);
        println(update_sql);
        println(select_sql);
        println(delete_sql);
        println(call_sql);


        sw = new StopWatch();


        // prepare the statements
        insertStmnt = conn.prepareStatement(insert_sql,
                                            Statement.RETURN_GENERATED_KEYS);
        updateStmnt = conn.prepareStatement(update_sql);
        selectStmnt = conn.prepareStatement(select_sql);
        deleteStmnt = conn.prepareStatement(delete_sql);
        callStmnt   = conn.prepareCall(call_sql);


        println("---------------------------------------");
        println(sw.elapsedTimeToMessage("statements prepared"));
        println("---------------------------------------");
        sw.zero();


        // set up the batch data
        for (int i = 0; i < rows; i++) {
            insertStmnt.setInt(1, i);
            insertStmnt.setString(2, "Julia");
            insertStmnt.setString(3, "Peterson-Clancy");
            insertStmnt.setInt(4, i);
            updateStmnt.setInt(1, i);
            selectStmnt.setInt(1, i);
            deleteStmnt.setInt(1, i);
            insertStmnt.addBatch();
            updateStmnt.addBatch();
            selectStmnt.addBatch();
            deleteStmnt.addBatch();
            callStmnt.addBatch();
        }


        println("---------------------------------------");
        println(sw.elapsedTimeToMessage("" + 5 * rows
                                        + " batch entries created"));
        sw.zero();


        // do the test loop forever
        for (int i = 0; i < 1; i++) {
            println("---------------------------------------");


            // inserts
            sw.zero();
            insertStmnt.executeBatch();
            printCommandStats(sw, "inserts");


            ResultSet    generated = insertStmnt.getGeneratedKeys();
            StringBuffer sb        = new StringBuffer();


            while (generated.next()) {
                int gen = generated.getInt(1);


                if (gen % 1000 == 0) {
                    sb.append(gen).append(" - ");
                }
            }


            System.out.println(sb.toString());
            printCommandStats(sw, "generated reads");


            // updates
            sw.zero();
            updateStmnt.executeBatch();
            printCommandStats(sw, "updates");


            // selects
            sw.zero();


//            selectStmnt.executeBatch();
//            printCommandStats(sw, "selects");
            // deletes
            sw.zero();
            deleteStmnt.executeBatch();
            printCommandStats(sw, "deletes");


            // calls
            sw.zero();


//            callStmnt.executeBatch();
//            printCommandStats(sw, "calls  ");
        }
    }

View Full Code Here

    static final private String TIMESTAMP_VAR_STR = "${timestamp}";
    static final String LS = System.getProperty("line.separator", "\n");


    public static void main(String[] argv) {


        StopWatch sw = new StopWatch(true);


        TestUtil.testScripts("testrun/hsqldb");
        System.out.println(sw.currentElapsedTimeToMessage("Total time :"));
    }

View Full Code Here

     *
     *
     */
    public void testFillUp() {


        StopWatch sw    = new StopWatch();
        String    ddl1  = "DROP TABLE test IF EXISTS";
        String    ddl11 = "DROP TABLE zip IF EXISTS";
        String    ddl2  = "CREATE TABLE zip( zip INT IDENTITY )";
        String ddl3 = "CREATE " + tableType + " TABLE test( id INT IDENTITY,"
                      + " firstname VARCHAR(20), " + " lastname VARCHAR(20), "
                      + " zip INTEGER, " + " filler VARCHAR(300))";
        String ddl31 = "SET TABLE test SOURCE \"test.csv;cache_scale="
                       + cacheScale + "\"";


        // adding extra index will slow down inserts a bit
        String ddl4 = "CREATE INDEX idx1 ON TEST (lastname)";


        // adding this index will slow down  inserts a lot
        String ddl5 = "CREATE INDEX idx2 ON TEST (zip)";


        // referential integrity checks will slow down inserts a bit
        String ddl6 =
            "ALTER TABLE test add constraint c1 FOREIGN KEY (zip) REFERENCES zip(zip) ON DELETE CASCADE;";
        String ddl7 = "CREATE TEMP TABLE temptest( id INT,"
                      + " firstname VARCHAR, " + " lastname VARCHAR, "
                      + " zip INTEGER, " + " filler VARCHAR)";
        String mddl1 = "DROP TABLE test2 IF EXISTS";
        String mddl2 = "CREATE " + tableType
                       + " TABLE test2( id1 INT, id2 INT,"
                       + " firstname VARCHAR, " + " lastname VARCHAR, "
                       + " zip INTEGER, " + " filler VARCHAR, "
                       + " PRIMARY KEY (id1,id2) )";
        String mdd13 = "SET TABLE test2 SOURCE \"test2.csv;cache_scale="
                       + cacheScale + "\"";


        try {


//            System.out.println("Connecting");
            sw.zero();


            cConnection = null;
            sStatement  = null;
            cConnection = DriverManager.getConnection(url + filepath, user,
                    password);


            System.out.println("connection time -- " + sw.elapsedTime());
            sw.zero();


            sStatement = cConnection.createStatement();


            java.util.Random randomgen = new java.util.Random();


//            sStatement.execute("SET WRITE_DELAY " + writeDelay);
            sStatement.execute(ddl1);
            sStatement.execute(ddl2);
            sStatement.execute(ddl3);


            if (tableType.equals("TEXT")) {
                sStatement.execute(ddl31);
            }


//            System.out.println("test table with no index");
            if (indexLastName) {
                sStatement.execute(ddl4);
                System.out.println("created index on lastname");
            }


            if (indexZip) {
                sStatement.execute(ddl5);
                System.out.println("created index on zip");
            }


            if (addForeignKey) {
                sStatement.execute(ddl6);
                System.out.println("added foreign key");
            }


            if (createTempTable) {
                sStatement.execute(ddl7);
                System.out.println("created temp table");
            }


            if (multikeytable) {
                sStatement.execute(mddl1);
                sStatement.execute(mddl2);


                if (tableType.equals("TEXT")) {
                    sStatement.execute(mdd13);
                }


                System.out.println("created multi key table");
            }


//            sStatement.execute("CREATE INDEX idx3 ON tempTEST (zip);");
            System.out.println("complete setup time -- " + sw.elapsedTime()
                               + " ms");
            fillUpBigTable(filler, randomgen);


            if (multikeytable) {
                fillUpMultiTable(filler, randomgen);
            }


            sw.zero();


            if (shutdown) {
                sStatement.execute("SHUTDOWN");


                long time = sw.elapsedTime();


                storeResult("shutdown", 0, time, 0);
                System.out.println("shutdown time  -- " + time + " ms");
            }

View Full Code Here

    }


    private void fillUpBigTable(String filler,
                                Random randomgen) throws SQLException {


        StopWatch sw = new StopWatch();
        int       i;
        PreparedStatement ps =
            cConnection.prepareStatement("INSERT INTO zip VALUES(?)");


        for (i = 0; i <= smallrows; i++) {
            ps.setInt(1, i);
            ps.execute();
        }


        ps.close();
        sStatement.execute("SET DATABASE REFERENTIAL INTEGRITY "
                           + this.refIntegrity);


        ps = cConnection.prepareStatement(
            "INSERT INTO test (firstname,lastname,zip,filler) VALUES (?,?,?,?)");


        ps.setString(1, "Julia");
        ps.setString(2, "Clancy");


        for (i = 0; i < bigrows; i++) {
            ps.setInt(3, nextIntRandom(randomgen, smallrows));


            {


                // small rows
                long nextrandom   = randomgen.nextLong();
                int  randomlength = (int) nextrandom & 0x7f;


                if (randomlength > filler.length()) {
                    randomlength = filler.length();
                }


                String varfiller = filler.substring(0, randomlength);


                ps.setString(4, nextrandom + varfiller);
            }


/*
            {
                // big rows
                long nextrandom   = randomgen.nextLong();
                int  randomlength = (int) nextrandom & 0x7ff;


                if (randomlength > filler.length() * 20) {
                    randomlength = filler.length() * 20;
                }


                StringBuffer sb = new StringBuffer(0xff);


                for (int j = 0; j < 20; j++) {
                    sb.append(filler);
                }


                String varfiller = sb.substring(0, randomlength);


                ps.setString(4, nextrandom + varfiller);
            }
*/
            ps.execute();


            if (reportProgress && (i + 1) % 10000 == 0) {
                System.out.println("insert " + (i + 1) + " : "
                                   + sw.elapsedTime());
            }


            // delete and add 4000 rows to introduce fragmentation
            if (deleteWhileInsert && i != 0
                    && i % deleteWhileInsertInterval == 0) {
                sStatement.execute("CALL IDENTITY();");


                ResultSet rs = sStatement.getResultSet();


                rs.next();


                int lastId = rs.getInt(1);


                sStatement.execute(
                    "SELECT * INTO TEMP tempt FROM test WHERE id > "
                    + (lastId - 4000));
                sStatement.execute("DELETE FROM test WHERE id > "
                                   + (lastId - 4000));
                sStatement.execute("INSERT INTO test SELECT * FROM tempt");
                sStatement.execute("DROP TABLE tempt");
            }
        }


        ps.close();


//            sStatement.execute("INSERT INTO test SELECT * FROM temptest;");
//            sStatement.execute("DROP TABLE temptest;");
//            sStatement.execute(ddl7);
        long time = sw.elapsedTime();
        long rate = ((long) i * 1000) / (time + 1);


        storeResult("insert", i, time, rate);
        System.out.println("insert time for " + i + " rows -- " + time
                           + " ms -- " + rate + " tps");

View Full Code Here

    }


    private void fillUpMultiTable(String filler,
                                  Random randomgen) throws SQLException {


        StopWatch sw = new StopWatch();
        int       i;
        PreparedStatement ps = cConnection.prepareStatement(
            "INSERT INTO test2 (id1, id2, firstname,lastname,zip,filler) VALUES (?,?,?,?,?,?)");


        ps.setString(3, "Julia");
        ps.setString(4, "Clancy");


        int id1 = 0;


        for (i = 0; i < bigrows; i++) {
            int id2 = nextIntRandom(randomgen, Integer.MAX_VALUE);


            if (i % 1000 == 0) {
                id1 = nextIntRandom(randomgen, Integer.MAX_VALUE);
            }


            ps.setInt(1, id1);
            ps.setInt(2, id2);
            ps.setInt(5, nextIntRandom(randomgen, smallrows));


            long nextrandom   = randomgen.nextLong();
            int  randomlength = (int) nextrandom & 0x7f;


            if (randomlength > filler.length()) {
                randomlength = filler.length();
            }


            String varfiller = filler.substring(0, randomlength);


            ps.setString(6, nextrandom + varfiller);


            try {
                ps.execute();
            } catch (SQLException e) {
                e.printStackTrace();
            }


            if (reportProgress && (i + 1) % 10000 == 0) {
                System.out.println("insert " + (i + 1) + " : "
                                   + sw.elapsedTime());
            }
        }


        ps.close();
        System.out.println("total multi key rows inserted: " + i);
        System.out.println("insert time: " + sw.elapsedTime() + " rps: "
                           + (i * 1000 / (sw.elapsedTime() + 1)));
    }

View Full Code Here

    }


    protected void checkResults() {


        try {
            StopWatch sw = new StopWatch();
            ResultSet rs;


            cConnection = DriverManager.getConnection(url + filepath, user,
                    password);


            long time = sw.elapsedTime();


            storeResult("reopen", 0, time, 0);
            System.out.println("database reopen time -- " + time + " ms");
            sw.zero();


            sStatement = cConnection.createStatement();


//            sStatement.execute("SET WRITE_DELAY " + writeDelay);
            checkSelects();
            checkUpdates();
            sw.zero();


            if (shutdown) {
                sStatement.execute("SHUTDOWN");


                time = sw.elapsedTime();


                storeResult("shutdown", 0, time, 0);
                System.out.println("shutdown time  -- " + time + " ms");
            }

View Full Code Here

        }
    }


    void selectZip() {


        StopWatch        sw        = new StopWatch();
        java.util.Random randomgen = new java.util.Random();
        int              i         = 0;
        boolean          slow      = false;


        try {
            PreparedStatement ps = cConnection.prepareStatement(
                "SELECT TOP 1 firstname,lastname,zip,filler FROM test WHERE zip = ?");


            for (; i < bigops; i++) {
                ps.setInt(1, nextIntRandom(randomgen, smallrows));
                ps.execute();


                if ((i + 1) == 100 && sw.elapsedTime() > 50000) {
                    slow = true;
                }


                if (reportProgress && (i + 1) % 10000 == 0
                        || (slow && (i + 1) % 100 == 0)) {
                    System.out.println("Select " + (i + 1) + " : "
                                       + sw.elapsedTime() + " rps: "
                                       + (i * 1000 / (sw.elapsedTime() + 1)));
                }
            }
        } catch (SQLException e) {
            e.printStackTrace();
        }


        long time = sw.elapsedTime();
        long rate = ((long) i * 1000) / (time + 1);


        storeResult("select random zip", i, time, rate);
        System.out.println("select time for random zip " + i + " rows  -- "
                           + time + " ms -- " + rate + " tps");

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

Related Classes of org.hsqldb.lib.StopWatch

complex.connectivity.hsqldb.TestCacheSize

complex.connectivity.HsqlDriverTest

org.hsqldb.persist.DataFileCache

org.hsqldb.persist.ScriptRunner

org.hsqldb.Server

org.hsqldb.server.Server

org.hsqldb.test.TestAllTypes

org.hsqldb.test.TestAnother

org.hsqldb.test.TestBatchExecution

org.hsqldb.test.TestCacheSize

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.