Re: Tomcat Performance Concerns

2006-11-21 Thread David Rees
On 11/21/06, Andre Prasetya <[EMAIL PROTECTED]> wrote: On 11/21/06, Harry <[EMAIL PROTECTED]> wrote: > PostgreSQL is excellent, IMHO - fast, and easy to administrate. Yupe agreed, but for database that is used with frequent insert and delete statement, I have to vacuum them frequently. Which is a

Re: Tomcat Performance Concerns

2006-11-21 Thread Andre Prasetya
Yupe agreed, but for database that is used with frequent insert and delete statement, I have to vacuum them frequently. Which is a boring task to do. I created an agent that will vacuum the database every friday. Then I move it to MySql because I think its more suited to my needs. -Andre- On 11/

Re: Tomcat Performance Concerns

2006-11-18 Thread Tomi NA
2006/11/19, Gaurav Kushwaha <[EMAIL PROTECTED]>: Thanks Martin and Everyone else for the suggestions. Martin, Oracle I dont want to go with since its expensive. I will infact try out MySQL and will let you guys know. I would argue that you chose one of the inferior database management systems,

Re: Tomcat Performance Concerns

2006-11-18 Thread Gaurav Kushwaha
Thanks Martin and Everyone else for the suggestions. Martin, Oracle I dont want to go with since its expensive. I will infact try out MySQL and will let you guys know. Regards, Gaurav. On 11/18/06, Martin Gainty <[EMAIL PROTECTED]> wrote: Good Morning Gaurav- It is truly Amazing how many manag

Re: Tomcat Performance Concerns

2006-11-18 Thread Martin Gainty
, 2006 12:09 PM Subject: RE: Tomcat Performance Concerns > From: Martin Gainty [mailto:[EMAIL PROTECTED] > Subject: Re: Tomcat Performance Concerns > > I would recommend a migration to true multi-threaded > environment with a DB which has full Transaction support > such as Oracle Fo

Re: Tomcat Performance Concerns

2006-11-18 Thread Len Popp
Can you determine which part of the system is running slowly? One thing to try would be a simplified version of your application that doesn't access the database - if it is still slow then you know it's not related to the DB. You could also add logging messages at various points to measure how lon

RE: Tomcat Performance Concerns

2006-11-18 Thread Caldarale, Charles R
> From: Martin Gainty [mailto:[EMAIL PROTECTED] > Subject: Re: Tomcat Performance Concerns > > I would recommend a migration to true multi-threaded > environment with a DB which has full Transaction support > such as Oracle For once, I at least partially agree with Martin, b

Re: Tomcat Performance Concerns

2006-11-18 Thread Martin Gainty
received this communication in error and that any review, disclosure, dissemination, distribution or copying of it or its contents - Original Message - From: "Caldarale, Charles R" <[EMAIL PROTECTED]> To: "Tomcat Users List" Sent: Saturday, November 18, 2006 11

RE: Tomcat Performance Concerns

2006-11-18 Thread Caldarale, Charles R
> From: Gaurav Kushwaha [mailto:[EMAIL PROTECTED] > Subject: Tomcat Performance Concerns > > I have a simple JSP-application that makes use of an ODBC database > (access). Try using a real database with JDBC drivers. Access and ODBC are pretty much just toys and inappropriate for any kind of pr