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.

            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


            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


            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


            ResultSet rs = sStatement.getResultSet();


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


    private void updateZip() {

View Full Code Here


                count += ps.executeUpdate();


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


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

View Full Code Here

        } 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

                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();

View Full Code Here


                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) {

View Full Code Here

        } 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

                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();

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.