RE: Tomcat scalability setting - need help please

2010-04-11 Thread Stephen Souness
: Thursday, April 08, 2010 5:31 PM To: Tomcat Users List Subject: Re: Tomcat scalability setting - need help please Hello Rendra, comments inline. On Thu, Apr 8, 2010 at 11:00 AM, Cin Lung cinl...@gmail.com wrote: Dear All Dev Sorry if repost, I got an error from the mailing list server

Re: Tomcat scalability setting - need help please

2010-04-09 Thread Leon Rosenberg
On Fri, Apr 9, 2010 at 2:28 AM, cinl...@gmail.com wrote: As what I meant by exhaustive, I went to the extent of building my own cache scheme and it worked, the process still long, but at least it does not kill the other user, but if two or more user doing the same huge process at the same

Re: Tomcat scalability setting - need help please

2010-04-09 Thread Bob Hall
Rendra, --- On Thu, 4/8/10 at 5:28 PM, cinl...@gmail.com cinl...@gmail.com wrote: Do you have better way as how to transport this result to jsp? Please enlighten me. If you *really* need to serve _millions_ of rows of data to a user you will need to implement some form of paging - the

RE: Tomcat scalability setting - need help please

2010-04-09 Thread Cin Lung
ehcache. The companies where I cater is data hungry company. Thanks Rendra -Original Message- From: George Sexton [mailto:geor...@mhsoftware.com] Sent: Friday, April 09, 2010 12:50 AM To: 'Tomcat Users List' Subject: RE: Tomcat scalability setting - need help please Clearly instantiating

Re: Tomcat scalability setting - need help please

2010-04-09 Thread Xie Xiaodong
AM To: 'Tomcat Users List' Subject: RE: Tomcat scalability setting - need help please Clearly instantiating millions of objects is not a strategy for scalability. You're going to have to re-structure your code to reduce the memory footprint of each session. Why is your result set returning

Re: Tomcat scalability setting - need help please

2010-04-09 Thread cinlung
To: Tomcat Users Listusers@tomcat.apache.org Subject: Re: Tomcat scalability setting - need help please Hello, Maybe you could just export those data into Excel files (any other format will do), and provide a download link to those file. Those files could be generated lazily, means generate

Re: Tomcat scalability setting - need help please

2010-04-09 Thread Leon Rosenberg
On Fri, Apr 9, 2010 at 12:54 PM, cinl...@gmail.com wrote: And yes I used excel as the result. It is faster, but still can do better. I wonder if I can increase the process time to less than 30 min to produce results with millions of data. Currently, with only one person doing the analysis

Re: Tomcat scalability setting - need help please

2010-04-09 Thread cinlung
Listusers@tomcat.apache.org Subject: Re: Tomcat scalability setting - need help please On Fri, Apr 9, 2010 at 12:54 PM, cinl...@gmail.com wrote: And yes I used excel as the result. It is faster, but still can do better. I wonder if I can increase the process time to less than 30 min to produce

Re: Tomcat scalability setting - need help please

2010-04-09 Thread Pid
:39 To: Tomcat Users Listusers@tomcat.apache.org Subject: Re: Tomcat scalability setting - need help please On Fri, Apr 9, 2010 at 12:54 PM,cinl...@gmail.com wrote: And yes I used excel as the result. It is faster, but still can do better. I wonder if I can increase the process time to less than

Re: Tomcat scalability setting - need help please

2010-04-09 Thread cinlung
Hei! That is a great idea. All I need now is to socialize the idea. Thanks so much Rendra GOD is GREAT! -Original Message- From: Pid p...@pidster.com Date: Fri, 09 Apr 2010 13:43:42 To: Tomcat Users Listusers@tomcat.apache.org Subject: Re: Tomcat scalability setting - need help please

Re: Tomcat scalability setting - need help please

2010-04-09 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Rendra, On 4/9/2010 6:54 AM, cinl...@gmail.com wrote: Yes they use their eyes, but before that, they print it into one rim of papers first. But customer is the king. And there are some conditions where they really need to print 6 months or more

Re: Tomcat scalability setting - need help please

2010-04-09 Thread Pid *
I'm getting the impression that the output is actually a CSV or something similar. p On 9 April 2010 16:04, Christopher Schultz ch...@christopherschultz.netwrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Rendra, On 4/9/2010 6:54 AM, cinl...@gmail.com wrote: Yes they use their

