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

                           + time + " ms -- " + rate + " tps");
    }


    void selectID() {


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


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


            for (i = 0; i < smallops; i++) {
                ps.setInt(1, nextIntRandom(randomgen, bigrows - 1));
                ps.execute();


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


            ps.close();
        } catch (SQLException e) {
            e.printStackTrace();
        }


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


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

View Full Code Here

                           + time + " ms -- " + rate + " tps");
    }


    void selectZipTable() {


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


        try {
            PreparedStatement ps = cConnection.prepareStatement(
                "SELECT zip FROM zip WHERE zip = ?");


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


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


            ps.close();
        } catch (SQLException e) {
            e.printStackTrace();
        }


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


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

View Full Code Here

    }


    private void countTestID() {


        try {
            StopWatch sw = new StopWatch();


            // the tests use different indexes
            // use primary index
            sStatement.execute("SELECT count(*) from TEST where id > -1");


            ResultSet rs = sStatement.getResultSet();


            rs.next();


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


            storeResult("count (index on id)", rs.getInt(1), time, rate);
            System.out.println("count time (index on id) " + rs.getInt(1)
                               + " rows  -- " + time + " ms -- " + rate

View Full Code Here

    }


    private void countTestZip() {


        try {
            StopWatch sw = new StopWatch();


            sStatement.execute("SELECT count(*) from TEST where zip > -1");


            ResultSet rs = sStatement.getResultSet();


            rs.next();


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


            storeResult("count (index on zip)", rs.getInt(1), time, rate);
            System.out.println("count time (index on zip) " + rs.getInt(1)
                               + " rows  -- " + time + " ms -- " + rate

View Full Code Here

    }


    private void countZip() {


        try {
            StopWatch sw = new StopWatch();


            sStatement.execute("SELECT count(*) from zip where zip > -1");


            ResultSet rs = sStatement.getResultSet();


            rs.next();
            System.out.println("count time (zip table) " + rs.getInt(1)
                               + " rows  -- " + sw.elapsedTime() + " ms");
        } catch (SQLException e) {}
    }

View Full Code Here

        } catch (SQLException e) {}
    }


    private void updateZip() {


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


        try {
            PreparedStatement ps = cConnection.prepareStatement(
                "UPDATE test SET filler = filler || zip WHERE zip = ?");


            for (; i < smallrows; i++) {
                random = nextIntRandom(randomgen, smallrows - 1);


                ps.setInt(1, random);


                count += ps.executeUpdate();


                if (reportProgress && count % 10000 < 20) {
                    System.out.println("Update " + count + " : "
                                       + (sw.elapsedTime() + 1));
                }
            }


            ps.close();
        } catch (SQLException e) {
            System.out.println("error : " + random);
            e.printStackTrace();
        }


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


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

View Full Code Here

                           + time + " ms -- " + rate + " tps");
    }


    void updateID() {


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


        try {
            PreparedStatement ps = cConnection.prepareStatement(
                "UPDATE test SET zip = zip + 1 WHERE id = ? and zip <> "
                + smallrows);


            for (i = 0; i < smallops; i++) {
                random = nextIntRandom(randomgen, bigrows - 1);


                ps.setInt(1, random);
                ps.execute();


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


            ps.close();
        } catch (SQLException e) {
            System.out.println("error : " + random);
            e.printStackTrace();
        }


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


        storeResult("update with random id", i, time, rate);
        System.out.println("update time with random id " + i + " rows  -- "
                           + time + " ms -- " + rate + " tps");

View Full Code Here

                           + time + " ms -- " + rate + " tps");
    }


    void updateTestString() {


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


        try {
            PreparedStatement ps = cConnection.prepareStatement(
                "UPDATE test SET filler = ? WHERE id = ? and zip <> "
                + smallrows);


            for (i = 0; i < smallops * 2; i++) {
                random = nextIntRandom(randomgen, bigrows - 1);


                int randomLength = nextIntRandom(randomgen, filler.length());
                String newFiller = filler.substring(randomLength);


                ps.setString(1, newFiller);
                ps.setInt(2, random);
                ps.execute();


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


            ps.close();
        } catch (SQLException e) {
            System.out.println("error : " + random);
            e.printStackTrace();
        }


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


        storeResult("update with random id", i, time, rate);
        System.out.println("update time with random id " + i + " rows  -- "
                           + time + " ms -- " + rate + " tps");

View Full Code Here

                           + time + " ms -- " + rate + " tps");
    }


    void updateIDLinear() {


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


        try {
            PreparedStatement ps = cConnection.prepareStatement(
                "UPDATE test SET zip = zip + 1 WHERE id = ? and zip <> "
                + smallrows);


            for (i = 0; i < bigops; i++) {
                random = i;


                ps.setInt(1, random);
                ps.execute();


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


            ps.close();
        } catch (SQLException e) {
            System.out.println("error : " + random);
            e.printStackTrace();
        }


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


        storeResult("update with sequential id", i, time, rate);
        System.out.println("update time with sequential id " + i
                           + " rows  -- " + time + " ms -- " + rate + " tps");

View Full Code Here

                           + " rows  -- " + time + " ms -- " + rate + " tps");
    }


    void deleteTest() {


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


        try {
            PreparedStatement ps =
                cConnection.prepareStatement("DELETE FROM test WHERE id = ?");


            for (i = 0; count < smallops; i++) {
                random = nextIntRandom(randomgen, bigrows);


//                random = i;
                ps.setInt(1, random);


                count += ps.executeUpdate();


/*
                if ((i + 1) % 10000 == 0) {
                    Statement st = cConnection.createStatement();


                    st.execute("CHECKPOINT DEFRAG");
                    st.close();
                }
*/
                if (reportProgress && (i + 1) % 10000 == 0
                        || (slow && (i + 1) % 100 == 0)) {
                    System.out.println("delete " + (i + 1) + " : "
                                       + sw.elapsedTime() + " rps: "
                                       + (i * 1000 / (sw.elapsedTime() + 1)));
                }
            }


            ps.close();
        } catch (SQLException e) {
            System.out.println("error : " + random);
            e.printStackTrace();
        }


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


        storeResult("delete with random id", count, time, rate);
        System.out.println("delete time for random id " + count + " rows  -- "
                           + time + " ms -- " + rate + " tps");

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.