--- In firebird-support@yahoogroups.com, "Zoran Zivkovic"
<zilez2003@...> wrote:

>

Instead of clearing out the table you could drop the table and
re-create it. That might avoid the garbage collection.

Dave

> --- In firebird-support@yahoogroups.com, ian <ian@> wrote:
> >
> > Zoran Zivkovic wrote:
> > > We have IB 6.0.1.6 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 ?
> > >
> >
> > Hi,
> >
> > Simple solution, if the sales have a date, is to import only the
> new sales.
> >
> > regards
> > ian
> >
>
> Unfortunatelly, it isnt so simple.
>
> Regards
>
> Zoran Zivkovic
>