× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



Ok - it's early folks. My response brought you BEYOND soft deleted records to 
purging files. Sorry.

-----Original Message-----
From: bpcs-l-bounces+ssegerstrom=intermatic.com@xxxxxxxxxxxx
[mailto:bpcs-l-bounces+ssegerstrom=intermatic.com@xxxxxxxxxxxx]On Behalf
Of George Sagen
Sent: Wednesday, October 05, 2005 9:15 AM
To: bpcs-l@xxxxxxxxxxxx
Subject: Re: [BPCS-L] Removing Soft-Deleted records from BPCS Files


Andrew,
 
I don't think there's a right or a wrong way to accomplish your goal,
but when I read your post two questions came to mind that would help
guide your decision as to which records you hard delete:
 
1. Some programs allow you to view the soft deleted records as
"History". If physically remove them, you'll no longer be able to see
them. While for your example of the FMA records this is likely not an
issue, you may want to consult with your users.
 
2. Some long-term trend analysis reports may rely on historical soft
deleted records. Good examples would be reports used for building
forecasts, sales analysis, and costing analysis that require several
months or even years of data if seasonality is involved. If you hard
delete them, the reports may suddenly lose a degree of effectiveness. Of
course, if the reports only look at old data and not the recent, moving
these records to a separate table and even summarizing them first may
speed up running the reports as well as the daily transaction
processing.
 
Best wishes,
 
Geo.
 
-------------------------------------------
George Sagen
MITY Enterprises, Inc.
1301 West 400 North
Orem, UT 84057
(801) 224-0589 ext. 442 Office
(801) 360-6360 Cell
(801) 224-6191 Fax
georges@xxxxxxxxxxxx
http://www.mitylite.com
 
CONFIDENTIALITY NOTICE:  This email and any attachments are for the
exclusive and confidential use of the intended recipient.  If you are
not the intended recipient, please do not read, distribute or take
action in reliance upon this message. If you have received this in
error, please notify us immediately by return email and promptly delete
this message and its attachments from your computer system. In the case
that a confidentiality agreement exists between MITY Enterprises, Inc.
or any of its subsidiaries and the recipient(s), use of the information
contained herein is governed under the terms of the agreement.

As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.