> 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, but I would not use Oracle - too expensive. If you're moving up from Access, then MySQL would be a several orders of magnitude improvment, and it's free. If you're running a Windows Server environment, you may already have SQL Server available. However, the Microsoft JDBC drivers for that are not well regarded, and should be replaced by more robust open-source versions (Google or search the Tomcat archives for recommendations): http://marc.theaimsgroup.com/?l=tomcat-user&r=1&w=2 > I would look at breaking single-tier to three tier > architecture to decouple the application, business > and DB to differing structures Don't assume that a multi-tier implementation requires multiple boxes. It's perfectly fine to run multiple layers on a single system as long as you don't require the ultimate in performance and isolation (and few applications really do). - Chuck THIS COMMUNICATION MAY CONTAIN CONFIDENTIAL AND/OR OTHERWISE PROPRIETARY MATERIAL and is thus for use only by the intended recipient. If you received this in error, please contact the sender and delete the e-mail and its attachments from all computers. --------------------------------------------------------------------- To start a new topic, e-mail: users@tomcat.apache.org To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]