Tutorial :Read a large result set in chunks from mysql



Question:

I am trying to read a huge result set from mysql. Reading them in a straight-forward manner didn't work, as mysql tries to return all results together, which times out.

I found the following piece of code which tells mysql to read the results back one at a time:

stmt = conn.createStatement(java.sql.ResultSet.TYPE_FORWARD_ONLY, java.sql.ResultSet.CONCUR_READ_ONLY);  stmt.setFetchSize(Integer.MIN_VALUE);  

Can I read a chunk at a time instead of one by one? I've tried setting fetch size to a different value, but it doesn't work.


Solution:1

In your query use pagination by setting limit and offset.


Note:If u also have question or solution just comment us below or mail us on toontricks1994@gmail.com
Previous
Next Post »