At 10:49 PM 21/04/2004 -0400, you wrote:

>Hey all,
>
>I had a test database that I had inserted about 1 million rows into one
>table and about 450K into another. I did this for testing an application
>and database performance, etc. Anyway, I deleted the data from both of
>these tables and wanted to back up and restore to force clean up. Backing
>up took like 15 minutes on my AMD Athalon 2200 with 394 MB DDR Mem (my work
>station) and I was wondering if this was probably due to garbage collection
>because of the two large deletes that I had just performed.
>
>I used IBExpert to perform the backup and it was like 10 minutes before the
>backup window (the one that shows the gbak messages scrolling) could repaint
>itself and start showing the gback messages that were coming in. I could
>see the disk activity however. That is why I was wondering about the
>garbage collection since I assumed that was performed first during a backup
>if that flag is set.

Well, "the flag is set" by default. If you're only backing up in order to
restore, there's no point in doing GC, so you can set garbage collection
OFF by using the -g switch. If the purpose of doing the backup was to
"force cleanup" then you got what you wanted, without even having to ask. :-)

/heLen