Database size

system · August 6, 2012, 10:57pm

Elizabeth, your table sizes seem normal to me. Parttran, Labordtl, Gljrndtl, Gljrnsrc and Chglog are the biggest for us too.

--- On Mon, 8/6/12, Elizabeth <gracefulthreads@...> wrote:

From: Elizabeth <gracefulthreads@...>
Subject: [Vantage] Database size
To: vantage@yahoogroups.com
Date: Monday, August 6, 2012, 8:22 PM

Â

9.04.507A SQL

On 1/1/2011, we went live on E9 with a database size of about 4G. This had been brought over from a non-Epicor ERP system via DMT.

In the 19 months since, our database has grown to almost 30G (yeah, thirty gigabytes). The only tables that look a little wacky are GLJRNDTL (2.2G Data Size, 7.0G Reserved) and TRANGLC (1.5 Data, 5.1 Reserved).

CHGLOG is only 114M. The only other table over 1G (data size) is JOBOPER, with LABORDTL closing fast.

PARTTRAN and PATCHFLD both have Reserved sizes over a gig, but Data sizes less than half the Reserved.

Is this normal for E9, or is there some way I can slow down the rate of increase here?

Ernie Lowell

Diba Industries

[Non-text portions of this message have been removed]

system · November 16, 2005, 3:36pm

Everyone,

Our database is approaching 2GB in size, and I seem to recall something
about this being a bad thing. We are on Vantage 5.2.325. Is this
something I need to be concerned about, or am I just over-worrying?

Any help?

Brandon R Murch
Supervisor of Information Technology
WindStone Medical Packaging
406.259.6387
bmurch@...

***********************************************************************
Privileged and/or confidential information may be contained in
this message. If you are not the addressee indicated in this
message (or are not responsible for deliver of this message to
that person), you may not copy or deliver this message to
anyone. In such case, you should destroy this message and
notify the sender by reply e-mail. If you or your employer do
not consent to Internet e-mail for messages of this kind,
please advise the sender. Windstone Medical Packaging,
Inc. does not provide or endorse any opinions, conclusions
or other information in this message that do not relate to the
official business of the company.
***********************************************************************

[Non-text portions of this message have been removed]

system · November 16, 2005, 3:38pm

What version of progress are you on? In version 9 you can
EnableLargeFiles to overcome
The 2GB size limit.
Epicor has a document on how to do it.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Brandon Murch
Sent: Wednesday, November 16, 2005 3:30 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Database size

Everyone,

Our database is approaching 2GB in size, and I seem to recall something
about this being a bad thing. We are on Vantage 5.2.325. Is this
something I need to be concerned about, or am I just over-worrying?

Any help?

Brandon R Murch
Supervisor of Information Technology
WindStone Medical Packaging
406.259.6387
bmurch@...

***********************************************************************
Privileged and/or confidential information may be contained in this
message. If you are not the addressee indicated in this message (or are
not responsible for deliver of this message to that person), you may not
copy or deliver this message to anyone. In such case, you should
destroy this message and notify the sender by reply e-mail. If you or
your employer do not consent to Internet e-mail for messages of this
kind, please advise the sender. Windstone Medical Packaging, Inc. does
not provide or endorse any opinions, conclusions or other information in
this message that do not relate to the official business of the company.
***********************************************************************

[Non-text portions of this message have been removed]

------------------------ Yahoo! Groups Sponsor --------------------~-->
Get fast access to your favorite Yahoo! Groups. Make Yahoo! your home
page http://us.click.yahoo.com/dpRU5A/wUILAA/yQLSAA/PhFolB/TM
--------------------------------------------------------------------~->

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
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/links
Yahoo! Groups Links

system · November 16, 2005, 3:40pm

91D SP8

Brandon R Murch
Supervisor of Information Technology
WindStone Medical Packaging
406.259.6387
bmurch@... <mailto:bmurch@...>

-----Original Message-----
From: PLAMAN DICK [mailto:dick.plaman@...]
Sent: Wednesday, November 16, 2005 1:39 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Database size

What version of progress are you on? In version 9 you can
EnableLargeFiles to overcome
The 2GB size limit.
Epicor has a document on how to do it.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Brandon Murch
Sent: Wednesday, November 16, 2005 3:30 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Database size

Everyone,

