Re: Long running JDBC session

[David Smith]

You could try writing your queries so fewer are done.  3000 "quick" 
queries is 3000 command parses + 3000 actual query executions.  That's a 
lot of work for the database engine.  Fewer queries (1 if possible) 
would drastically increase performance.

--David

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]