Subject Re: [firebird-support] Batch deletes/inserts everyday-"problem" with backup with garbage collection on
Author Svein Erling Tysvaer
Two questions:

1) Have you tried deleting and recreating the table rather than emptying it?

2) Do you have low selective indexes? If so, define index on
(NonSelectiveField, PrimaryKey) rather than on simply (NonSelectiveField).

And I still don't understand why you cannot import simply the changes
done during the day rather than the entire year. That doesn't sound


Zoran Zivkovic wrote:
> We have IB ib server on Win98 PC.
> We now have 3 remote sales points, and soon we will have few more.
> What we are doing now is:
> Guys in remote sales points generate every evening DBF file with
> their complete sales from the beining of the year. These DBF files
> are becoming larger and larger (60.000 rows, 14000 rows and 16.000
> rows this morning).
> Here, in headquter of company, we have a table PJ inside our IB
> database, and this table we empty every morning, and than fill it
> again with fresh data (about 90.000 rows this morning, from 3 sales
> points).
> During the day, I do 5 backups of database without garbage colection,
> and it last very short - about 90 seconds.
> In the evening, the guys are responsible to do backup which do
> garbage colection, and last evening it was stending 15 minutes saying
> that it is processing table PJ. For this backup we use application
> which uses IB services.
> OK, I hope I described problem good. Questions:
> 1. Is it OK for BACKUP with Garbage colection to last so long on this
> table?
> 2. Is there some other way to "import" these data from remote points,
> so we could avoid these long delete/import/backup procedures ?
> Thanks and regards,
> Zoran Zivkovic