Examples of org.hsqldb.lib.StopWatch.elapsedTime()

org.hsqldb.lib.StopWatch.elapsedTime()
Retrieves the accumulated time this object has spent running since it was last zeroed. @return the accumulated time this object has spent running sinceit was last zeroed.

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


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


            sStatement = cConnection.createStatement();


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

View Full Code Here

                ps.setString(8, 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) {

View Full Code Here


//            sStatement.execute("INSERT INTO test SELECT * FROM temptest;");
//            sStatement.execute("DROP TABLE temptest;");
//            sStatement.execute(ddl7);
            System.out.println("Total insert: " + i);
            System.out.println("Insert time: " + sw.elapsedTime() + " rps: "
                               + (i * 1000 / sw.elapsedTime()));
            sw.zero();


            if (!network) {
                sStatement.execute("SHUTDOWN");

View Full Code Here

//            sStatement.execute("INSERT INTO test SELECT * FROM temptest;");
//            sStatement.execute("DROP TABLE temptest;");
//            sStatement.execute(ddl7);
            System.out.println("Total insert: " + i);
            System.out.println("Insert time: " + sw.elapsedTime() + " rps: "
                               + (i * 1000 / sw.elapsedTime()));
            sw.zero();


            if (!network) {
                sStatement.execute("SHUTDOWN");
            }

View Full Code Here

            if (!network) {
                sStatement.execute("SHUTDOWN");
            }


            cConnection.close();
            System.out.println("Shutdown Time: " + sw.elapsedTime());
        } catch (SQLException e) {
            System.out.println(e.getMessage());
        }
    }

View Full Code Here

            ResultSet rs;


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


            System.out.println("Reopened database: " + sw.elapsedTime());
            sw.zero();


            sStatement = cConnection.createStatement();


            sStatement.execute("SET WRITE_DELAY " + writeDelay);

View Full Code Here


            rs = sStatement.getResultSet();


            rs.next();
            System.out.println("Row Count: " + rs.getInt(1));
            System.out.println("Time to count: " + sw.elapsedTime());


            // use index on zip
            sw.zero();
            sStatement.execute("SELECT count(*) from TEST where zip > -1");

View Full Code Here


            rs = sStatement.getResultSet();


            rs.next();
            System.out.println("Row Count: " + rs.getInt(1));
            System.out.println("Time to count: " + sw.elapsedTime());
            checkSelects();
            checkUpdates();
            sw.zero();
            cConnection.close();
            System.out.println("Closed connection: " + sw.elapsedTime());

View Full Code Here

            System.out.println("Time to count: " + sw.elapsedTime());
            checkSelects();
            checkUpdates();
            sw.zero();
            cConnection.close();
            System.out.println("Closed connection: " + sw.elapsedTime());
        } catch (SQLException e) {
            System.out.println(e.getMessage());
        }
    }

View Full Code Here

                    "SELECT TOP 1 firstname,lastname,zip,filler FROM test WHERE zip = ?");


                ps.setInt(1, nextIntRandom(randomgen, smallrows));
                ps.execute();


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


                if (reportProgress && (i + 1) % 10000 == 0
                        || (slow && (i + 1) % 100 == 0)) {

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

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.