I have this with FB 1 as well. The best way to do this (after a bit of
experimentation) was to back up with the -g option (to disable garbage
collection) as I normally restore straight away.
BTW i add between 200 and 2,000,000 records to 3 tables, run a stored proc
to process the data, then delete the input data, so there is always a large
amount of garbage in there.
Rich P...

-----Original Message-----
From: Alan McDonald [mailto:alan@...]
Sent: 07 August 2002 13:34
To: ib-support@yahoogroups.com
Subject: RE: [ib-support] IB 5.6 performance


just by coincidence I accidentally added about 20k records to a table the
other day, then deleted them (delete from table), then backed up the
database and yep - it took an extraordinary amount of time*thought it was my
imagination). It restored in no time flat. I thought it was just a fluke, or
me or something else but seing your post here I have to rethink it.
But how often would you be doing this?
Alan
-----Original Message-----
From: news@... [mailto:news@...]On Behalf Of Paul
Hope
Sent: Wednesday, 7 August 2002 22:25
To: ib-support@yahoogroups.com
Subject: [ib-support] IB 5.6 performance


Hi

Up until now IB performance hasn't been a problem. But strange things
are
happening to a new database we are building. The import routine creates
about 260,000 records in one table.

Having done it I want to delete all the record and start again.
If I do 'delete from table' followed by a 'select * from table' I would
expect the latter to take some time because (I believe) it is doing
garbage
collection - however I wouldn't expect it to take several hours :-(

Last night I did a 'delete from table' then a backup and restore. The
backup took 5.5 hours - the restore took 3 minutes!

The server isn't particularly fast (maybe a 300Mhz) but we havn't had this
sort of time problem before. The processor is runing at 100% and I don't
understand what the memory utilisation is telling me, there looks like
plenty of free disk space.

Running NT4 sp6a

Could there be an IB problem I can look at - if so where do I look?

Regards
Paul





Yahoo! Groups Sponsor
ADVERTISEMENT



To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]



To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/