hi all
I am accessing the table to display its contents using
JSP and
JDBC That table is having more than 400 records and it takes too much time to load.The table is having only two columns and it is a look up table.
The code is something like this
Statement stmt = conn.createStatement();
ResultSet rst=stmt.executeQuery("SELECT * FROM lookup");
while(rst.next())
{
City= rst.getString(1);
%>
<tr>
<td > <h4><%out.println(City);%></h4></td>
<%
Pop= rst.getString(2);
%>
<td > <%out.println(Pop);%></h4></td>
</tr>
Can anyone suggest a suitable method to reduce the accessing time
Sankar