Results 1 to 4 of 4
  1. #1
    bezudar is offline Member
    Join Date
    Nov 2008
    Posts
    7
    Rep Power
    0

    Default How to speed sql Statements?

    i used batch in inserting values in db but select statement is taking time cos i have to do it one by one and that is taking time Is there some way i can execute select statements in batch and then get an array of resultsets and use them

  2. #2
    masijade is offline Senior Member
    Join Date
    Jun 2008
    Posts
    2,571
    Rep Power
    8

    Default

    It might help to know what it is your actually doing. Selecting a single row at a time is not the norm, so your question, as is, doesn't make sense.

  3. #3
    bezudar is offline Member
    Join Date
    Nov 2008
    Posts
    7
    Rep Power
    0

    Default

    oh sorry i am select an entry from one single column
    "SELECT (test) from TEST_NUMS where test=? AND test<=?"

  4. #4
    masijade is offline Senior Member
    Join Date
    Jun 2008
    Posts
    2,571
    Rep Power
    8

    Default

    You do know that the second part of the where clause is not necessary, and makes no sense in relation to the first part, right?

    In any case, I meant you need to explain exactly what it is you are doing. What are you doing with the "selected" row and how does it relate to the insert, and what is the insert query?

Similar Threads

  1. Pong Paddle Not Stopping Ball At Certain Speed
    By JDCAce in forum Java Applets
    Replies: 3
    Last Post: 04-01-2009, 11:07 PM
  2. Replies: 4
    Last Post: 10-22-2008, 11:11 PM
  3. Replies: 3
    Last Post: 09-16-2008, 11:55 AM
  4. Help with if else statements
    By zoe in forum New To Java
    Replies: 1
    Last Post: 07-24-2007, 07:56 PM
  5. compare speed
    By bbq in forum JDBC
    Replies: 1
    Last Post: 06-28-2007, 05:34 PM

Posting Permissions

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