And do your guys clock in and out of jobs frequently? I wouldn't be
surprised if your Labor tables were huge as well.
For a company with over 250 user licenses, this almost makes sense!
This actually might be normal.
M. Manasa Reddy
manasa@... <mailto:manasa@...>
800.852.2325
630.806.2000 ofc
630.806.2001 fax
www.weldcoa.com
________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Milton, Joe
Sent: Tuesday, June 22, 2010 10:47 AM
To: Vic Drecchio; vantage@yahoogroups.com
Subject: RE: [Vantage] Re: DB Size
Yeah, we are a heavy transaction shop with 250 users on 8.03.407. We
actually have single orders with 2K to 4K parts or orders with a few
parts with up to 4000 releases. We have about 1.4 million records in
parttran. Chglog is only about 43K records.
From: Vic Drecchio [mailto:Vic.Drecchio@...
<mailto:Vic.Drecchio%40TIMCO.aero> ]
Sent: Tuesday, June 22, 2010 11:14 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Cc: Milton, Joe
Subject: RE: [Vantage] Re: DB Size
WHAT???!!!
Vantage 8 or 8.03? WOW.....
Something certainly is wrong. I just queried the patchfld table on my
box and it has 31K rows. I'm on ver 8.03.408B.
67GB? Do you have changelogs that are filling up the chglog table? I
have about 880K rows in chglog and I've been up on Vantage for almost 2
yrs.
Growing by 2.5GB per week? How many users? How large is PartTran? Are
you a heavy transaction company??
I've seen a lot of SQL Vantage customers and I've never seen or heard
anything like that before....
________________________________
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of jmilton59
Sent: Tuesday, June 22, 2010 11:01 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Re: DB Size
We are having a similar problem, but on a much larger scale. We are on
MS SQL with Vantage 8 and have been running for less than 2 years and
our database is 67 Gig and growing by 2 to 2.5 gig per week. We found
that the majority of the growth was in the patchfld table. According to
what Epicor has told us this table is used as a holding area for schema
changes between releases. Some holding area...right now we have over 30
million rows (yes you read that right...MILLION). That one table is over
12.7 gig in size.
We opened a ticket with Epicor asking for a way to control the growth
and was told they would work on a script for us, but we have resigned to
the fact that we will have to plan for the continued growth and the
potential impact that will have on performance.
We have run shrinks and index rebuilds which will reclaim some space.
But until Epicor releases the updates to move the schema changes out of
the patchfld table we are stuck with the continued growth. But we are
always open to tips or suggestions that might help.
Joe
Joe Milton, CISSP
Senior Programmer
Pratt Corporation
jmilton@... <mailto:jmilton%40prattcorp.com>
<mailto:jmilton%40prattcorp.com>
--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> , Jose
Gomez <jose@...> wrote:
r/dgr.pdf
r/dgr.pdf
<http://groups.yahoo.com/group/vantage/files/>
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email
__________________________________________________________
__________________________________________________________
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email
__________________________________________________________
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
surprised if your Labor tables were huge as well.
For a company with over 250 user licenses, this almost makes sense!
This actually might be normal.
M. Manasa Reddy
manasa@... <mailto:manasa@...>
800.852.2325
630.806.2000 ofc
630.806.2001 fax
www.weldcoa.com
________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Milton, Joe
Sent: Tuesday, June 22, 2010 10:47 AM
To: Vic Drecchio; vantage@yahoogroups.com
Subject: RE: [Vantage] Re: DB Size
Yeah, we are a heavy transaction shop with 250 users on 8.03.407. We
actually have single orders with 2K to 4K parts or orders with a few
parts with up to 4000 releases. We have about 1.4 million records in
parttran. Chglog is only about 43K records.
From: Vic Drecchio [mailto:Vic.Drecchio@...
<mailto:Vic.Drecchio%40TIMCO.aero> ]
Sent: Tuesday, June 22, 2010 11:14 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Cc: Milton, Joe
Subject: RE: [Vantage] Re: DB Size
WHAT???!!!
Vantage 8 or 8.03? WOW.....
Something certainly is wrong. I just queried the patchfld table on my
box and it has 31K rows. I'm on ver 8.03.408B.
67GB? Do you have changelogs that are filling up the chglog table? I
have about 880K rows in chglog and I've been up on Vantage for almost 2
yrs.
Growing by 2.5GB per week? How many users? How large is PartTran? Are
you a heavy transaction company??
I've seen a lot of SQL Vantage customers and I've never seen or heard
anything like that before....
________________________________
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of jmilton59
Sent: Tuesday, June 22, 2010 11:01 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Re: DB Size
We are having a similar problem, but on a much larger scale. We are on
MS SQL with Vantage 8 and have been running for less than 2 years and
our database is 67 Gig and growing by 2 to 2.5 gig per week. We found
that the majority of the growth was in the patchfld table. According to
what Epicor has told us this table is used as a holding area for schema
changes between releases. Some holding area...right now we have over 30
million rows (yes you read that right...MILLION). That one table is over
12.7 gig in size.
We opened a ticket with Epicor asking for a way to control the growth
and was told they would work on a script for us, but we have resigned to
the fact that we will have to plan for the continued growth and the
potential impact that will have on performance.
We have run shrinks and index rebuilds which will reclaim some space.
But until Epicor releases the updates to move the schema changes out of
the patchfld table we are stuck with the continued growth. But we are
always open to tips or suggestions that might help.
Joe
Joe Milton, CISSP
Senior Programmer
Pratt Corporation
jmilton@... <mailto:jmilton%40prattcorp.com>
<mailto:jmilton%40prattcorp.com>
--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> , Jose
Gomez <jose@...> wrote:
>http://www.progress.com/progress/products/documentation/docs/database/dg
> Thanks we'll give that a try
> Sincerely
> Jose C Gomez
>
> http://www.josecgomez.com
>
>
> On Tue, Jun 22, 2010 at 8:15 AM, Randall Weber <weber.randy@...>wrote:
>
> > Jose,
> >
> > If you're using Progress, try a dump and load:
> >
> >
r/dgr.pdf
> >http://www.progress.com/progress/products/documentation/docs/database/dg
> > <
> >
r/dgr.pdf
> > >WhenEpicor
> > we were on 6.1, we did this and performance increased significantly.
> >
> > --
> > Randy Weber
> > weber.randy@...
> > (651) 263-1811
> >
> > http://randallweber.com/
> >
> >
> > On Mon, Jun 21, 2010 at 10:42 AM, Jose Gomez <jose@...> wrote:
> >
> > >
> > >
> > > It seems like our DB is getting out of hand. We've been running
> > forare
> > > 2
> > > years and your DB is already 5 GB in size. Is there something we
> > > missingmust have
> > > or is this normal??
> > >
> > > Thanks
> > >
> > > Sincerely
> > > Jose C Gomez
> > >
> > > http://www.josecgomez.com
> > >
> > > [Non-text portions of this message have been removed]
> > >
> > >
> > >
> >
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
> > ------------------------------------
> >
> > Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
> > already linked your email address to a yahoo id to enable access. )Builder and
> > (1) To access the Files Section of our Yahoo!Group for Report
> > Crystal Reports and other 'goodies', please goto:<http://groups.yahoo.com/group/vantage/files/>
> > http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/>
> > (2) To search through old msg's goto:__________________________________________________________
> > http://groups.yahoo.com/group/vantage/messages
> > (3) To view links to Vendors that provide Vantage services goto:
> > http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
> >
> >
> >
> >
>
>
> [Non-text portions of this message have been removed]
>
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email
__________________________________________________________
__________________________________________________________
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email
__________________________________________________________
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]