Reply to thread

Message: [QUOTE="JScoobyCed, post: 613474"] Hi, I am working on a multi-user web-application (about 100 concurrent users). We use Tomcat 4.1.30, J2SE 1.4.2, MS SQL 2000 (JNDI pooled connection). We are meeting some performances problem when a lot of users are connected. We have profiled and "jmetered" our application, and one of the result show we have some slow access to DB, even with JNDI and connection pool. I have been suggested to try JTDS JDBC driver instead of MS SQL drivers. Our QA dept. has tested and we don't find much differences in the result. Is there any specific optimization we could do (in term of the way we build query, batch, settings, ... anything) to make full benefit of this driver. Anybody has experience in this driver to replace MS driver? Thank you, [/QUOTE]