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?