At 10:43 PM 29/11/2008, you wrote:

>Hello everybody !!
>
>I have a problem with my firebird 1.5 database. My database backup is
>very slow after i performed a large delete in my data table. There was
>more than 30 Lac records in my table. Yesterday i have deleted 15 Lac
>records from it.

What is Lac? Thousands?

>after i have tried to take a backup, it is taking a huge time.

>I have more than 300 tables in the database. but the
>problem shows only for the particular table. the table has 3 blob fields.

45,000 dead blobs of indeterminate size...many or most might be one blob per page. Plus the stubs of 15,000 dead records. That's a table with a lot of garbage to get rid of.

>anyone can help me to solve the problem ?

One way or another, the garbage has to be cleaned up. If you do a regular backup, gbak cleans out garbage. When there is a huge amount of garbage it will take a long time to run your backup. This makes sense if you plan to keep using the same database.

If the object of the backup is to restore a fresh database then perform the backup with the -g switch -[no_]g[arbage_collection] and restore using the -c switch. Rename the old database before you restore.

./heLen