1. How can I retrieve a JDBC ResultSet as an ArrayList? stackoverflow.comI'm doing a query to retrieve a large amount of IDs (integers). Instead of iterating millions of times through the ResultSet and copying everything one-by-one to an ArrayList, is there some ... |
2. What are likely causes of StringBuilder and ResultSet performance issues stackoverflow.comI'm looping through a ResultSet in Java; which for testing purposes is returning about 30 rows with 17 Columns (all String data) per row. I'm manually building an XML String out ... |
3. JDBC resultset close stackoverflow.comI am doing profiling of my Java application and found some interesting statistics for a jdbc PreparedStatement call: Given below is the environment details: Database: Sybase SQL Anywhere 10.0.1 Driver: com.sybase.jdbc3.jdbc.SybDriver connection pool: c3p0 JRE: 1.6.0_05 The ... |
4. JDBC ResultSet.absolute() vs. Limit stackoverflow.comWhat's the preferred method to fetch a subset of records from the database? Use rs.absolute() or Limit? |
5. Is there any difference in performance of resultset and Scrollable ResultSet? stackoverflow.comIn my application I have to fetch records and need to put them in to 2D array. I have to fire two queries first to find out the count so that ... |
6. Exhausted resultset exception after a period, when application has started stackoverflow.comWe have a java application running on JBOSS with Oracle. We are also using the frameworks seam and hibernate. When our application is up and running for production, after few hours ... |
7. Performance issue with resultset stackoverflow.comPossible Duplicate:i have a query which builds a resultset,which is has some three lakh (300k) records.And the resultset is placed in the ... |
8. Performance when mutiple resultsets are returned from a stored procedure ? coderanch.comHi, I have got a stored procedure where I want to put a number of SELECT queries. And each SELECT query must return one Resultset. Hence, finally, the stored procedure will have to return multiple resultsets. My database is SQL Server 7.0. I want to know if this can de done using JDBC. If so, can anyone tell me the performance ... |
9. Performance Issue - Constant Delay in ResultSet.next() coderanch.comHi, |
10. Resultset to Json Performance java-forums.orgWhich is faster? or How do I perform the pulling of data out of my resultset for the best performance. I have about 100 columns in my resultset, If resultset is over 500 rows, than my result set fails. (Meaning my browser times out) String LVL_SUM_ORDERED_QTY = rs.getDouble(1); String LVL_SUM_ORDERED_QTY = rs.getDouble("LVL_SUM_ORDERED_QTY"); |