1. This is a question for the
http://forum.java.sun.com/forum.jspa?forumID=31 java forum , not Tomcat.
2. Yes, it's an incredibly wasteful way of doing things. Change your sql so
the 'extra info' you need is included in the same query. Chances are if you
can do it with two queries you can do it with one.
Bob
Mohammed Zabin wrote:
>
> Hi All
> I have developed a web site that opens a recordset at start, and while
> looping through records of the main ResultSet i Open a new ResultSet for
> each record, to get a specific information, then close it. like this:
>
> while( rs.next() ) {
> Statement stmt = dbConn.createStatement();
> ResultSet newRs = stmt.executeQuery("SOME QUERY");
> ......
> .....
> *Some Code Here*
> .....
> .....
>
> stmt.close();
> newRs.close();
> }
>
> I feel that this way is resource-consuming, is it or not, and if it is,
> what
> is the best way to code this code??
>
> Thanks
>
>
--
View this message in context:
http://www.nabble.com/Performance-tf3975410.html#a11284672
Sent from the Tomcat - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To start a new topic, e-mail: users@tomcat.apache.org
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
