Start row?

Discussions

Performance and scalability: Start row?

  1. Start row? (2 messages)

    When performing a row limited query, is it wiser to use ResultSet.abosolute(rowNr) to find your starting row than simply tell the database what row you want to start read from?

    /John

    Threaded Messages (2)

  2. Start row?[ Go to top ]

    When performing a row limited query, is it wiser to use ResultSet.abosolute(rowNr) to find your starting row than simply tell the database what row you want to start read from?

    >
    > /John

    that will return all the results in the database and then select the desired row , but if you tell the database what row you want to start with the result set will be smaller
  3. JDBC Performance Tuning Tool[ Go to top ]

    You could also try using IronTrack SQL to find other places in your code to improve performance of your queries. There is a free trial available.