I have an application where I need to allow users to be able to upload CSV files via the site. The site is built in ColdFusion 9 with a MySQL back-end. These files are LARGE. Sometimes millions of lines. I was thinking of writing something like this:
User selects file using CFFILE to upload to a directory on the site
Use a MySQL stored proc to process
Email or alert the user the parsing is done.
Is there a way to submit something like this to the server and "release" the browser so the user can do other things while the file is processed?
Maybe a status bar showing the progress while the ColdFusion server does'nt time-out?
Any advice would be appreciated