• 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.
 
my overalls have superpowers - they repel people who think fashion is important. Tiny ad:
the new thread boost feature brings a LOT of attention to your favorite threads
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!