Subject Re: [firebird-support] Batch deletes/inserts everyday-"problem" with backup with garbage collection on
Author ian
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 ?


Simple solution, if the sales have a date, is to import only the new sales.