Dear all, >From the DB Perspective, use of Prepared statement reduces the memory usage as prepared statement uses bind variables . The query is parsed once for several execution. It is always recommended to use prepared statement where ever possible .
Suresh >From: "Lai, Kenny" <[EMAIL PROTECTED]> >Reply-To: A mailing list about Java Server Pages specification and >reference <[EMAIL PROTECTED]> >To: [EMAIL PROTECTED] >Subject: PreparedStatement vs Statement >Date: Thu, 2 May 2002 14:41:20 -0400 > >is there a considerable difference, if I create PreparedStatement instead >of >Statement after i get my DB connection? >are there pitfalls i should be aware about (using PreparedStatement)? > >kenny > >=========================================================================== >To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff >JSP-INTEREST". >For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST >DIGEST". >Some relevant FAQs on JSP/Servlets can be found at: > > http://archives.java.sun.com/jsp-interest.html > http://java.sun.com/products/jsp/faq.html > http://www.esperanto.org.nz/jsp/jspfaq.jsp > http://www.jguru.com/faq/index.jsp > http://www.jspinsider.com _________________________________________________________________ Join the world�s largest e-mail service with MSN Hotmail. http://www.hotmail.com =========================================================================== To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST". For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST". Some relevant FAQs on JSP/Servlets can be found at: http://archives.java.sun.com/jsp-interest.html http://java.sun.com/products/jsp/faq.html http://www.esperanto.org.nz/jsp/jspfaq.jsp http://www.jguru.com/faq/index.jsp http://www.jspinsider.com