Our database is approaching 2GB in size, and I seem to recall something
about this being a bad thing. We are on Vantage 5.2.325. Is this
something I need to be concerned about, or am I just over-worrying?

Any help?

Brandon R Murch
Supervisor of Information Technology
WindStone Medical Packaging
406.259.6387
bmurch@...

***********************************************************************
Privileged and/or confidential information may be contained in this
message. If you are not the addressee indicated in this message (or are
not responsible for deliver of this message to that person), you may not
copy or deliver this message to anyone. In such case, you should
destroy this message and notify the sender by reply e-mail. If you or
your employer do not consent to Internet e-mail for messages of this
kind, please advise the sender. Windstone Medical Packaging, Inc. does
not provide or endorse any opinions, conclusions or other information in
this message that do not relate to the official business of the company.
***********************************************************************

[Non-text portions of this message have been removed]

------------------------ Yahoo! Groups Sponsor --------------------~-->
Get fast access to your favorite Yahoo! Groups. Make Yahoo! your home
page http://us.click.yahoo.com/dpRU5A/wUILAA/yQLSAA/PhFolB/TM
--------------------------------------------------------------------~->

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
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/links
Yahoo! Groups Links

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
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/links

SPONSORED LINKS
Manufacturing software
<http://groups.yahoo.com/gads?t=ms&k=Manufacturing+software&w1=Manufactu
ring+software&w2=Membership+database+software&w3=Database+mortgage+softw
are&w4=Pda+database+software&w5=Database+management+software&w6=Database
+marketing+software&c=6&s=188&.sig=OG5F3819UOUOg63i0bu6kA>
Membership database software
<http://groups.yahoo.com/gads?t=ms&k=Membership+database+software&w1=Man
ufacturing+software&w2=Membership+database+software&w3=Database+mortgage
+software&w4=Pda+database+software&w5=Database+management+software&w6=Da
tabase+marketing+software&c=6&s=188&.sig=N5BGdur84p-jyuOomcQdbQ>
Database mortgage software
<http://groups.yahoo.com/gads?t=ms&k=Database+mortgage+software&w1=Manuf
acturing+software&w2=Membership+database+software&w3=Database+mortgage+s
oftware&w4=Pda+database+software&w5=Database+management+software&w6=Data
base+marketing+software&c=6&s=188&.sig=8rvcSQnCqJhTCZu-0Si39A>
Pda database software
<http://groups.yahoo.com/gads?t=ms&k=Pda+database+software&w1=Manufactur
ing+software&w2=Membership+database+software&w3=Database+mortgage+softwa
re&w4=Pda+database+software&w5=Database+management+software&w6=Database+
marketing+software&c=6&s=188&.sig=u3KQrTRPAQfsWIT39aHDkg>
Database management software
<http://groups.yahoo.com/gads?t=ms&k=Database+management+software&w1=Man
ufacturing+software&w2=Membership+database+software&w3=Database+mortgage
+software&w4=Pda+database+software&w5=Database+management+software&w6=Da
tabase+marketing+software&c=6&s=188&.sig=R3CF3ODPY4gwjDZjykQYvw>
Database marketing software
<http://groups.yahoo.com/gads?t=ms&k=Database+marketing+software&w1=Manu
facturing+software&w2=Membership+database+software&w3=Database+mortgage+
software&w4=Pda+database+software&w5=Database+management+software&w6=Dat
abase+marketing+software&c=6&s=188&.sig=lmBkRUiBtvHI1u5dkymDcw>

_____

YAHOO! GROUPS LINKS

* Visit your group "vantage
<http://groups.yahoo.com/group/vantage> " on the web.

* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>

* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service <http://docs.yahoo.com/info/terms/> .

_____

***********************************************************************
Privileged and/or confidential information may be contained in
this message. If you are not the addressee indicated in this
message (or are not responsible for deliver of this message to
that person), you may not copy or deliver this message to
anyone. In such case, you should destroy this message and
notify the sender by reply e-mail. If you or your employer do
not consent to Internet e-mail for messages of this kind,
please advise the sender. Windstone Medical Packaging,
Inc. does not provide or endorse any opinions, conclusions
or other information in this message that do not relate to the
official business of the company.
***********************************************************************

[Non-text portions of this message have been removed]

system · November 16, 2005, 3:43pm