Re: Tomcat scalability setting - need help please

2010-04-08 Thread Pid
On 08/04/2010 10:00, Cin Lung wrote: Dear All Dev Sorry if repost, I got an error from the mailing list server. Can anyone help me with my problem? I have two biggest problems as follow: 1. Multi Connection Problem: I have a web application that service to multiple users. Everytime the users

Re: Tomcat scalability setting - need help please

2010-04-08 Thread Leon Rosenberg
Hello Rendra, comments inline. On Thu, Apr 8, 2010 at 11:00 AM, Cin Lung cinl...@gmail.com wrote: Dear All Dev Sorry if repost, I got an error from the mailing list server. Can anyone help me with my problem? I have two biggest problems as follow: 1. Multi Connection Problem: I have a web

RE: Tomcat scalability setting - need help please

2010-04-08 Thread Cin Lung
:31 PM To: Tomcat Users List Subject: Re: Tomcat scalability setting - need help please Hello Rendra, comments inline. On Thu, Apr 8, 2010 at 11:00 AM, Cin Lung cinl...@gmail.com wrote: Dear All Dev Sorry if repost, I got an error from the mailing list server. Can anyone help me with my problem

RE: Tomcat scalability setting - need help please

2010-04-08 Thread Cin Lung
: Thursday, April 08, 2010 4:56 PM To: Tomcat Users List Subject: Re: Tomcat scalability setting - need help please On 08/04/2010 10:00, Cin Lung wrote: Dear All Dev Sorry if repost, I got an error from the mailing list server. Can anyone help me with my problem? I have two biggest problems

Re: Tomcat scalability setting - need help please

2010-04-08 Thread Pid
doing it, e.g. by calling a stored procedure, or by executing exactly the same SQL statement? Thanks Rendra -Original Message- From: Pid [mailto:p...@pidster.com] Sent: Thursday, April 08, 2010 4:56 PM To: Tomcat Users List Subject: Re: Tomcat scalability setting - need help please

RE: Tomcat scalability setting - need help please

2010-04-08 Thread George Sexton
-Original Message- From: Pid [mailto:p...@pidster.com] Sent: Thursday, April 08, 2010 8:49 AM To: Tomcat Users List Subject: Re: Tomcat scalability setting - need help please When you run the query in your application how are you doing it, e.g. by calling a stored procedure

RE: Tomcat scalability setting - need help please

2010-04-08 Thread Cin Lung
setting - need help please -Original Message- From: Pid [mailto:p...@pidster.com] Sent: Thursday, April 08, 2010 8:49 AM To: Tomcat Users List Subject: Re: Tomcat scalability setting - need help please When you run the query in your application how are you doing it, e.g

RE: Tomcat scalability setting - need help please

2010-04-08 Thread George Sexton
To: 'Tomcat Users List' Subject: RE: Tomcat scalability setting - need help please -Original Message- From: Pid [mailto:p...@pidster.com] Sent: Thursday, April 08, 2010 8:49 AM To: Tomcat Users List Subject: Re: Tomcat scalability setting - need help please When you run the query

Re: Tomcat scalability setting - need help please

2010-04-08 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Rendra, At the risk of getting sucked into the insanity... On 4/8/2010 7:19 AM, Cin Lung wrote: It's running 32 Bit windows 2003 only With 8GB Ram. 32-bit Microsoft Windows can access 8GiB of RAM (much more, in fact), but each process is still

Re: Tomcat scalability setting - need help please

2010-04-08 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Rendra, On 4/8/2010 12:53 PM, Cin Lung wrote: Your remark is almost correct. What I did is that I store the result of the resultset (which can go up to million lines of rows) in a batch of Java beans. Then I set the beans to the HTTP Request and

Re: Tomcat scalability setting - need help please

2010-04-08 Thread cinlung
: Re: Tomcat scalability setting - need help please -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Rendra, On 4/8/2010 12:53 PM, Cin Lung wrote: Your remark is almost correct. What I did is that I store the result of the resultset (which can go up to million lines of rows) in a batch of Java

Re: Tomcat scalability setting - need help please

2010-04-08 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Rendra, On 4/8/2010 8:28 PM, cinl...@gmail.com wrote: I stored the result bean in the http request object, NOT IN THE SESSION OBJECT, hoping that once the result is delivered, the beans will die with the request object since request object. They