I have a CGI script that inserts data into an oracle database. It takes quite some time (up to an hour depending on how much data I insert). When the script finishes running it outputs some quality control data.
I want to get some periodic updates (every 30 seconds or so) on the progress of the inserts, while the CGI script is running. The only way I can think to do this is to use a link that opens a new window that refreshes a cgi script that queries the db to determine the progress. I would rather use a counter in the script itself and display that information in the original window. Ideally when the inserts were done, the QC data would then write over this information. Anyone know of a good way to do this??