yes if you don't have Large Files enabled, vantage will cease to run. You have two choices, you can make it a multi-? database or enable Large Files. Check with support for the documents on what to do. (I just upgraded to 6.1 as it automatically enabled large files in the upgrade - according to the install documents).

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
Of Brandon Murch
Sent: Wednesday, November 16, 2005 2:30 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Database size

Everyone,

Our database is approaching 2GB in size, and I seem to recall something
about this being a bad thing. We are on Vantage 5.2.325. Is this
something I need to be concerned about, or am I just over-worrying?

Any help?

Brandon R Murch
Supervisor of Information Technology
WindStone Medical Packaging
406.259.6387
bmurch@...

system · November 16, 2005, 3:43pm

Just read the document - is it really that easy?

Brandon R Murch
Supervisor of Information Technology
WindStone Medical Packaging
406.259.6387
bmurch@... <mailto:bmurch@...>

-----Original Message-----
From: PLAMAN DICK [mailto:dick.plaman@...]
Sent: Wednesday, November 16, 2005 1:39 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Database size

What version of progress are you on? In version 9 you can
EnableLargeFiles to overcome
The 2GB size limit.
Epicor has a document on how to do it.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Brandon Murch
Sent: Wednesday, November 16, 2005 3:30 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Database size

Everyone,

Our database is approaching 2GB in size, and I seem to recall something
about this being a bad thing. We are on Vantage 5.2.325. Is this
something I need to be concerned about, or am I just over-worrying?

Any help?

Brandon R Murch
Supervisor of Information Technology
WindStone Medical Packaging
406.259.6387
bmurch@...

***********************************************************************
Privileged and/or confidential information may be contained in this
message. If you are not the addressee indicated in this message (or are
not responsible for deliver of this message to that person), you may not
copy or deliver this message to anyone. In such case, you should
destroy this message and notify the sender by reply e-mail. If you or
your employer do not consent to Internet e-mail for messages of this
kind, please advise the sender. Windstone Medical Packaging, Inc. does
not provide or endorse any opinions, conclusions or other information in
this message that do not relate to the official business of the company.
***********************************************************************

[Non-text portions of this message have been removed]

------------------------ Yahoo! Groups Sponsor --------------------~-->
Get fast access to your favorite Yahoo! Groups. Make Yahoo! your home
page http://us.click.yahoo.com/dpRU5A/wUILAA/yQLSAA/PhFolB/TM
--------------------------------------------------------------------~->

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
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/links
Yahoo! Groups Links

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
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/links

SPONSORED LINKS
Manufacturing software
<http://groups.yahoo.com/gads?t=ms&k=Manufacturing+software&w1=Manufactu
ring+software&w2=Membership+database+software&w3=Database+mortgage+softw
are&w4=Pda+database+software&w5=Database+management+software&w6=Database
+marketing+software&c=6&s=188&.sig=OG5F3819UOUOg63i0bu6kA>
Membership database software
<http://groups.yahoo.com/gads?t=ms&k=Membership+database+software&w1=Man
ufacturing+software&w2=Membership+database+software&w3=Database+mortgage
+software&w4=Pda+database+software&w5=Database+management+software&w6=Da
tabase+marketing+software&c=6&s=188&.sig=N5BGdur84p-jyuOomcQdbQ>
Database mortgage software
<http://groups.yahoo.com/gads?t=ms&k=Database+mortgage+software&w1=Manuf
acturing+software&w2=Membership+database+software&w3=Database+mortgage+s
oftware&w4=Pda+database+software&w5=Database+management+software&w6=Data
base+marketing+software&c=6&s=188&.sig=8rvcSQnCqJhTCZu-0Si39A>
Pda database software
<http://groups.yahoo.com/gads?t=ms&k=Pda+database+software&w1=Manufactur
ing+software&w2=Membership+database+software&w3=Database+mortgage+softwa
re&w4=Pda+database+software&w5=Database+management+software&w6=Database+
marketing+software&c=6&s=188&.sig=u3KQrTRPAQfsWIT39aHDkg>
Database management software
<http://groups.yahoo.com/gads?t=ms&k=Database+management+software&w1=Man
ufacturing+software&w2=Membership+database+software&w3=Database+mortgage
+software&w4=Pda+database+software&w5=Database+management+software&w6=Da
tabase+marketing+software&c=6&s=188&.sig=R3CF3ODPY4gwjDZjykQYvw>
Database marketing software
<http://groups.yahoo.com/gads?t=ms&k=Database+marketing+software&w1=Manu
facturing+software&w2=Membership+database+software&w3=Database+mortgage+
software&w4=Pda+database+software&w5=Database+management+software&w6=Dat
abase+marketing+software&c=6&s=188&.sig=lmBkRUiBtvHI1u5dkymDcw>

