Is it expensive to hold on to PreparedStatements? (Java & JDBC)
- by sbook
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.