On Fri, Dec 29, 2017 at 12:20 PM, < [email protected]> wrote:
> On 2017-12-29 12:00, Stephen Russell wrote: > >> I think you missed my point. this is a separate product you are creating >> that will pull data from VFP and only store it online. You can then build >> up a new style of reporting outside of VFP. Once they approve of it you >> can delete the data older than 4 years or 7 years from the VFP >> environment. The Data Scientist role may suit you very well. >> >> Check out this: >> https://www.zs.com/services/technology/technology-services/ >> big-data-and-data-scientist-services.aspx >> > > > > Thanks for the link. Data Scientist is definitely a job for the future > and big $$$ I think! My original post was not so much about reporting; it > was about hauling tons of data over the LAN that's no longer relevant and > the archival process I proposed to resolve that (without permanently > deleting data). As we said in a previous thread, the whole DBF isn't > coming across the network unless you've got commands like REPLACE ALL etc. > and unfortunately in the case of my previous Corporate app at Sylvan, > there's tons of old code from previous devs where they did that often. > > ---------------------------- My company won't get rid of transactional data and the size of the 4 GL tables that are in my way is roughly 600 gigs. Finding specific data in them that is outside the scope of my indexes takes way too long. It also takes additional time to do a restore as well. In 2018 we are porting to an upgrade on a new data server so it will take each test more time to restore as well. To me, IRS data demands past 7 years. I'll keep 8 and remove 3 years of older transactions now because we already have them in the DW as well. Welcome to my monthly fight. :) -- Stephen Russell Sr. Analyst Ring Container Technology Oakland TN 901.246-0159 cell --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/cajidmyllw1uhzxhknuyzb7smfkm8dwmrz393zsavrqvc1b+...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
