You don't say what DB it is, but I'd start by running a request profiler against it. See if the slowdown is on the DB side or the CF side. I'd also take a look at your logging. If the log files on production are filling up the disc, then additional logging to rows with text fields may be swapping a lot in and out of disc due to the larger amount of data being looked at. On a non-production box with adequate free disc space you wouldn't see that slow down.
The suddenness of the changes in server behavior with no code changes tells me that you should look at resource issues that change on their own, like free disc space. I recently had a db that was set up by someone else and they used the MSSQL defaults, which have no limit to log file growth. It was fine until it wasn't. Then it really sucked. Hope that helps, Judah On Fri, May 22, 2009 at 1:00 PM, Justin Scott <jscott-li...@gravityfree.com> wrote: > >> Exactly the same configuration? With the same settings >> for Unicode for query parameters and CLOB buffer? > > Yes, the data source configuration has all of the same settings. The really > strange part is that everything has been working fine for weeks since the > last code updates that we deployed, and this morning this one server just > started having issues. I'll be restarting the entire server later tonight > to see if that clears it up (you know, Windows...) or not. > > > -Justin > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322765 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
