Hey all! I am building an application that will accept comma delimited files of a standard format from a variety of users which need to be processed and inserted into a database.
My concern is the text files may at some point in the future become too large to "Read" using CFFILE since this tag stores the contents in memory. What would be considered too big? By my guesstimating a 5meg text file roughly equals 70K records (the size I expect to see initially). 100 users could be uploading and processing at the same time meaning 500meg of RAM is being utilized. My server has 1 gig of RAM so this doesn't appear problematic at the moment. Am I considering all the important angles? I read about a possible alternative in the archives making the uploaded text file a datasource. An interesting option but I don't see how that would work considering I will have multiple users running concurrently. Each uploaded file would need to be named uniquely with the user's User_ID and Session info. Any other options? Thanks! BJG _________________________________________________________________ MSN 8 with e-mail virus protection service: 2 months FREE* http://join.msn.com/?page=features/virus ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
