Also try deleting and reinstalling the odbc driver, my SQL queries were taking way way way too long, I updated the MDAC, deleted the driver deleted the odbc connection reinstalled it and now it works great.
Robert Everland III Dixon Ticonderoga Web Developer Extraordinaire -----Original Message----- From: BILLY CRAVENS [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 19, 2001 11: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/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
