Server Push to update progress
Posted on 2009-04-10
I'm working on a project where hitting SUBMIT starts running code that does analytics on the database. It's a long process 30 some queries, with some of them taking 5 minutes or more. I would like to display in a textArea where we are in the process ex:
step 1 - aggregating by zip
step 2 - calculating usage statistics
I'd like to do this as simply as possible. Maybe adding a row to a database table as each step begins and then have a " Refresh Progress" button. Kindofa rinkydink solution. I gather AJAX can do this more elegantly - But never having worked with AJAX I don't know how big a deal it would be. Can anybody provide me with some clear sample code I could adapt.