• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

multiple statements

 
Peter Guillebaud
Ranch Hand
Posts: 57
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
Is it better to create and close a new statement object for each ResultSet? Or is it more efficient to use the same statement object for many queries and then close it when they're all done. (Using ms sql and odbc driver).
Many thanks.
 
Peter den Haan
author
Ranch Hand
Posts: 3252
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Most efficient is to use a PreparedStatement. You'd have to create a new one for every query, but the database will be able to cache them.
- Peter
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic