Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2004
    Location
    India
    Posts
    3

    Thumbs up Unanswered: Too slow response through JDBC

    Dear All,

    I am facing problem in troubleshooting the unacceptably slow response of a java code, while fetching data from Oracle database. When tried to retrieve the same amount of records ( through the same query which was used earlier), from a custom console code, the response was tolerably fast. I wonder if anybody around will view these lines and respond with a positive, creative and yielding solution.

    These are the details of my Application configuration:

    Original code is in java, with EJB concepts implemented.
    Server is hosted by weblogic 8.0. webserver.
    Database is oracle, residing locally.
    Client is a browser, access to the application is through HTTP protocol.
    Request is a button click, processed by a JavaScript piece, submitted to the JSP, in turn to Servelet, and JDBC.
    Action is a harmless select query, to get data from a single table containing one lakh records.
    When requested, the browser falls into a swoon, and after an unspecified or random time period, the weblogic server vomits an exception out alognwith a chain of stack, which essentially says that the Servelet could not forward the response, which was already forwarded.

    Please help.

  2. #2
    Join Date
    Apr 2003
    Posts
    15

    Arrow Too slow response through JDBC

    Hi,

    Hope you are using JDBC Type IV driver( Oracle Thin driver ).
    Set connection.setAutoCommit(false);
    connection.setReadOnly(true);
    try to use Oracle SQL Hints like /*+ALL_ROWS */ , /*+FIRST_ROWS*/,
    /*+INDEX(col)*/

    These may increase the performance.

    Regards
    Chenna

  3. #3
    Join Date
    Feb 2004
    Location
    India
    Posts
    3
    Dear chenna,

    Thank you. I will experiment this proposal, and post the result in this column.

    As you assumed, I am using oracle thin driver for the database access.

    I am really not able to follow what you mean by Oracle Hints. Are they some directives to the SQL engine? You mean to modify the SQL sentence to get fast results? I am fetching all columns in the table. So can I use "select ALL_ROWS from SORTPACKAGELOGDATA"?

    I don't really require indexing I guess, sicne there is no other tables involved.

    Please reply.

    Thanks,
    Gireesh.

  4. #4
    Join Date
    Apr 2003
    Posts
    15

    Arrow

    Hi Gireesh,

    Yes, they are directives to Oracle SQL Engine.
    Hope this site will give you some knowledge about oracle HINTS.


    http://www.oradev.com/hints.jsp

    Regards
    Chenna

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •