|Subject||Re: Batch deletes/inserts everyday-"problem" with backup with garbage collection|
--- In email@example.com, ian <ian@...> wrote:
> Zoran Zivkovic wrote:
> > We have IB 22.214.171.124 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
> > are becoming larger and larger (60.000 rows, 14000 rows and16.000
> > rows this morning).sales
> > 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
> > points).colection,
> > During the day, I do 5 backups of database without garbage
> > and it last very short - about 90 seconds.saying
> > In the evening, the guys are responsible to do backup which do
> > garbage colection, and last evening it was stending 15 minutes
> > that it is processing table PJ. For this backup we useapplication
> > which uses IB services.this
> > OK, I hope I described problem good. Questions:
> > 1. Is it OK for BACKUP with Garbage colection to last so long on
> > table?points,
> > 2. Is there some other way to "import" these data from remote
> > so we could avoid these long delete/import/backup procedures ?new sales.
> Simple solution, if the sales have a date, is to import only the
>Unfortunatelly, it isnt so simple.