Re: JDBC application design issue.
Tuesday, March 30, 2004 11:22 AM
Depending on the database server you are using, define Stored procedures for queries that you said are being used multiple times in your code. This makes the database transactions significantly faster since the the query does'nt need to be compiled every time before being executed (like it was happening before). If you need to know how to build stored procedures there are a bunch of tutorials on the web that can help you with that.