1)Put indexes on predicates where q= make sure column q has a unique index created to reference that column
2)I would'nt disable virus-scans..yes they slow down access but you want the peace of mind that comes with your system being 'virus-free' Back to you.. Martin ______________________________________________ Verzicht und Vertraulichkeitanmerkung / Disclaimer and confidentiality note Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger sein, so bitten wir hoeflich um eine Mitteilung. Jede unbefugte Weiterleitung oder Fertigung einer Kopie ist unzulaessig. Diese Nachricht dient lediglich dem Austausch von Informationen und entfaltet keine rechtliche Bindungswirkung. Aufgrund der leichten Manipulierbarkeit von E-Mails koennen wir keine Haftung fuer den Inhalt uebernehmen. This message is confidential and may be privileged. If you are not the intended recipient, we kindly ask you to please inform the sender. Any unauthorised dissemination or copying hereof is prohibited. This message serves for information purposes only and shall not have any legally binding effect. Given that e-mails can easily be subject to manipulation, we can not accept any liability for the content provided. > To: users@tomcat.apache.org > Subject: Re: Slow servlet response under WinXP Pro > From: jo...@catholic-doc.org > Date: Tue, 31 Mar 2009 12:31:26 -0500 > > 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 > _________________________________________________________________ Quick access to Windows Live and your favorite MSN content with Internet Explorer 8. http://ie8.msn.com/microsoft/internet-explorer-8/en-us/ie8.aspx?ocid=B037MSN55C0701A
