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
:33 AM Subject: RE: Tomcat Performance Concerns > 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. Acce

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

Tomcat Performance Concerns

2006-11-18 Thread Gaurav Kushwaha
I have a simple JSP-application that makes use of an ODBC database (access). When I run it using Tomcat on PC2 (XP) its performance is very good. However, running on PC1 (W2K Server) is orders of magnitudes slower! :-( I have already read most of the relevant manuals and tried various settings (s