tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "David Boyer" <da...@bvu.edu>
Subject RE: Speed issues with SQL Server 2000 and JTDS
Date Tue, 04 Jan 2005 16:51:29 GMT
A couple of things to try to narrow things down. 
 
1. creating an ODBC connection using asp or vbscript. Plenty of examples
on the web. 
 
2. Load the driver in a static block or somewhere else independent of
where the connection is created. Drivers only need to be loaded once, so
see if the performance improves if you don't repeatedly load it. 
 
3. Try connection pooling. 

>>>charlesk@netgaintechnology.com 01/04 10:23 am >>>
Could this speed issue be caused by a poor setup?  When I remove the
database connection from my code, the pages run fast.  Though I
obviously need the database portion of the code in there. 

Thanks
Charles


-----Original Message-----
From: David Boyer [mailto:david@bvu.edu]
Sent: Monday, January 03, 2005 9:05 AM
To: tomcat-user@jakarta.apache.org; Charles P. Killmer
Subject: RE: Speed issues with SQL Server 2000 and JTDS

You could try using something like jProfiler to see where the bottleneck
is.

I don't see anything unusual in your code example, although it looks
like the only thing it does is create the connection. I use jTDS and it
works fine without doing anything exceptional.



>>>charlesk@netgaintechnology.com 01/03 8:55 am >>>

This is some representative code that is being very slow. 


import java.sql.*;


public class SomeClass {

  public Connection conn;

public int ID;

public String Name;

public String Address;

public String City;

public String OtherStuff;


  public SomeClass() throws Exception {

      try {

          Class.forName(net.sourceforge.jtds.jdbc.Driver);

      } catch (ClassNotFoundException ex) {

      }

      try {

   

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message