Tommy, Thanks for the response!
I'll change the code to use the newer driver name. I started with a demo app that I wrote about six years ago. That is the reason for the older driver name. > 1) Fragmentation of your partition, especially the partition where the DB resides. I'll check into this, but I don't think it is a problem. > 2) Size of your database The Navision database is 2GB in size, of which 62% is used. But, I am only accessing a small part of it. Not much I can do about the size of this thing. The MySQL database is nearly empty, since this is the first project using it. > 3) Configuration of MySQL So far, I've just used the default installation configuration. Can you suggest any changes that you may have made? > 4) Query is optimized (?) My queries are simple: select x,y,z from table1 where q='foo' I'm not using any complicated joins. It is just not required. > 5) Sufficient hardware to handle the DB size (?) The production server (Win2003 server) is an IBM server with eight processors, and 4GB of memory. We have about 1.5TB of unused space on it. I would think that is sufficient? > 6) SAV configuration This may be key. Can you recommend any option changes based on your experience? One thing I was hoping for was to exclude certain directories/processes from being scanned by Symantec 11.0, but I can not find a way to do this. Does a way exist? Thanks again, Jon Oman > From: Tommy Pham <tommy...@yahoo.com> > To: Tomcat Users List <users@tomcat.apache.org> > Sent: Monday, March 30, 2009 12:23:54 PM > Subject: Re: Slow servlet response under WinXP Pro > > Hi Jon, > > > ----- Original Message ---- > > From: "jo...@catholic-doc.org" > > To: users@tomcat.apache.org > > Sent: Monday, March 30, 2009 11:45:37 AM > > Subject: Slow servlet response under WinXP Pro > > > > Hello! > > > > I am working on a servlet application. It is a data entry application > > that reads data from a Navision database, and writes data to MySQL. Here > > is the setup: > > > > WinXP Pro with Service Pack 3 (dev. box) / Windows 2003 Server (prod. box) > > Apache 2.2.11 > > Tomcat 6.0.18 > > MySQL 5.1.30 > > MySQL Connector 5.1.7 > > > > Driver for MySQL: org.gjt.mm.mysql.Driver > > Looking at the source for the connector, you might as well use the > com.mysql.jdbc.Driver > since the org.gjt.mm.mysql.Driver just extends the com.mysql.jdbc.Driver. I > remember > reading somewhere that org.gjt.mm.mysql.Driver is for backward compatibility for > older apps. > It will be phased out eventually. You're recommended to use > com.mysql.jdbc.Driver for > new application development. > > > Driver for Navision: sun.jdbc.odbc.JdbcOdbcDriver > > > > There is no native JDBC driver for Navision, so I have to use the ODBC > > version. > > > > I am having a problem with the time it takes to display a screen, when > > there is database activity going on. It can take anywhere from 30 seconds > > to 90 seconds for the screen to appear. This is not the time it takes > > Tomcat to start up for the first time, it is long after that point. > > > > I think I may have found the problem, but I do not know how to fix it. All > > of our systems (including the production server) have Symantec virus > > software running. When I turn the virus checking off, the application > > runs very well, when I turn the virus checking on, I experience the slow > > screen display. > > From what you describe, this problem doesn't seem to be Tomcat related > since I use Win03 w/ Symantec Anti-Virus along with 3rd party firewall software. > Also, the Win03 is configured as a Domain Controller. I don't have this slow > response you're reporting. Your performance issue may lie with: > > 1) Fragmentation of your partition, especially the partition where the DB > resides2) Size of your database > 3) Configuration of MySQL > 4) Query is optimized (?) > 5) Sufficient hardware to handle the DB size (?) forgot 1 more :) 6) SAV configuration > Regards, > Tommy > > > I googled for conflicts of Tomcat with virus scanning software, and only > > found reference to the fact that it can cause performance problems. But, > > I could not find a solution, other than turning off the virus scanning. > > Does anyone know of a solution to this problem? I have been told that > > turning off the virus scanning on the production box is not an option. I > > have also been told that Linux is not an option. > > > > I have gone through the Symantec software, and can not find a way to > > exclude Tomcat, etc. from its process. Where do I go from here? > > > > Thanks, > > > > Jon Oman
