Well, that's the rub, isn't it? It's I didn't want to risk it so waited weeks to get their script.
--- In vantage@yahoogroups.com, Vantage <vantage@...> wrote:
>
> Thanks. I know I can delete the records in there if I want to. But, will I hurt anything if I do it though?
>
> Joe Sanders
> Wipaire, Inc.
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Craig
> Sent: Tuesday, January 17, 2012 9:44 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Purge?
>
>
>
> We to had to the same situation with *very* large IM and IntQueXX tables. We were at one time using the Multi-Company and since we were no longer the records were just sitting instead of getting processed. We had to (1) take out Multi-Company (I don't remember the steps but Epicor walked me through quickly) and (2) they custom wrote something for me to clear out those tables. It took weeks for them to finally get it to me but worked well once I ran it. Unfortunately I believe that it had an expiry of some sort hard-coded into it.
>
> CMR
>
> --- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>, Vantage <vantage@<mailto:vantage@>> wrote:
> >
> > My Analysis came back. I have a total Scatter Factor of 5.2. Of the 817 total tables, 349 tables have a Scatter Factor between 4 and 8.8 while 96 have a Scatter Factor between 1 and 3.0. The rest are all zero's.
> >
> > I did notice that I have a lot of records in the IM tables and the IntQueXX tables. While we did at one time use the Mobile Connect module, we no longer use it and will not in the future. How can I purge/delete that data?
> >
> > Thanks,
> > Joe Sanders
> > Wipaire, Inc.
> >
> > From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of Vantage
> > Sent: Monday, January 16, 2012 10:48 AM
> > To: Brian Roberts; vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
> > Subject: RE: [Vantage] Purge?
> >
> >
> >
> > Brian,
> >
> > Thanks for the data.
> >
> > We have not done a Dump & load in the past. Running the analysis now.
> >
> > We have tried to upgrade a number of times. Problems with the conversion was the first major area. I was the person that identified the problems with the migration of Dimensional Tracked inventory to 9. Then we have had internal issues the last 9 months. We do want to keep as much data as we can in E9.
> >
> > Joe Sanders
> > Wipaire, Inc.
> >
> > From: Brian Roberts [mailto:broberts@<mailto:broberts%40gfxltd.com>]<mailto:[mailto:broberts@%3cmailto:broberts%40gfxltd.com%3e]>
> > Sent: Monday, January 16, 2012 10:43 AM
> > To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
> > Cc: Vantage
> > Subject: RE: [Vantage] Purge?
> >
> > If you haven't already, look at purging your change log & GL transactions (an option in the Vantage menus) - these take up a lot of space.
> >
> > If you're going to upgrade to 6 to 9, there are two major choices for moving your data:
> > - upgrade your entire database through all of the intermediate versions - that took a full weekend for our conversion
> > - move current orders etc over (via DMT) - more work, but you can decide how much history to move
> > This decision will affect how much you worry about purging in Vantage 6.
> >
> > But the dump & load suggested by others will help with performance now.
> >
> > Brian.
> >
> > ________________________________
> > From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>] On Behalf Of Vantage
> > Sent: Monday, January 16, 2012 10:27 AM
> > To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
> > Subject: [Vantage] Purge?
> >
> > All,
> >
> > I'm looking to see if anyone knows if there is a standard amount of time to keep your data before you purge your database.
> >
> > Over the past year or so we have noticed that our performance has deteriorated.
> >
> > Our server is 7 years old and our database size is 11Gig. We are currently running Vantage 6.1 and hopefully will be upgrading to Epicor 9 within the year, but there is no guarantee of that.
> >
> > Thanks,
> > Joe Sanders
> > Wipaire, Inc.
> >
> > [Non-text portions of this message have been removed]
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
> [Non-text portions of this message have been removed]
>