This week's book giveaway is in the OO, Patterns, UML and Refactoring forum. We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line! See this thread for details.
Hi, I have this scenario,I have a bunch of methods to get data for different columns of a JSP. What I do is I run these methods and make one ArrayLists for each column of JSP and populate the data in the JSP by iterating over the ArrayLists. Now these methods take a while to load data for the JSP. To fasten the process we are planning to load data from the ArrayLists to a d/b table and retrieve the data from that table for the JSP.
My question what is the most effecient way to load data from arraylist to a table? Would it be multiple INSERT queies kind of thing?