File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes Perf Problems w/ SQL Server 7.0 Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Perf Problems w/ SQL Server 7.0" Watch "Perf Problems w/ SQL Server 7.0" New topic

Perf Problems w/ SQL Server 7.0

Tapan Parikh

Joined: Jun 28, 2001
Posts: 26
I am getting terrible performance using Jrun w/ SQL Server 7.0. Im using the standard Merant drivers supplied w/ Jrun. We thought that the problem could be with connection pooling, so weve tried many options of how to allocate connections but none seem to be too great. We have a lot of tables in the DB (>150).
Has anyone had similar problems? Does anyone have any ideas on how to troubleshoot this and get an idea of what is causing the slowdown?
Stanley Tan
Ranch Hand

Joined: May 17, 2001
Posts: 243
Most of the problems occur in the code itself. You must fully understand how the database implements lockings, transactions, concurrency control, etc. If you don't your code may seem correct when in fact it is causing a major problem.
subject: Perf Problems w/ SQL Server 7.0
jQuery in Action, 3rd edition