Re: archiving software was: Product to check out?

[Al Mac <macwheel99@xxxxxxxxxxx>]

I have not in the past been able to do what I thought was a good job with 
estimating.  I suspect that certain tasks will go faster if I do X, but I 
not know if it will be enough to be noticeable.

I rewrote how a batch string of programs access their files, and the approx 
2 hour job ran in about 4 minutes less time.

I got permission to get rid of records over 2 years old in one of the files 
used by the batch program.  It now ran in 1 hour instead of 2 hours.

It was a total surprise to me that the speed was that much greater.

I am also looking at other access paths to improve a few tasks performance 
speed..
I know that adding access paths to the total collection has an overall 
degradation.

We have a late nite window of low demand on our system, with a growing pile 
of tasks scheduled to run then, so that people have up to date information 
first thing next morning.

> When you lobbied for archiving software did you ever argue with $?
> The purchase of software xyz for $A
> Will make process B run C minutes shorter.
> An alternative to making process B run C minutes shorter is buying
> additional hardware from IBM at a cost of $D?
>
> Most people can't honestly come up with a vaue for C.  They just wing it.
> We had a gent here who used to piss away vast quantities of time clearing
> up item master records to make things run faster and to save disk space.
> Never could say how much faster, nor how much space he would save.
>
> By the way, the size of the item master in question is 2.7MB or .000071%
> of disk space.  Rather reminds me of Barbara Morris example of some
> people's attempts to tune RPG coding can be compared to the fact that
> stepping on a step ladder does put you closer to the moon.
>
> Rob Berendt
> --
> Group Dekko Services, LLC
> Dept 01.073
> PO Box 2000
> Dock 108
> 6928N 400E
> Kendallville, IN 46755
> http://www.dekko.com
>
>
>
>
>
> Al Mac <macwheel99@xxxxxxxxxxx>
> Sent by: midrange-l-bounces@xxxxxxxxxxxx
> 11/01/2005 01:36 PM
> Please respond to
> Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
>
>
> To
> Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
> cc
>
> Fax to
>
> Subject
> Re: Product to check out?
>
>
>
>
>
>
> Another popular solution, for some packages, is to go with some archiving
> product.
>
> We are on BPCS with many files a million plus records.  The average user
> only needs to see the last few days worth of transactions, at most a
> month,
> but we have a few applications that do need to access stuff that is a year
>
> old.  With archiving, which we do not have, but I have lobbied
> occasionally
> to get, the records that are rarely needed are sitting in another library
> so they not contaminate access efficiency for the 99% normal access needs.
>
> Archiving also provides tools that simplify the task of creating test data
>
> bases.
>
> >Does anyone use this product and can comment on it?
> >
> > > http://www.kisco.com/gofaster/
> > >
> >
> >--
> >This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
> list
> >To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> >To subscribe, unsubscribe, or change list options,
> >visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> >or email: MIDRANGE-L-request@xxxxxxxxxxxx
> >Before posting, please take a moment to review the archives
> >at http://archive.midrange.com/midrange-l.
>
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
> list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
>
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.