• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

setFetchSize on preparestatement vs setFetchSize on resultset

 
avihai marchiano
Ranch Hand
Posts: 342
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
setFetchSize on preparestatement vs setFetchSize on resultset what is the different?
how to know the optimal value?

Thank you
 
Leonardo Carreira
Ranch Hand
Posts: 494
Eclipse IDE Java Postgres Database
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Sir..

What is your purpose in using setFetchSize?..

what do i can to make similar it with limit function in query?

Thanks in advance..
 
avihai marchiano
Ranch Hand
Posts: 342
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
limit is not standard.
 
Leonardo Carreira
Ranch Hand
Posts: 494
Eclipse IDE Java Postgres Database
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
avihai marchiano wrote:limit is not standard.


upset..

usually i uses Limit in my query...
if i use JDBC, do i have to use setFetchSize/setMaxRows on my preparedStatement?

Thanks sir..
 
avihai marchiano
Ranch Hand
Posts: 342
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
no no no , no upset at all.

As far as i know limit Standard, so when you want to set the bulk size you need to set it on the max rows.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic