Are you using connection pooling? If so which one? How many connections?
Why are you not using the latest jar from oracle? You should download the 9i driver.
What is your code for how you obtain connection and how you create statements. Are you using PreparedStatements?
Nathan
On May 4, 2004, at 2:31 PM, Carlos-Roberto Queiroz wrote:
Hello, I have a servlet that connects to an Oracle database (9i)
using classes12.jar JDBC file. In it, there�s a loop that executes a quick
query 3000 times, and that�s running for long 10 minutes !! Is there any
way I can optimize this connection (JDBC parameters maybe) for such case ?
Thanks
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
