Subject Fetch large ResultSet
Author

Hello,

I want to fetch a large ResultSet and write the result to a file and wonder how JayBird behaves regarding this.
Does it buffer the ResultSet in memory at all or is it a just cursor in the database?
Since the date is large I don't want to run out of memory.

Do I have to use pagination?


What about java.sql.Statement.setFetchSize(...)?


Thanks,

Hugo