cachedwithin and cachedafter (please help)
Posted on 2003-10-29
I'm using cachedwithin and cachedafter in various spots. I used to have it caching up to 100 queries in the cfadmin, but if I set it to 100 now (after I've made changes), the server runs out of memory. Is there any way to see which query is culprit? I've tried to pin down the time at which the server runs out of memory by having it mail me when the server gets low on memory. I can't see any pattern. It's killing server performance to only have 20 queries cached. With only 20 queries cached, the server memory hovers around 100 MB. When I bump it up to 100, there have been times when the server has run out of virtual memory and crashed.