QueryTime

--00000000000075f63c0599c76f5b
Content-Type: text/plain; charset="UTF-8"

my query times are  using my program below






*connecting to Postgres Database .....John  Casserole  Y  2012-04-11Sandy
 Key Lime Tarts  N  2012-04-14Tom  BBQ  Y  2012-04-18Tina  Salad  Y
 2012-04-18query time taken miiliseconds 6Connection + 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) ); }}*

--00000000000075f63c0599c76f5b
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div>my query times are=C2=A0 using my program below <br><=
/div><div><b>connecting to Postgres Database .....<br>John =C2=A0Casserole =
=C2=A0Y =C2=A02012-04-11<br>Sandy =C2=A0Key Lime Tarts =C2=A0N =C2=A02012-0=
4-14<br>Tom =C2=A0BBQ =C2=A0Y =C2=A02012-04-18<br>Tina =C2=A0Salad =C2=A0Y =
=C2=A02012-04-18<br>query time taken miiliseconds 6<br>Connection + query t=
ime miiliseconds 321</b></div><div><br></div><div>pgadmin TOOL=C2=A0 query =
time is a approx. <b>63 -66 milliseconds</b></div><div><b>select * from pot=
luck;</b></div><div>what=C2=A0 time interval is being measured for that tim=
e.</div><div><br></div><b>import java.sql.Connection;<br>import java.sql.Dr=
iverManager;<br>import java.sql.ResultSet;<br>import java.sql.Statement;<br=
><br>public class QueryTable {<br><br>	public static void main(String[] arg=
s) {<br>		long Start =3D 0;<br>		long queryTime =3D 0;<br>		try {<br>			<br=
>			System.out.println(&quot;connecting to Postgres Database .....&quot;);<=
br>			Connection conn =3D null;<br>			Statement stmt =3D null;<br>			<br>		=
	Start =3D System.currentTimeMillis();<br>	 =C2=A0 =C2=A0 =C2=A0 =C2=A0 Cla=
ss.forName(&quot;org.postgresql.Driver&quot;);<br>	 =C2=A0 =C2=A0 =C2=A0 =
=C2=A0 conn =3D DriverManager<br>	 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=
=A0.getConnection(&quot;jdbc:postgresql://localhost:5432/events&quot;,<br>	=
 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0&quot;postgres&quot;, &quot;sunri=
se&quot;);<br>	 =C2=A0 =C2=A0 =C2=A0 =C2=A0 <br>	 =C2=A0 =C2=A0 =C2=A0 =C2=
=A0stmt =3D conn.createStatement();<br>			queryTime =3D System.currentTimeM=
illis();<br>			ResultSet rs=3Dstmt.executeQuery(&quot;select * from potluck=
&quot;);<br>			while(rs.next())<br>				 System.out.println(rs.getString(&qu=
ot;name&quot;)+&quot; =C2=A0&quot;+<br>=C2=A0						 =C2=A0 =C2=A0 =C2=A0 =
=C2=A0 =C2=A0 =C2=A0rs.getString(&quot;food&quot;)+&quot; =C2=A0&quot;+<br>=
									rs.getString(&quot;confirmed&quot;)+&quot; =C2=A0&quot;+<br>						=
 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0rs.getString(&quot;signup_date&qu=
ot;));<br>			conn.close();<br>		 =C2=A0} catch (Exception e){ System.out.pr=
intln(e);} <br><br>	 =C2=A0 =C2=A0 =C2=A0long End =3D System.currentTimeMil=
lis();<br>	 =C2=A0 =C2=A0 =C2=A0System.out.println(&quot; query time taken =
miiliseconds &quot; + =C2=A0(End - queryTime) );<br>	 =C2=A0 =C2=A0 =C2=A0S=
ystem.out.println(&quot;Connection + query time miiliseconds &quot; + =C2=
=A0(End - Start) );<br>	}<br><br>}</b><br></div>

--00000000000075f63c0599c76f5b--