RE: Tomcat scalability setting - need help please

2010-04-11 Thread Stephen Souness
> Thank you for your advice and sorry for my bad English. > > > -Original Message- > From: Leon Rosenberg [mailto:rosenberg.l...@googlemail.com] > Sent: Thursday, April 08, 2010 5:31 PM > To: Tomcat Users List > Subject: Re: Tomcat scalability setting - need help please

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 wrote: > -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, th

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 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 Date: Fri, 09 Apr 2010 13:43:42 To: Tomcat Users List Subject: Re: Tomcat scalability setting - need help please On 09/04/2010 13:08, cinl...@gmail.com

Re: Tomcat scalability setting - need help please

2010-04-09 Thread Pid
mcat Users List Subject: Re: Tomcat scalability setting - need help please On Fri, Apr 9, 2010 at 12:54 PM, 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.

Re: Tomcat scalability setting - need help please

2010-04-09 Thread cinlung
omcat scalability setting - need help please On Fri, Apr 9, 2010 at 12:54 PM, 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, wit

Re: Tomcat scalability setting - need help please

2010-04-09 Thread Leon Rosenberg
On Fri, Apr 9, 2010 at 12:54 PM, 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 and no one e

Re: Tomcat scalability setting - need help please

2010-04-09 Thread cinlung
o: Tomcat Users List 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 the first time it is reque

Re: Tomcat scalability setting - need help please

2010-04-09 Thread Xie Xiaodong
oftware.com] > Sent: Friday, April 09, 2010 12:50 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-struc

RE: Tomcat scalability setting - need help please

2010-04-09 Thread Cin Lung
r use 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 Clearl

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 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 query results

Re: Tomcat scalability setting - need help please

2010-04-08 Thread Leon Rosenberg
On Fri, Apr 9, 2010 at 2:28 AM, 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 time it will

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. The

Re: Tomcat scalability setting - need help please

2010-04-08 Thread cinlung
, but if two or more user doing the same huge process at the same time it will still consume the server. TIA Rendra GOD is GREAT! -Original Message- From: Christopher Schultz Date: Thu, 08 Apr 2010 18:12:16 To: Tomcat Users List Subject: Re: Tomcat scalability setting - need help please

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 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 lim

RE: Tomcat scalability setting - need help please

2010-04-08 Thread George Sexton
Rendra > > -Original Message- > From: George Sexton [mailto:geor...@mhsoftware.com] > Sent: Thursday, April 08, 2010 11:42 PM > To: 'Tomcat Users List' > Subject: RE: Tomcat scalability setting - need help please > > > > -----Original Message- &g

RE: Tomcat scalability setting - need help please

2010-04-08 Thread Cin Lung
calability 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

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. &g

Re: Tomcat scalability setting - need help please

2010-04-08 Thread Pid
e query in your application how are you 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 sca

RE: Tomcat scalability setting - need help please

2010-04-08 Thread Cin Lung
Sent: 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 bi

RE: Tomcat scalability setting - need help please

2010-04-08 Thread Cin Lung
010 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 wrote: > Dear All Dev > > Sorry if repost, I got an error from the mailing list server. > Can anyone help me with my pr

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 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 applicatio

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

Tomcat scalability setting - need help please

2010-04-08 Thread Cin Lung
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 accessing the server reach 100 users at