title: How to figure out the optimal fetch size for the select query
body: <p>In JDBC the default fetch size is 10, but I guess that's not the best fetch size when I have a million rows. I understand that a fetch size too low reduces performance, but also if the fetch size is too high.</p>
  
  <p>How can I find the optimal size? And does this have an impact on the DB side, does it chew up a lot of memory?</p>