Re: Really large fetches

From: Robert John Andersen (robert_anderse..ridge-point.com)
Date: Wed Jun 19 2002 - 14:32:00 EDT

  • Next message: Andrus: "Suggested ideas for BETA"

    On Wed, 2002-06-19 at 12:57, Andrus wrote:

        At 12:47 PM 6/19/2002 -0400, you wrote:
    >Its not about the pages, its about retrieving sets of rows because its
    >faster to do that then 1 at a time.
        
        At the lowest level Java has access to - java.sql.ResultSet - you would
        still read one row at a time. This is how JDBC works, right? It is up to
        the driver to optimize the data transfer batches. For the classes that are
        being fed data from ResultSet this is totally transparent.

    Yes they are read one at a time from the ResultSet, not sure what I was
    thinking about ;). Oh well, guess thats what happens after having a day
    of golf and a movie.



    This archive was generated by hypermail 2.0.0 : Wed Jun 19 2002 - 14:33:25 EDT