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
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.