Is it expensive to hold on to PreparedStatements? (Java & JDBC)

Posted by sbook on Stack Overflow See other posts from Stack Overflow or by sbook
Published on 2010-06-12T21:07:00Z Indexed on 2010/06/12 21:12 UTC
Read the original article Hit count: 158

Filed under:
|
|
|

I'm trying to figure out if it's efficient for me to cache all of my statements when I create my database connection or if I should only create those that are most used and create the others if/when they're needed..

It seems foolish to create all of the statements in all of the client threads. Any feedback would be greatly appreciated.

© Stack Overflow or respective owner

Related posts about java

Related posts about mysql