Has anyone benchmarked the Collection classes sort? On small datasets, is
the performance really that bad? If this is being transmitted over the web,
will network latency swamp any delay due to sorting? How much volume
(hits/hour) would you need to get before it began to affect server
performance?
----- Original Message -----
From: Parvez <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, December 21, 2000 2:44 AM
Subject: Re: (Very very urgent)Sorting a resultset after cl osing the
connection
> yes but won't the java collection framework make it exceedingly slow ?
> can't we do it faster than that ?
>
> parvez
>
>
> And Then Russell Politzky wrote .............
>
> > At 02:16 PM 2000/12/19 -0500, you wrote:
> > >A simple solution would be to ditch the resultset and convert it to
XML.
> > >Then you can use XML/XSL and DOM to sort it easy with an "order-by".
This
> > >is a effective solution if you are already using XML and loading stuff
into
> > >the parser DOM.
> > >
> > >-Michael
> > >
> > >-----Original Message-----
> > >From: Jyoti Bongarala [mailto:[EMAIL PROTECTED]]
> > >Sent: Tuesday, December 19, 2000 9:16 AM
> > >To: [EMAIL PROTECTED]
> > >Subject: [JSP-INTEREST] (Very very urgent)Sorting a resultset after
> > >closing the connection
> > >
> > >
> > >HI all,
> > >
> > >My problem is I am looking for an algorithm or a
> > >program that would do the following :
> > >
> > >1. Once I retrieve a resultset from the database, I
> > >store it in a CachedRowSet. And when I display it ,
> > >the user should be able to sort the data by any column
> > >(total columns retrieved are 13) and this sorting has
> > >to be done (outside the database)
> > >
> > >Please somebody help me with this or give me a
> > >lead....
> > >
> > >thanks,
> > >Jyoti
> >
> > The Java Collections Framework has what you need. Read the ResultSet
out
> > into a data structure and make comparators for each column so that the
> > collections framework can sort your data on each column, as required.
When
> > you receive a request for sorting on a given column, simply use the
> > relevant comparator for sorting. The collections framework will also
sort
> > in reverse order, no database interaction required.
> >
> >
===========================================================================
> > 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://java.sun.com/products/jsp/faq.html
> > http://www.esperanto.org.nz/jsp/jspfaq.html
> > http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
> > http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
>
>
===========================================================================
> 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://java.sun.com/products/jsp/faq.html
> http://www.esperanto.org.nz/jsp/jspfaq.html
> http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
> http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
>
===========================================================================
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://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
