if there was a method to say detach a shadow in a running system rather than
dropping it (and having it deleted) or shutting down and physically
detaching it, then i'm sure this could be very feasible in a production
scenario, especially if the gfix mechanism could be automated (i haven't
delved far enough through the documentation to know if gfix is available via
api for example).

--
Ungod (W.King)
www.bytamin-c.com
www.magick.tm
I found the answer, now where'd I put that problem...


-----Original Message-----
From: Leyne, Sean [mailto:InterbaseArchitecture@...]
Sent: Saturday, 24 June 2000 3:45 AM
To: 'IB-Architect@egroups.com'
Subject: RE: [IB-Architect] Shadows questions...


So your answer is 46 hours in comparison to 52 hours, right? <grin>

How big is your db? (and can't remember off hand from your previous
postings...)

Well, I don't know about you but, that doesn't seem to be much of an
increase.


Which makes me questions whether the current "create a backup using the
shadow process" discussion has any real benefit, within the context of
enabling a new HIGH-SPEED database backup process.


Sean
-----Original Message-----
From: Dalton Calford [mailto:dcalford@...]
Sent: Friday, June 23, 2000 1:38 PM
To: IB-Architect@egroups.com
Subject: Re: [IB-Architect] Shadows questions...

Hi Sean,

That is a very good question.

You see, when we are using this technique, we have two or three shadows
going at a time.
We prune one off which, once the shadow is created, seems to take only a
minute, and we add another on, but since we already have the backup in
hand, we do not pay attention to the time it takes to create a new
shadow.

When I started playing with shadows (and pestering poor Ann with alot of
questions about changing page sizes and other such nonsense) I found
that they seemed faster (by 6 hours or so in comparison to the backup
process). BUT, please remember, that the only way to take a proper
reading is to have the shadow file on a separite data bus (scsi channel)
and to have the whole storage device dedicated to it. Then to try the
same thing with a backup. And you need to do the comparison without any
others attached to the database.
You see, both user and hardware contention can skew the numbers in any
direction. If you are going to perform tests, you need an environment a
little less chaotic than what we have here.

We use this technique for our test databases when we may need to fork a
database to try a new process or technique while not disturbing the
developements of others in the office.

best regards

Dalton

"Leyne, Sean" wrote:

>
> Dalton,
>
> How does the performance of the create shadow compare to performing a
> full backup of your DB?
>
> Sean

------------------------------------------------------------------------
IT Professionals: Match your unique skills with the best IT projects at
http://click.egroups.com/1/3381/6/_/830676/_/961781774/
------------------------------------------------------------------------

To unsubscribe from this group, send an email to:
IB-Architect-unsubscribe@onelist.com



------------------------------------------------------------------------
IT Professionals: Match your unique skills with the best IT projects at
http://click.egroups.com/1/3381/6/_/830676/_/961782320/
------------------------------------------------------------------------

To unsubscribe from this group, send an email to:
IB-Architect-unsubscribe@onelist.com