Processing time depends on the server configuration. There is a setting in the CF Administrator for how much time can pass before a page is deemed unresponsive.
However, I have yet to run into this, even with upload 25 Meg + files (I know, slightly different issue...). And I've heard from others on this list who are doing similar processing as you that they haven't really had a problem. I guess the best bet is to try it and see how long it takes to run. If your routines are built well, I'll bet you'll see faster performance in some cases than the desktop application. As for a 500K file, I doubt that would be an issue. HTH Shawn Grover -----Original Message----- From: Andy Ousterhout [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 16, 2002 9:52 AM To: CF-Talk Subject: RE: How big a file can CFFILE work with Thanks. Yes it does help. I am using an ISP (Host Centric, the old Web 2010), so I don't know how much memory I have access to. The purpose of the upload is to add monthly sales/invoice data from a third party system such as Peachtree into a database that can be accessed from the web for sales forecasting. So far, an entire quarter of sales information is less than 500K. So if I understand you correctly, I should be ok from a memory perspective. Next question is what about processing time. Is there a limit on how long a single screen can run? Processing this file may take minutes (error checking plus file Insert and Update). -----Original Message----- From: Shawn Grover [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 16, 2002 10:42 AM To: CF-Talk Subject: RE: How big a file can CFFILE work with Depends on your web server. IIS implements HTTP file uploads by storing the file to memory. CFFile then uses the file from memory (and writes it to disk, if that is what you want it to do). So in this case, the maximum size depends directly on how much available memory you have. In our case, we have a IIS/CF server, with SQL2000 (small load) that has 512 Meg of RAM. In optimum condiditions, we have shown that it can handle a 67 meg file. This decreases over time though as SQL Server uses more memory. Hope that helps. Shawn Grover -----Original Message----- From: Andy Ousterhout [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 16, 2002 9:30 AM To: CF-Talk Subject: How big a file can CFFILE work with Does anyone have any rules of thumb for how big a file CFFILE READ can safely work with? Andy ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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
