my query times are using my program below
connecting to Postgres Database .....
John Casserole Y 2012-04-11
Sandy Key Lime Tarts N 2012-04-14
Tom BBQ Y 2012-04-18
Tina Salad Y 2012-04-18
query time taken miiliseconds 6
Connection + query time miiliseconds 321
pgadmin TOOL query time is a approx. 63 -66 milliseconds
select * from potluck;
what time interval is being measured for that time.
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
public class QueryTable {
public static void main(String[] args) {
long Start = 0;
long queryTime = 0;
try {
System.out.println("connecting to Postgres Database .....");
Connection conn = null;
Statement stmt = null;
Start = System.currentTimeMillis();
Class.forName("org.postgresql.Driver");
conn = DriverManager
.getConnection("jdbc:postgresql://localhost:5432/events",
"postgres", "sunrise");
stmt = conn.createStatement();
queryTime = System.currentTimeMillis();
ResultSet rs=stmt.executeQuery("select * from potluck");
while(rs.next())
System.out.println(rs.getString("name")+" "+
rs.getString("food")+" "+
rs.getString("confirmed")+" "+
rs.getString("signup_date"));
conn.close();
} catch (Exception e){ System.out.println(e);}
long End = System.currentTimeMillis();
System.out.println(" query time taken miiliseconds " + (End - queryTime) );
System.out.println("Connection + query time miiliseconds " + (End - Start) );
}
}