title: Datastax driver limit option
body: <p>I construct a select query using datastax java driver. I set the limit using limit option. But i see another property that can be set too</p>
  
  <p><strong>setFetchSize(int size)</strong></p>
  
  <p><strong>DEFAULT_FETCH_SIZE- 5000 according to the docs.</strong></p>
  
  <p><a href="http://www.datastax.com/drivers/java/2.0/com/datastax/driver/core/QueryOptions.html#DEFAULT_FETCH_SIZE" rel="nofollow">http://www.datastax.com/drivers/java/2.0/com/datastax/driver/core/QueryOptions.html#DEFAULT_FETCH_SIZE</a></p>
  
  <p>Does this mean that if i have around 10000 columns in a row,if i have a query run with a limit of 3, it will always fetch the default value specified- 5000 rows and then limit the last 3 rows from that? </p>
  
  <p>I thought the limit query fetches the last 3 values alone by default when used like this. Can someone clarify on this?</p>