Since a Vector is synchronized, it does have a lot of overhead. If you need to use a synchronized object to hold data, a vector is a good one. I prefer to use the non-synchronized objects in Java, and add in my own synchronization if necessary. I prefer using either a HashSet or an ArrayList, depending on how much data I need to hold in memory, and how fast I need to "find" a particular record.
Celeste -----Original Message----- From: Ketharinath Kamalanathan [mailto:[EMAIL PROTECTED]] Sent: Monday, December 10, 2001 10:54 AM To: [EMAIL PROTECTED] Subject: Re: A JSP doubt I generally use Vector. I see Storage optimization here. Some useful code for you. Vector dbcvec = new Vector(); try { ResultSetMetaData rsmd = rs.getMetaData(); int numofcols = rsmd.getColumnCount(); int colcount = 0; Integer numcols = new Integer(numofcols); String[] colnames = new String[numofcols]; String[] coltype = new String[numofcols]; dbcvec.add(numcols); while(colcount<=(numofcols-1)) { colnames[colcount] = rsmd.getColumnName(colcount+1); dbcvec.add(rsmd.getColumnName(colcount+1)); coltype[colcount] = rsmd.getColumnTypeName(colcount+1); dbcvec.add(rsmd.getColumnTypeName(colcount+1)); colcount++; } dbcvec.add("DATA"); colcount = 0; while(rs.next()){ while(colcount<=(numofcols-1)) { // System.out.println(colnames[colcount]); dbcvec.add(rs.getObject(colnames[colcount])); colcount++; } colcount=0; } dbcvec.add("EOF"); /Ketharinath Kamalanathan ----- Original Message ----- From: "Praveen Potineni" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, December 10, 2001 10:45 AM Subject: Re: A JSP doubt > Hi Ketharinath, > I was also doing something similar. Can you suggest which collection objects > we can use to store values coming out of database and then send it to the > JSP. Can you elaboreate. Can you provide code snippets if you could. > Thanks > Praveen > > ----- Original Message ----- > From: "Ketharinath Kamalanathan" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Monday, December 10, 2001 11:35 AM > Subject: Re: A JSP doubt > > > > Hello Joshy: > > > > The ResultSet object needs a database connection to be maintained. You > > cannot access the ResultSet object without persistent Connection. So, when > > you have the ResultSet in the JSP you are trying to have the connection to > > the database. By this you are hogging the bandwidth and also suing more of > > your database resources. > > > > Its a fairly good idea to do the iteration in the Java Class then have > some > > collection object passed to the JSP. This eliminates the problems that I > > have mentioned about previously. > > > > Hope this helps. > > > > /Ketharinath Kamalanathan > > ----- Original Message ----- > > From: "JOSHY MON M C" <[EMAIL PROTECTED]> > > To: <[EMAIL PROTECTED]> > > Sent: Monday, December 10, 2001 2:34 AM > > Subject: A JSP doubt > > > > > > > Hi folks, > > > > > > Please answer my following questions > > > 1 .Is it a good practice to use the Resultset object directly on a JSP > > page > > > ? ( eg: for iterating employee recordet and displaying employee list ) > > > > > > 2. Instead, if I iterate the same recordset in a Jave class and make a > > List > > > of Employee object and return back to the page. Will it be a good > design. > > > How is it going to affect the performance. > > > > > > Please reply soon. > > > > > > Regards > > > Joshy > > > > > > > > > =========================================================================== > > > To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff > > JSP-INTEREST". > > > For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST > > DIGEST". > > > Some relevant FAQs on JSP/Servlets can be found at: > > > > > > http://archives.java.sun.com/jsp-interest.html > > > http://java.sun.com/products/jsp/faq.html > > > http://www.esperanto.org.nz/jsp/jspfaq.jsp > > > http://www.jguru.com/faq/index.jsp > > > http://www.jspinsider.com > > > > > > > > =========================================================================== > > To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff > JSP-INTEREST". > > For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST > DIGEST". > > Some relevant FAQs on JSP/Servlets can be found at: > > > > http://archives.java.sun.com/jsp-interest.html > > http://java.sun.com/products/jsp/faq.html > > http://www.esperanto.org.nz/jsp/jspfaq.jsp > > http://www.jguru.com/faq/index.jsp > > http://www.jspinsider.com > > > > =========================================================================== > To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST". > For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST". > Some relevant FAQs on JSP/Servlets can be found at: > > http://archives.java.sun.com/jsp-interest.html > http://java.sun.com/products/jsp/faq.html > http://www.esperanto.org.nz/jsp/jspfaq.jsp > http://www.jguru.com/faq/index.jsp > http://www.jspinsider.com > =========================================================================== To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST". For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST". Some relevant FAQs on JSP/Servlets can be found at: http://archives.java.sun.com/jsp-interest.html http://java.sun.com/products/jsp/faq.html http://www.esperanto.org.nz/jsp/jspfaq.jsp http://www.jguru.com/faq/index.jsp http://www.jspinsider.com =========================================================================== To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST". For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST". Some relevant FAQs on JSP/Servlets can be found at: http://archives.java.sun.com/jsp-interest.html http://java.sun.com/products/jsp/faq.html http://www.esperanto.org.nz/jsp/jspfaq.jsp http://www.jguru.com/faq/index.jsp http://www.jspinsider.com
