I second the DB issue theory. I also run several job boards, and have found that most of my performance issues relate to the database. Sometime I can optimize the DB with the help of the profiler, other times I have simply reworked the code for better efficient. Use of nolock, small simple queries, and stored procedures make a huge difference. I am lucky in the I have Fusion Reactor and Idera's SQL monitoring services both installed. Makes finding bottle necks and doing optimization much easier.
BTW, does your site support keyword searches using a full-text index. I know a cool little trick that improved keyword search performance about 5-10 fold on my sites. Brian Cain Sent from my iPhone On Jun 13, 2013, at 4:32 PM, "Paul Vernon" <[email protected]> wrote: > >> Yeah... again I would say you are getting all you can out of this >> setup. I'm not finding a lot to criticize :) >> >> -Mark > > Thanks. It just crashed again. Albeit the reliability is much improved over > what it was by reducing the time for cleaning up connections and switching > the memory allocations around as I've noted previously. > > This time though, the profiler was running through the crash. I've now got > 20 million trace rows to trawl through to see if it really is a DB issue or > not... > > 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:355934 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
