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 > ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
