Re: Help with java Lists - followup

2007-12-20 Thread David kerber
Thanks for all the suggestions! Thanks to you guys and gals, a report that had been taking 4 to 5 minutes to process is now taking less than 10 seconds to generate! D David kerber wrote: I'm running this app in a tomcat 5.5.x container,I am trying to figure out which form of a list is the

Re: Help with java Lists - followup

2007-12-20 Thread Steve Ochani
On 20 Dec 2007 at 13:01, David kerber wrote: Thanks for all the suggestions! Thanks to you guys and gals, a report that had been taking 4 to 5 minutes to process is now taking less than 10 seconds to generate! Hi, What was the basic overall solution you ended up with? -Steve O.

Re: Help with java Lists - followup

2007-12-20 Thread David kerber
Steve Ochani wrote: On 20 Dec 2007 at 13:01, David kerber wrote: Thanks for all the suggestions! Thanks to you guys and gals, a report that had been taking 4 to 5 minutes to process is now taking less than 10 seconds to generate! Hi, What was the basic overall solution you

Re: Help with java Lists

2007-12-13 Thread Steve Ochani
Date sent: Tue, 11 Dec 2007 18:16:12 -0500 From: Christopher Schultz [EMAIL PROTECTED] Subject:Re: Help with java Lists To: Tomcat Users List users@tomcat.apache.org Send reply to: Tomcat Users List users@tomcat.apache.org

Re: [OT] Help with java Lists

2007-12-13 Thread David Kerber
Christopher Schultz wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 David, David kerber wrote: My primary job is database design and management; the java side is where I'm weak, and I've spent a LOT of time on these queries, including pushing through some design changes that have

Re: [OT] Help with java Lists

2007-12-12 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 David, I'm already on my 3rd attempt at optimization for this section. The first round was having the db do _all_ the work, submitting a complex query (a view, actually) and returning a resultset with all the data I need. The query took

Re: [OT] Help with java Lists

2007-12-12 Thread David kerber
Christopher Schultz wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 David, I'm already on my 3rd attempt at optimization for this section. The first round was having the db do _all_ the work, submitting a complex query (a view, actually) and returning a resultset with all the data I

Re: [OT] Help with java Lists

2007-12-12 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 David, David kerber wrote: My primary job is database design and management; the java side is where I'm weak, and I've spent a LOT of time on these queries, including pushing through some design changes that have helped a lot, but not enough.

Re: [OT] Help with java Lists

2007-12-11 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 David, You need a collection that is: David kerber wrote: I need to have some kind of list or collection that I can search quickly for a specific entry Hashed and then start stepping through the list item by item from that point. Linked The

Re: Help with java Lists

2007-12-11 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Steve, Steve Ochani wrote: Keeping less data in each node should make searching the list fast. Huh? I'm pretty sure that pointer dereferencing performance does not depend on memory size (ignoring memory paging, of course). - -chris -BEGIN PGP

Re: [OT] Help with java Lists

2007-12-11 Thread David Kerber
Christopher Schultz wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 David, You need a collection that is: David kerber wrote: I need to have some kind of list or collection that I can search quickly for a specific entry Hashed and then start stepping through the list item

Help with java Lists

2007-12-10 Thread David kerber
I'm running this app in a tomcat 5.5.x container,I am trying to figure out which form of a list is the best for what I need to do here: I need to have some kind of list or collection that I can search quickly for a specific entry, and then start stepping through the list item by item from

Re: Help with java Lists

2007-12-10 Thread Mark Thomas
David kerber wrote: Any suggestions are welcome, including suggestions for reworking the basic design... Generally for reporting, I'd try and push as much as possible to the database, run a query there that returns exactly what I want and then optimise that query on the database. Mark

Re: Help with java Lists

2007-12-10 Thread Steve Ochani
On 10 Dec 2007 at 16:02, David kerber wrote: I'm running this app in a tomcat 5.5.x container,I am trying to figure out which form of a list is the best for what I need to do here: I need to have some kind of list or collection that I can search quickly for a specific entry, and then

RE: Help with java Lists

2007-12-10 Thread Caldarale, Charles R
From: David kerber [mailto:[EMAIL PROTECTED] Subject: Help with java Lists I need to have some kind of list or collection that I can search quickly for a specific entry, and then start stepping through the list item by item from that point. Try java.util.TreeMap; the subMap() and tailMap

Re: Help with java Lists

2007-12-10 Thread David kerber
Mark Thomas wrote: David kerber wrote: Any suggestions are welcome, including suggestions for reworking the basic design... Generally for reporting, I'd try and push as much as possible to the database, run a query there that returns exactly what I want and then optimise that query on

Re: Help with java Lists

2007-12-10 Thread David kerber
Caldarale, Charles R wrote: From: David kerber [mailto:[EMAIL PROTECTED] Subject: Help with java Lists I need to have some kind of list or collection that I can search quickly for a specific entry, and then start stepping through the list item by item from that point. Try

Re: Help with java Lists

2007-12-10 Thread David kerber
Steve Ochani wrote: On 10 Dec 2007 at 16:02, David kerber wrote: I'm running this app in a tomcat 5.5.x container,I am trying to figure out which form of a list is the best for what I need to do here: I need to have some kind of list or collection that I can search quickly for a