> Locks and blocks can occur and have no overall impact on general DB > server > performance - but still bring down your site because they prevent other > queries from completing. I'd bet my left eye that's what's happening. > Here's > what I would do....
<snip> On this server, I've done all what you've suggested many, many times, I'm going blind looking at SQL profiler these days! LOL The sites already make extensive use of NOLOCK hints especially around the job search functions. The link below shows a typical example of what I see from the profiler, occasionally one of the queries may whip by with a duration of 16ms instead of 0ms as you can see also, as everything is using prepared statements, it makes life difficult in actually determining anything useful from the profiler. http://www.newmediadevelopment.net/user/temp/Trace-screen.gif Pretty much every query that goes through looks like that and is equally as quick. I just don't see the DB slow down. Pretty much every query that goes through is from the view job page. Most of the queries listed have a CF cache time of 5 minutes but there are so many job views of so many jobs that they still dominate the profiler... Paul ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:355927 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
