aspose file tools*
The moose likes JDBC 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
Bookmark "Perf Problems w/ SQL Server 7.0" Watch "Perf Problems w/ SQL Server 7.0" New topic
Author

Perf Problems w/ SQL Server 7.0

Tapan Parikh
Greenhorn

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?
--Tap
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.
 
jQuery in Action, 2nd edition
 
subject: Perf Problems w/ SQL Server 7.0