Subject | Fetch large ResultSet |
---|---|
Author | |
Post date | 2017-10-06T12:12:12Z |
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