aspose file tools*
The moose likes JDBC and the fly likes Jdbc q Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Jdbc q" Watch "Jdbc q" New topic
Author

Jdbc q

NileshJ Njadhav
Greenhorn

Joined: Jan 18, 2011
Posts: 3
Difference between statement and prepare statement?
Mohamed Sanaulla
Saloon Keeper

Joined: Sep 08, 2007
Posts: 3068
    
  33

NileshJ Njadhav wrote:Difference between statement and prepare statement?

Statement and PreparedStatement.


Mohamed Sanaulla | My Blog
NileshJ Njadhav
Greenhorn

Joined: Jan 18, 2011
Posts: 3
thanks
Martin Vajsar
Sheriff

Joined: Aug 22, 2010
Posts: 3610
    
  60

Sometimes people test the speed of a Statement vs. PreparedStatement and notice that if the Statement is executed only a handful of times, it is slightly faster, so they conclude the Statement is the way to go if you execute it less than, say, 10 times in your application. This is, of course, not a good idea because of SQL injection anyway, but even the performance perspective is wrong. If the application is actually used by many (say, 100) users and each user invokes the 10-statement functionality, the DB gets hit by these Statements thousand times, not ten times. Which means the load on the DB is much higher and the PrepareStatement would clearly win performance-wise.

I haven't ever seen a Statement/PreparedStatement performance comparison which would mention it, so I thought I'd point it out here.
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Jdbc q