[SNIP] I could be wrong, and please correct me if I am... But I thought a PreparedStatement just precompiled the statement on the database when the statement is prepared. How is that any more overhead than just using a normal Statement? When you use a normal statement and you execute the statement, it still has to be compiled on the database. So, either way, the statement is being compiled, it's just a matter of when.
djm > Preparing a statement carries a bit more overhead > than just creating a > Statement. The benefit is that if you're going to > use that prepared statement > multiple times, you'll start to see cost savings and > it becomes more > efficient than a statement. __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
