Backup subroutine shutsdown an Oracle 8i database, creates a .zip archive, and puts the contents of two arrays (filenames) into the archive and writes the .zip file. The first array is a list of the database files (these range from 50 MB to 400 MB in size), the second array are user files such as output reports and queries which are almost all less than 50 KB. It does not show a progressbar because it takes less than a second to add all the files to the zip archive (the loop) but it takes over ten minutes to complete the command $zip->writeToFileNamed($new_zip_file). While this one command is running, NT shows my app as "Not responding".
Restore opens a top-level widget with a listbox allowing the user to choose which backup to restore. When they select one and press the "OK" button, it shuts down the database unless it's already shutdown, builds an array with the name of every file in the archive and then extracts each one displaying a progress bar based on the number of files extracted '$percent_done = int(($file_num / $total_files) * 100)'. Even with the progressbar up, the application shows as "Not responding".
Exit restarts the database if it was shutdown and then destroys the widget.
In reply to Re: Application Not Responding
by arden
in thread Application Not Responding
by arden
| For: | Use: | ||
| & | & | ||
| < | < | ||
| > | > | ||
| [ | [ | ||
| ] | ] |