Using 1.4.2_12-b03. Not sure if that's the default JRE or not. I'll look into Robi's blog post.
A line-by-line file reader could definitely help -- The idea being I'd only save into memory one line at a time and only keep the lines I want to display to the user. I hadn't thought of that solution! As far as caching -- after I left the office last night, I had the idea that might be part of the problem rather than the solution. I didn't remember the caching part until last night, but here's the jist of how it works: 1. User logs in and requests a file. 2. Application reads file, and builds a Query object out of it. Every line of the file is saved to the Query. 3. A SELECT statement is performed on the Query to only get the relevant data for that user (cached for 30 minutes) 4. Results of SELECT shown to user The caching was added to speed up the processing on that page, but I'm wondering if it's causing my memory issues. Assuming the Query object is probably about the same size as the file the user reads, then I'd be caching the 200kb-5mb for every user. Sounds great for CPU/speed performance, but not so good for memory conservation. Am I off my rocker, or could this be the culprit? Jonathon ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295006 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
