in reply to Application Not Responding
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.
|
|---|
| Replies are listed 'Best First'. | |
|---|---|
|
Re: Re: Application Not Responding
by Thelonius (Priest) on Feb 28, 2003 at 01:47 UTC | |
|
Re: Re: Application Not Responding
by BrowserUk (Patriarch) on Feb 28, 2003 at 02:11 UTC | |
by arden (Curate) on Mar 14, 2003 at 16:14 UTC | |
by dragonchild (Archbishop) on Mar 14, 2003 at 16:56 UTC | |
by arden (Curate) on May 29, 2003 at 16:50 UTC |