1. What does Statement.setFetchSize(nSize) method really do? stackoverflow.comi have this really big table with some millions of records every day and in the end of every day i am extracting all the records of the previous day. i ... |
2. what is the use of setFetchSize and setMaxRows methods in Statement. coderanch.comHi, Let us take this example. i have 10 Laksh row in a student table. 1. i am using the query "select * from student". By default how many row will be selected by statement obj? 2. Assume that the default value is 50,000. how can i get the remaining rows of the table. 3.what is the difference between fetchSize and ... |
3. Using of Statement.setFetchSize coderanch.comThe setFetchSize() is just less or more a performance setting. It determines how many rows to put in memory at once. It doesn't limit the total amount of rows to be returned. There you use the SQL LIMIT and/or OFFSET clauses for, depending on the DB used. Consult its SQL documentation for details. |
4. Statement.setfetchSize() Doubt coderanch.comHi all, I am not fully fluent with the JDBC methods, so please guide me. While using the methods Statement.setFetchSize(int i) or Resultset.setFetchSize(int i) we can set the no of rows fetched at a time for all result sets of this statement. This helps in decreasing the load on the db server. but if one has to fetch 100 rows and ... |