We are running a very large app here with CF5.0 and DB2 with no issues at all re performance. The Shared Variables issue is huge if not done properly, here are some cost-effective ideas, if I am repeating ones suggested I apologize.
Go into CF Admin and turn on all debugging options if possible enter specific IP's so only these few the exploded benchmarking debug output. Check and re check for which files are slowing things down and look closely at the slow running pages, check for any Application, Server or Session scoped variable reads and writes. Look at your ColdFusion logs, particularly Application and Server, if they are huge don't despair. Look for any messages with "thread", "threading" and/or "unresponsive" in them and hunt down the .cfm pages shown to contain these words, again look for unlocked Application, Server or Session scoped variables. I hope this helps. Mike Brunt Sempra Energy 213.244.5226 "For every action, there is an equal and opposite malfunction." -----Original Message----- From: BILLY CRAVENS [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 19, 2001 8:20 AM To: CF-Talk Subject: Re: CF 5 can't handle DB2 (was: Server running way too slow) I assume that you have all of the shared variables locked? Whereas you could more or less get away with this in prior version, CF5 is very picky about it. --- Billy Cravens ----- Original Message ----- From: "Andrew Peterson" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, December 19, 2001 9:07 AM Subject: CF 5 can't handle DB2 (was: Server running way too slow) > I need to figure out why CF 4.5 and a piddly server can handle our traffic > whereas CF 5.0 and a powerful server cannot. > > Our requests were running so slow when I initially loaded CF 5 that I had to > go back to CF 4.5, where it worked splendidly. Now I reinstalled CF 5 and > page requests are taking way too long again. Way too long. PerfMon shows > cached requests in the 100+ range (and running requests to 5 I think, which > is the default setting in CFIDE - note that I have not changed these from > 4.5, where the default settings worked). > > My conclusion is that it has something to do with CF5 and DB2. Most of our > site accesses a DB2 back end but the whole site is slow. I'm connecting to > DB2 via ODBC because we cannot get the native driver to work (is there a > trick here! DANG!!!). I just don't see how CF can even be a factor here -- > but how can it not? DB2 query processing times are fine (3 seconds), but the > page comes up much later (35+ seconds). > > All of the relevant server settings are set to their defaults as they were > with CF 4.5, though I made mods to them the first time I loaded CF 5 to no > avail. > > Macromedia does not wish to hear from me until I fork over support $$$, > which would be fine but as a govt agency we pay by voucher which can take > weeks. Can someone bail me out? > > Thanks, > Andy > ______________________________________________________________________ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
