freechn

[Chris Sellitto]

> > Subject: RE: freechn
> >
> > >[.....]
> > > Subject: Re: freechn
> > >
> > > On 3/2/2015 7:20 PM, Richard Kreiss wrote:
> > > [...]
> > > >>> Is there a way to use a wildcard to have freechn rebuild the
> > > >>> primary file as well as all of the qualifiers?
> > > >>
> > > >> You can't put a wildcard on the command line, but you can put it
> > > >> in a loop.
> > > >>    What O/S are you on?
> > > >
> > > > Windows
> > > >
> > > > I think it might be easier to just copy the command line and add
> > > > each qualifier  (4).
> > > >
> > > > Of course one of the qualifiers has almost 20 million records at
> > > > this
> > > point
> > > > and it grows at 1,000 records a week.  This is an indexed file.
> > > >
> > > > The freechn needs to be run on the server otherwise it take much
> > > > too
> > > long to
> > > > finish.
> > >
> > > I guess the bigger question here is...
> > >
> > > Why do you need to rebuild the freechain on a regular basis?
> > >
> > > --
> > > Kenneth Brody
> >
> > On the topic of Freechains, what are the most common causes for
> > freechains
> to
> > occur?  We seem to be getting them here at our facility on a daily
> basis.
> We
> > have 5.7.03, running on a Windows environment.  We have disabled the
> > Window's ability to use the "X" to close a window.  Where else can we
> look?
> >
> > Thank you
> > Chris Sellitto
> 
> Chris,
> 
> I seem to remember a discussion on this topic many years ago.  It was
> related to deleting a lot of records.  It was recommended that after
> deleting a lot of records (Don't know what constitutes a lot of records)
> that freechn be run on that file.
> 
> In the case of my client who had this problem, they do not ship
> backorders so any order item detail not shipped is deleted.  The
> deletion deletes the record from the current file and their order
> history file.  The history file is just shy of 20 million records and
> growing.  The freechn rebuild on this file pops up almost quarterly.  I
> would like to have this done as a task but I need to find time when some
> evening task is not being run.  One report that gets generated takes
> about 3 hours to generate to a csv file and this runs 3 times a week.
> That's 3 hours on the server at night with no one on the system.  It
> hits almost all of the major databases on the system.
> 
> Richard
> 
Thanks for the reply Richard.  I have heard about deleting a lot of records as being a possibility.  I am looking at my processing tables now.

Chris