_____

YAHOO! GROUPS LINKS

* Visit your group "vantage
<http://groups.yahoo.com/group/vantage> " on the web.

* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>

* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service <http://docs.yahoo.com/info/terms/> .

_____

***********************************************************************
Privileged and/or confidential information may be contained in
this message. If you are not the addressee indicated in this
message (or are not responsible for deliver of this message to
that person), you may not copy or deliver this message to
anyone. In such case, you should destroy this message and
notify the sender by reply e-mail. If you or your employer do
not consent to Internet e-mail for messages of this kind,
please advise the sender. Windstone Medical Packaging,
Inc. does not provide or endorse any opinions, conclusions
or other information in this message that do not relate to the
official business of the company.
***********************************************************************

[Non-text portions of this message have been removed]

system · November 16, 2005, 3:51pm

Multi-extent...

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Podlin, Michael
Sent: Wednesday, November 16, 2005 12:43 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Database size

yes if you don't have Large Files enabled, vantage will cease to run. You
have two choices, you can make it a multi-? database or enable Large Files.
Check with support for the documents on what to do. (I just upgraded to 6.1
as it automatically enabled large files in the upgrade - according to the
install documents).

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf Of
Brandon Murch
Sent: Wednesday, November 16, 2005 2:30 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Database size

Everyone,

Our database is approaching 2GB in size, and I seem to recall something
about this being a bad thing. We are on Vantage 5.2.325. Is this something
I need to be concerned about, or am I just over-worrying?

Any help?

Brandon R Murch
Supervisor of Information Technology
WindStone Medical Packaging
406.259.6387
bmurch@...

------------------------ Yahoo! Groups Sponsor --------------------~--> Get
fast access to your favorite Yahoo! Groups. Make Yahoo! your home page
http://us.click.yahoo.com/dpRU5A/wUILAA/yQLSAA/PhFolB/TM
--------------------------------------------------------------------~->

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
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/links
Yahoo! Groups Links

system · November 16, 2005, 4:23pm

You need to call tech support, right now.

Frank Zeigafuse
Innovative Office Products
General Manager
Direct Phone: 610-559-6369
Email: fzeigafuse@...

Visit www.one.org to see how the world can be changed one person at a time.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Brandon Murch
Sent: Wednesday, November 16, 2005 3:30 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Database size

Everyone,

Our database is approaching 2GB in size, and I seem to recall something
about this being a bad thing. We are on Vantage 5.2.325. Is this something
I need to be concerned about, or am I just over-worrying?

Any help?

Brandon R Murch
Supervisor of Information Technology
WindStone Medical Packaging
406.259.6387
bmurch@...

***********************************************************************
Privileged and/or confidential information may be contained in this message.
If you are not the addressee indicated in this message (or are not
responsible for deliver of this message to that person), you may not copy or
deliver this message to anyone. In such case, you should destroy this
message and notify the sender by reply e-mail. If you or your employer do
not consent to Internet e-mail for messages of this kind, please advise the
sender. Windstone Medical Packaging, Inc. does not provide or endorse any
opinions, conclusions or other information in this message that do not
relate to the official business of the company.
***********************************************************************

[Non-text portions of this message have been removed]

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
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/links
Yahoo! Groups Links

system · August 6, 2012, 4:22pm

9.04.507A SQL

On 1/1/2011, we went live on E9 with a database size of about 4G. This had been brought over from a non-Epicor ERP system via DMT.

In the 19 months since, our database has grown to almost 30G (yeah, thirty gigabytes). The only tables that look a little wacky are GLJRNDTL (2.2G Data Size, 7.0G Reserved) and TRANGLC (1.5 Data, 5.1 Reserved).

CHGLOG is only 114M. The only other table over 1G (data size) is JOBOPER, with LABORDTL closing fast.

PARTTRAN and PATCHFLD both have Reserved sizes over a gig, but Data sizes less than half the Reserved.

