Re: Difference between Statement and preparedStatement (for SQL databases) ?
From: Ben_ (reply_at_newsgroup.com)
Date: 10/16/04
- Next message: Oscar kind: "Re: Difference between Statement and preparedStatement (for SQL databases) ?"
- Previous message: Michael Borgwardt: "Re: Difference between Statement and preparedStatement (for SQL databases) ?"
- In reply to: Ken Philips: "Difference between Statement and preparedStatement (for SQL databases) ?"
- Next in thread: Oscar kind: "Re: Difference between Statement and preparedStatement (for SQL databases) ?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Date: Sat, 16 Oct 2004 20:57:27 +0200
See "When to Use a PreparedStatement Object" at
http://java.sun.com/docs/books/tutorial/jdbc/basics/prepared.html, for
example.
Notice the "it will *normally* reduce execution time". It seems the gain
depends on the RDMS. See
http://www.ajug.org/archive/ajug-members/10302/msg00044.html.
HTH.
- Next message: Oscar kind: "Re: Difference between Statement and preparedStatement (for SQL databases) ?"
- Previous message: Michael Borgwardt: "Re: Difference between Statement and preparedStatement (for SQL databases) ?"
- In reply to: Ken Philips: "Difference between Statement and preparedStatement (for SQL databases) ?"
- Next in thread: Oscar kind: "Re: Difference between Statement and preparedStatement (for SQL databases) ?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]