Even after upping the maximum number of cached queries to 200, I did get
another crash last night.
Since then I've made two other changes... changed the section of .cfm code
to cachewithin 1 hour instead of 1 day. reduced the number of simultaneous
requests from 20 to 10 (after reading some of the allaire knowledgebase
articles)
That was 8 hours ago... definately not through peak times. I'll keep a
watchful eye on it today.
(for the morbidly curious, cfserver is 'handing' over 7GB a day over 35,000
user sessions.)
Tim Storm
FatWallet.com
----- Original Message -----
From: "Ryan" <[EMAIL PROTECTED]>
To: "CF-Linux" <[EMAIL PROTECTED]>
Sent: Monday, December 11, 2000 8:46 AM
Subject: Re: Retrieval of cached query failed
> Perhaps when CF caches queries it stores the DSN with the cache entry?
> I wouldn't think that would last accross restarts/reboots, though.
>
> The simple answer is somewhere there is some code that is hard coded
> to use the other dsn. Even if you removed it from the list in CF
> admin, there may still be some data for it on the system somewhere.
>
> Sometimes when I removed a dsn from CF admin on windows, I could go
> in to the ODBC control panel and the DSN would still be there. I've
> also had it screw up when trying to remove a dsn and then add a
> new one with the exact same name.
>
> Good luck,
>
> Ryan
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-linux%40houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_linux or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