Is this normal for E9, or is there some way I can slow down the rate of increase here?

Ernie Lowell
Diba Industries

system · August 6, 2012, 4:35pm

I struggled with this for some time. I work with one company that has a 5GB progress database. I work with another that has the same amount of data and the db is 35GB. It seemed wrong, although there was nothing terribly out of place in the SQL tables. Nothing skewed it that far.

I finally reached a person in tech support (a progress believer) at Epicor that seemed familiar with the question and said it is standard for a SQL database to be 5-10 times larger than a progress database.

Ross

--- In vantage@yahoogroups.com, "Elizabeth" <gracefulthreads@...> wrote:
>
> 9.04.507A SQL
>
> On 1/1/2011, we went live on E9 with a database size of about 4G. This had been brought over from a non-Epicor ERP system via DMT.
>
> In the 19 months since, our database has grown to almost 30G (yeah, thirty gigabytes). The only tables that look a little wacky are GLJRNDTL (2.2G Data Size, 7.0G Reserved) and TRANGLC (1.5 Data, 5.1 Reserved).
>
> CHGLOG is only 114M. The only other table over 1G (data size) is JOBOPER, with LABORDTL closing fast.
>
> PARTTRAN and PATCHFLD both have Reserved sizes over a gig, but Data sizes less than half the Reserved.
>
> Is this normal for E9, or is there some way I can slow down the rate of increase here?
>
> Ernie Lowell
> Diba Industries
>

system · August 6, 2012, 5:00pm

Ernie,
Where I worked before (we started on 8.03 and moved to 9.05 later), in the first few years the growth of the DB didn't seem to make much sense. In the first year, the DB grew in size exponentially and the next year, not so much, plus in the next year we absorbed a second entire company too.
size is usually directly related to transactions and how the DB is used. For instance if your company is running COS/WIP and capturing every day or week, you will post more transactions than if it's done monthly.
In our case, we found that our LbrDtl, PartTran & TranGLC was growing fast because we had a lot of Operations in our methods and we were backflushing everything. (PartTran & TranGLC usually go hand in hand, but TranGLC will create the most records because it is where all your GL transactions are posted... every... single ... one).
So on Labor reporting & backflushing:

If I have 10 Mtls related to each of 10 operations and on each operation the operator only completes 10 on average a day and reports qty every two parts (2 per skid), this means that each report qty would generate 11 PartTran transactions and 1 LbrDtl transaction. If the job was for making 10 parts, then in this example, when finished, I would at least have 50 LbrDtl and at least 500 Backflush PartTran records + the 5 MFG-STK transactions... that's for one job. Once these are captured, those all hit TranGLC too.

Something that may help is that in 9.04 or 9.05, not sure when it came out, they added a Database Purge & Summarize option under Main Menu > System Management > Utilities. Take a look at that, it might help to reduce your DB size... however, I wouldn't run anything like this unless you ok it with your accounting department and others who have a vested interest in the data this may purge & summarize. I would think it would be a good policy for everyone to agree to a schedule for this to be ran... perhaps after each year end close all the Labor & Job elements can be purged and summarize, or perhaps everything that is older than X months or years. Either way it is a really big deal, but it could tame your DB size issue... over time.

Other than that, I believe it normal for a new DB to grow quickly in the first 2yrs, but it then seems to slow down, in my experience. Besides, storage is cheap... right?

-Rick Bird
IT Software Administrator
Rowmark, LLC.

--- In vantage@yahoogroups.com, "Elizabeth" <gracefulthreads@...> wrote:
>
> 9.04.507A SQL
>
> On 1/1/2011, we went live on E9 with a database size of about 4G. This had been brought over from a non-Epicor ERP system via DMT.
>
> In the 19 months since, our database has grown to almost 30G (yeah, thirty gigabytes). The only tables that look a little wacky are GLJRNDTL (2.2G Data Size, 7.0G Reserved) and TRANGLC (1.5 Data, 5.1 Reserved).
>
> CHGLOG is only 114M. The only other table over 1G (data size) is JOBOPER, with LABORDTL closing fast.
>
> PARTTRAN and PATCHFLD both have Reserved sizes over a gig, but Data sizes less than half the Reserved.
>
> Is this normal for E9, or is there some way I can slow down the rate of increase here?
>
> Ernie Lowell
> Diba Industries
>