| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> comp.databases.theory -> Query from program is much slower than sql client.
Hi folks:
This may seem like a simple question with an obvious answer but I am perplexed by it. I have a query that when I run in my Oracle 9i client (SQLPlus or Tora), runs very quickly, giving me results instantly. But if I run it from a coded program in Java (JDBC) or Perl (DBI), it takes a minute to display the results. I am thinking this has to do with the client holding cursors or something else but I think I am missing something. Thanks in advance for your insight. Received on Wed Jun 04 2003 - 20:22:08 CDT
![]() |
![]() |