I do the same - once a year I import some rather large tables, do some
procedures and, in my case, I don't delete the data til I import again.

There is no need to think about swap space though, IB takes care of all that
for you.
There used to be a config setting for memory pages (RAM) to use but I really
haven't tinkered with this since leaving 4.2 behind - maybe someone else can
comment.

IB grows to meet your needs automically, then to rid it of unwanted page
storage (garbage), back it up and restore it - voila you have a nicely laid
out db with additional space within the pages to grow before major (large)
additions require the server to resize the On-Disk-Structure again
(automatically).

It really is a matter of leave it alone.

Alan
-----Original Message-----
From: news@... [mailto:news@...]On Behalf Of Paul
Hope
Sent: Thursday, 8 August 2002 17:39
To: ib-support@yahoogroups.com
Subject: Re: [ib-support] IB 5.6 performance


Alan

Not very often. That is once my import routines have been proven and the
actual data migration has taken place that will be it - for this customer
anyway.

But what I'm really wandering is does IB have enough memory / virtual
memory
/ scratch space to avoid lots of swapping and how can I tell?

Regards
Paul

""Alan McDonald"" <alan@...> wrote in message
news:NBBBJKLIEJPCMJJOFDNPGEIMECAA.alan@......

> 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/

>
>
>

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]