SPAM RE: 6.0 DB Tuning Opinion Needed

system · March 30, 2004, 3:56pm

Ours is currently over 12 GB. When we did a test conversion to version 6 it
actually shrunk down to 8 GB. I think we add about 1-2 GB a year (maybe
more).

M. Manasa Reddy
ERP Specialist
Crestview Aerospace Corp
Aerostructures Division
Email: mreddy@...
Phone: (850) 682-2746 x272

-----Original Message-----
From: John Mansfield [mailto:johnm@...]
Sent: Tuesday, March 30, 2004 12:22 PM
To: vantage@yahoogroups.com
Subject: RE: **SPAM** RE: [Vantage] 6.0 DB Tuning Opinion Needed

Hi Cliff,

We are on 6.0 and the db grows at about 2 mb/day with intermittent jumps
of 10mb.

The monthly change is approx 60 mb.

Thanks,

John Mansfield

-----Original Message-----
From: Cliff Drumeller [mailto:cliff@...]
Sent: Tuesday, March 30, 2004 12:03 PM
To: 'vantage@yahoogroups.com'
Subject: **SPAM** RE: [Vantage] 6.0 DB Tuning Opinion Needed

Todd

Hope you have plenty of space on your server. My 4.0 database grew
100
MB in a year. I upgraded to 6.0 last August and it is growing at the
rate of
100 MB a month !! Converted at 2.4 GB - I'm now at 3.7 GB. Are others
experienceing the same growth ??

Cliff Drumeller
IT Manager
Mass Precision Sheetmetal
408 954 0200 x 217

-----Original Message-----
From: Todd Caughey [mailto:caugheyt@...]
Sent: Tuesday, March 30, 2004 7:16 AM
To: vantage@yahoogroups.com
Subject: [Vantage] 6.0 DB Tuning Opinion Needed

Since moving to 6.0 we are experiencing a LOT of slowness. Very long
startups (despite anti-virus exclusions) and Reports taking double the
normal time to run.

A while back Ben Nixon from Epicor had made some DB tweaks while here to
install Corvu / VBI. These are in the old Vantage database and probably
not
in the new MfgSys database. For sure not in the new one because it was
installed with a limit of 32 users which caused some grief yesterday
when
1/3 of the users could not log in. Being the same basic database and
still
Progress 9.1d I should be able to copy all the settings from the old DB
to
the new one - right? Then probably have to shut the DB down and restart
for
them to take effect, also right?

Any other tips for making 6.0 not run so much slower than 5.20 was?

Thanks,
Todd Caughey
Harvey Vogel Mfg. Co.

[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/.
<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
<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
<http://groups.yahoo.com/group/vantage/links>

Yahoo! Groups Sponsor

ADVERTISEMENT

<http://rd.yahoo.com/SIG=12csi89jg/M=267637.4673019.5833256.1261774/D=eg
roup
web/S=1705007183:HM/EXP=1080746230/A=1945637/R=0/SIG=11t30skn6/*http://w
ww.n
etflix.com/Default?mqso=60178397&partid=4673019> click here

<http://us.adserver.yahoo.com/l?M=267637.4673019.5833256.1261774/D=egrou
pweb
/S=:HM/A=1945637/rand=538885446>

_____

Yahoo! Groups Links

* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
<http://groups.yahoo.com/group/vantage/>

* 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/> .

[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/.
<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

* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/

* 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
<http://docs.yahoo.com/info/terms/> Service.

[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 Sponsor
ADVERTISEMENT

----------------------------------------------------------------------------
--
Yahoo! Groups Links

a.. To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/

b.. To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com

c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

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

system · March 30, 2004, 10:17am

Since moving to 6.0 we are experiencing a LOT of slowness. Very long startups (despite anti-virus exclusions) and Reports taking double the normal time to run.

A while back Ben Nixon from Epicor had made some DB tweaks while here to install Corvu / VBI. These are in the old Vantage database and probably not in the new MfgSys database. For sure not in the new one because it was installed with a limit of 32 users which caused some grief yesterday when 1/3 of the users could not log in. Being the same basic database and still Progress 9.1d I should be able to copy all the settings from the old DB to the new one - right? Then probably have to shut the DB down and restart for them to take effect, also right?

Any other tips for making 6.0 not run so much slower than 5.20 was?

Thanks,
Todd Caughey
Harvey Vogel Mfg. Co.

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

system · March 30, 2004, 10:54am

We are having similar problems.

We are on version 6.0 and the production detail report is very slow.

Logins from my lan clients are very slow.

Our database size is just over 1 gig.

We have recently added 3 users and 3 data collection licenses.

Thanks for the help.

John Mansfield

General Sheet Metal

-----Original Message-----
From: Todd Caughey [mailto:caugheyt@...]
Sent: Tuesday, March 30, 2004 10:16 AM
To: vantage@yahoogroups.com
Subject: [Vantage] 6.0 DB Tuning Opinion Needed

Since moving to 6.0 we are experiencing a LOT of slowness. Very long
startups (despite anti-virus exclusions) and Reports taking double the
normal time to run.

A while back Ben Nixon from Epicor had made some DB tweaks while here to
install Corvu / VBI. These are in the old Vantage database and probably
not in the new MfgSys database. For sure not in the new one because it
was installed with a limit of 32 users which caused some grief yesterday
when 1/3 of the users could not log in. Being the same basic database
and still Progress 9.1d I should be able to copy all the settings from
the old DB to the new one - right? Then probably have to shut the DB
down and restart for them to take effect, also right?

Any other tips for making 6.0 not run so much slower than 5.20 was?

Thanks,
Todd Caughey
Harvey Vogel Mfg. Co.

[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/.
<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 Sponsor

ADVERTISEMENT

<http://rd.yahoo.com/SIG=12csi89jg/M=267637.4673019.5833256.1261774/D=eg
roupweb/S=1705007183:HM/EXP=1080746230/A=1945637/R=0/SIG=11t30skn6/*http
:/www.netflix.com/Default?mqso=60178397&partid=4673019> click here

<http://us.adserver.yahoo.com/l?M=267637.4673019.5833256.1261774/D=egrou
pweb/S=:HM/A=1945637/rand=538885446>

_____

Yahoo! Groups Links

* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/

* 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
<http://docs.yahoo.com/info/terms/> Service.

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

system · March 30, 2004, 11:35am

Vantage 6.x introduced several hundred tables into the schema and as a
result vastly increased the size of the meta data. Since Progress loads the
schema at login the resulting delays are predictable and unfortunately
unavoidable.

Michael

Michael Barry
Aspacia Systems Inc
866.566.9600
312.803.0730 fax
http://www.aspacia.com/

-----Original Message-----
From: John Mansfield [mailto:johnm@...]
Sent: Tuesday, March 30, 2004 7:55 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] 6.0 DB Tuning Opinion Needed

We are having similar problems.

We are on version 6.0 and the production detail report is very slow.

Logins from my lan clients are very slow.

Our database size is just over 1 gig.

We have recently added 3 users and 3 data collection licenses.

Thanks for the help.

John Mansfield

General Sheet Metal

-----Original Message-----
From: Todd Caughey [mailto:caugheyt@...]
Sent: Tuesday, March 30, 2004 10:16 AM
To: vantage@yahoogroups.com
Subject: [Vantage] 6.0 DB Tuning Opinion Needed

Since moving to 6.0 we are experiencing a LOT of slowness. Very long
startups (despite anti-virus exclusions) and Reports taking double the
normal time to run.

A while back Ben Nixon from Epicor had made some DB tweaks while here to
install Corvu / VBI. These are in the old Vantage database and probably not
in the new MfgSys database. For sure not in the new one because it was
installed with a limit of 32 users which caused some grief yesterday when
1/3 of the users could not log in. Being the same basic database and still
Progress 9.1d I should be able to copy all the settings from the old DB to
the new one - right? Then probably have to shut the DB down and restart for
them to take effect, also right?

Any other tips for making 6.0 not run so much slower than 5.20 was?

Thanks,
Todd Caughey
Harvey Vogel Mfg. Co.

[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/.
<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 Sponsor

ADVERTISEMENT

<http://rd.yahoo.com/SIG=12csi89jg/M=267637.4673019.5833256.1261774/D=eg
roupweb/S=1705007183:HM/EXP=1080746230/A=1945637/R=0/SIG=11t30skn6/*http
:/www.netflix.com/Default?mqso=60178397&partid=4673019> click here

<http://us.adserver.yahoo.com/l?M=267637.4673019.5833256.1261774/D=egrou
pweb/S=:HM/A=1945637/rand=538885446>

_____

Yahoo! Groups Links

* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/

* 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
<http://docs.yahoo.com/info/terms/> Service.

[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 · March 30, 2004, 11:42am

Anyone test using the "System Management/Utilities/Create Schema Cache File"
on version 6.0?
Anyone still doing this?
Wasn't this the purpose of the cashe file locally to speed up logins?

Patrick Winter

-----Original Message-----
From: Michael Barry [mailto:mbarry@...]
Sent: Tuesday, March 30, 2004 10:35 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] 6.0 DB Tuning Opinion Needed

Vantage 6.x introduced several hundred tables into the schema and as a
result vastly increased the size of the meta data. Since Progress loads the
schema at login the resulting delays are predictable and unfortunately
unavoidable.

Michael

Michael Barry
Aspacia Systems Inc
866.566.9600
312.803.0730 fax
http://www.aspacia.com/

-----Original Message-----
From: John Mansfield [mailto:johnm@...]
Sent: Tuesday, March 30, 2004 7:55 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] 6.0 DB Tuning Opinion Needed

We are having similar problems.

We are on version 6.0 and the production detail report is very slow.

Logins from my lan clients are very slow.

Our database size is just over 1 gig.

We have recently added 3 users and 3 data collection licenses.

Thanks for the help.

John Mansfield

General Sheet Metal

-----Original Message-----
From: Todd Caughey [mailto:caugheyt@...]
Sent: Tuesday, March 30, 2004 10:16 AM
To: vantage@yahoogroups.com
Subject: [Vantage] 6.0 DB Tuning Opinion Needed

Since moving to 6.0 we are experiencing a LOT of slowness. Very long
startups (despite anti-virus exclusions) and Reports taking double the
normal time to run.

A while back Ben Nixon from Epicor had made some DB tweaks while here to
install Corvu / VBI. These are in the old Vantage database and probably not
in the new MfgSys database. For sure not in the new one because it was
installed with a limit of 32 users which caused some grief yesterday when
1/3 of the users could not log in. Being the same basic database and still
Progress 9.1d I should be able to copy all the settings from the old DB to
the new one - right? Then probably have to shut the DB down and restart for
them to take effect, also right?

Any other tips for making 6.0 not run so much slower than 5.20 was?

Thanks,
Todd Caughey
Harvey Vogel Mfg. Co.

[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/.
<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 Sponsor

ADVERTISEMENT

<http://rd.yahoo.com/SIG=12csi89jg/M=267637.4673019.5833256.1261774/D=eg
roupweb/S=1705007183:HM/EXP=1080746230/A=1945637/R=0/SIG=11t30skn6/*http
:/www.netflix.com/Default?mqso=60178397&partid=4673019> click here

<http://us.adserver.yahoo.com/l?M=267637.4673019.5833256.1261774/D=egrou
pweb/S=:HM/A=1945637/rand=538885446>

_____

Yahoo! Groups Links

* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/

* 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
<http://docs.yahoo.com/info/terms/> Service.

[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

------------------------ Yahoo! Groups Sponsor ---------------------~--> Buy
Ink Cartridges or Refill Kits for your HP, Epson, Canon or Lexmark Printer
at MyInks.com. Free s/h on orders $50 or more to the US & Canada.
http://www.c1tracking.com/l.asp?cid=5511
http://us.click.yahoo.com/mOAaAA/3exGAA/qnsNAA/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 · March 30, 2004, 11:48am

The improvement is negligible...

-----Original Message-----
From: pjw@... [mailto:pjw@...]
Sent: Tuesday, March 30, 2004 8:43 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] 6.0 DB Tuning Opinion Needed

Anyone test using the "System Management/Utilities/Create Schema Cache File"
on version 6.0?
Anyone still doing this?
Wasn't this the purpose of the cashe file locally to speed up logins?

Patrick Winter

-----Original Message-----
From: Michael Barry [mailto:mbarry@...]
Sent: Tuesday, March 30, 2004 10:35 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] 6.0 DB Tuning Opinion Needed

Vantage 6.x introduced several hundred tables into the schema and as a
result vastly increased the size of the meta data. Since Progress loads the
schema at login the resulting delays are predictable and unfortunately
unavoidable.

Michael

Michael Barry
Aspacia Systems Inc
866.566.9600
312.803.0730 fax
http://www.aspacia.com/

-----Original Message-----
From: John Mansfield [mailto:johnm@...]
Sent: Tuesday, March 30, 2004 7:55 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] 6.0 DB Tuning Opinion Needed

We are having similar problems.

We are on version 6.0 and the production detail report is very slow.

Logins from my lan clients are very slow.

Our database size is just over 1 gig.

We have recently added 3 users and 3 data collection licenses.

Thanks for the help.

John Mansfield

General Sheet Metal

-----Original Message-----
From: Todd Caughey [mailto:caugheyt@...]
Sent: Tuesday, March 30, 2004 10:16 AM
To: vantage@yahoogroups.com
Subject: [Vantage] 6.0 DB Tuning Opinion Needed

Since moving to 6.0 we are experiencing a LOT of slowness. Very long
startups (despite anti-virus exclusions) and Reports taking double the
normal time to run.

A while back Ben Nixon from Epicor had made some DB tweaks while here to
install Corvu / VBI. These are in the old Vantage database and probably not
in the new MfgSys database. For sure not in the new one because it was
installed with a limit of 32 users which caused some grief yesterday when
1/3 of the users could not log in. Being the same basic database and still
Progress 9.1d I should be able to copy all the settings from the old DB to
the new one - right? Then probably have to shut the DB down and restart for
them to take effect, also right?

Any other tips for making 6.0 not run so much slower than 5.20 was?

Thanks,
Todd Caughey
Harvey Vogel Mfg. Co.

[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/.
<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 Sponsor

ADVERTISEMENT

<http://rd.yahoo.com/SIG=12csi89jg/M=267637.4673019.5833256.1261774/D=eg
roupweb/S=1705007183:HM/EXP=1080746230/A=1945637/R=0/SIG=11t30skn6/*http
:/www.netflix.com/Default?mqso=60178397&partid=4673019> click here

<http://us.adserver.yahoo.com/l?M=267637.4673019.5833256.1261774/D=egrou
pweb/S=:HM/A=1945637/rand=538885446>

_____

Yahoo! Groups Links

* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/

* 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
<http://docs.yahoo.com/info/terms/> Service.

[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

------------------------ Yahoo! Groups Sponsor ---------------------~--> Buy
Ink Cartridges or Refill Kits for your HP, Epson, Canon or Lexmark Printer
at MyInks.com. Free s/h on orders $50 or more to the US & Canada.
http://www.c1tracking.com/l.asp?cid=5511
http://us.click.yahoo.com/mOAaAA/3exGAA/qnsNAA/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

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 · March 30, 2004, 12:03pm

Todd

Hope you have plenty of space on your server. My 4.0 database grew 100
MB in a year. I upgraded to 6.0 last August and it is growing at the rate of
100 MB a month !! Converted at 2.4 GB - I'm now at 3.7 GB. Are others
experienceing the same growth ??

Cliff Drumeller
IT Manager
Mass Precision Sheetmetal
408 954 0200 x 217

-----Original Message-----
From: Todd Caughey [mailto:caugheyt@...]
Sent: Tuesday, March 30, 2004 7:16 AM
To: vantage@yahoogroups.com
Subject: [Vantage] 6.0 DB Tuning Opinion Needed

Since moving to 6.0 we are experiencing a LOT of slowness. Very long
startups (despite anti-virus exclusions) and Reports taking double the
normal time to run.

A while back Ben Nixon from Epicor had made some DB tweaks while here to
install Corvu / VBI. These are in the old Vantage database and probably not
in the new MfgSys database. For sure not in the new one because it was
installed with a limit of 32 users which caused some grief yesterday when
1/3 of the users could not log in. Being the same basic database and still
Progress 9.1d I should be able to copy all the settings from the old DB to
the new one - right? Then probably have to shut the DB down and restart for
them to take effect, also right?

Any other tips for making 6.0 not run so much slower than 5.20 was?

Thanks,
Todd Caughey
Harvey Vogel Mfg. Co.

[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/.
<http://groups.yahoo.com/group/vantage/files/.>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<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
<http://groups.yahoo.com/group/vantage/links>

Yahoo! Groups Sponsor

ADVERTISEMENT

<http://rd.yahoo.com/SIG=12csi89jg/M=267637.4673019.5833256.1261774/D=egroup
web/S=1705007183:HM/EXP=1080746230/A=1945637/R=0/SIG=11t30skn6/*http://www.n
etflix.com/Default?mqso=60178397&partid=4673019> click here

<http://us.adserver.yahoo.com/l?M=267637.4673019.5833256.1261774/D=egroupweb
/S=:HM/A=1945637/rand=538885446>

_____

Yahoo! Groups Links

* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
<http://groups.yahoo.com/group/vantage/>

* 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/> .

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

system · March 30, 2004, 12:13pm

We are. In three years we had generated 100mb per year of data. Its growing by about 80mb a month now.
Jeremy

-----Original Message-----
From: Cliff Drumeller [mailto:cliff@...]
Sent: Tuesday, March 30, 2004 12:03 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] 6.0 DB Tuning Opinion Needed

Todd

Hope you have plenty of space on your server. My 4.0 database grew 100
MB in a year. I upgraded to 6.0 last August and it is growing at the rate of
100 MB a month !! Converted at 2.4 GB - I'm now at 3.7 GB. Are others
experienceing the same growth ??

Cliff Drumeller
IT Manager
Mass Precision Sheetmetal
408 954 0200 x 217

-----Original Message-----
From: Todd Caughey [mailto:caugheyt@...]
Sent: Tuesday, March 30, 2004 7:16 AM
To: vantage@yahoogroups.com
Subject: [Vantage] 6.0 DB Tuning Opinion Needed

Since moving to 6.0 we are experiencing a LOT of slowness. Very long
startups (despite anti-virus exclusions) and Reports taking double the
normal time to run.

A while back Ben Nixon from Epicor had made some DB tweaks while here to
install Corvu / VBI. These are in the old Vantage database and probably not
in the new MfgSys database. For sure not in the new one because it was
installed with a limit of 32 users which caused some grief yesterday when
1/3 of the users could not log in. Being the same basic database and still
Progress 9.1d I should be able to copy all the settings from the old DB to
the new one - right? Then probably have to shut the DB down and restart for
them to take effect, also right?

Any other tips for making 6.0 not run so much slower than 5.20 was?

Thanks,
Todd Caughey
Harvey Vogel Mfg. Co.

[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/.
<http://groups.yahoo.com/group/vantage/files/.>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<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
<http://groups.yahoo.com/group/vantage/links>

Yahoo! Groups Sponsor

ADVERTISEMENT

<http://rd.yahoo.com/SIG=12csi89jg/M=267637.4673019.5833256.1261774/D=egroup
web/S=1705007183:HM/EXP=1080746230/A=1945637/R=0/SIG=11t30skn6/*http://www.n
etflix.com/Default?mqso=60178397&partid=4673019> click here

<http://us.adserver.yahoo.com/l?M=267637.4673019.5833256.1261774/D=egroupweb
/S=:HM/A=1945637/rand=538885446>

_____

Yahoo! Groups Links

* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
<http://groups.yahoo.com/group/vantage/>

* 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/> .

[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 · March 30, 2004, 12:14pm

I had 1 database and 4 companies in 4.0 with a 450 MB database. Moved to
5.1, split one company to a separate database. Now in 6.1, 1 database is
1.2GB and the other one is 1.6GB. Fortunately, 6.0 and up do not have the
2.0 GB limit.

Mario Aguirre
Lakin General

-----Original Message-----
From: Cliff Drumeller [mailto:cliff@...]
Sent: Tuesday, March 30, 2004 11:03 AM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] 6.0 DB Tuning Opinion Needed

Todd

Hope you have plenty of space on your server. My 4.0 database grew 100
MB in a year. I upgraded to 6.0 last August and it is growing at the rate of
100 MB a month !! Converted at 2.4 GB - I'm now at 3.7 GB. Are others
experienceing the same growth ??

Cliff Drumeller
IT Manager
Mass Precision Sheetmetal
408 954 0200 x 217

-----Original Message-----
From: Todd Caughey [mailto:caugheyt@...]
Sent: Tuesday, March 30, 2004 7:16 AM
To: vantage@yahoogroups.com
Subject: [Vantage] 6.0 DB Tuning Opinion Needed

Since moving to 6.0 we are experiencing a LOT of slowness. Very long
startups (despite anti-virus exclusions) and Reports taking double the
normal time to run.

A while back Ben Nixon from Epicor had made some DB tweaks while here to
install Corvu / VBI. These are in the old Vantage database and probably not
in the new MfgSys database. For sure not in the new one because it was
installed with a limit of 32 users which caused some grief yesterday when
1/3 of the users could not log in. Being the same basic database and still
Progress 9.1d I should be able to copy all the settings from the old DB to
the new one - right? Then probably have to shut the DB down and restart for
them to take effect, also right?

Any other tips for making 6.0 not run so much slower than 5.20 was?

Thanks,
Todd Caughey
Harvey Vogel Mfg. Co.

[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/.
<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
<http://groups.yahoo.com/group/vantage/messages>
<http://groups.yahoo.com/group/vantage/messages
<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
<http://groups.yahoo.com/group/vantage/links>
<http://groups.yahoo.com/group/vantage/links
<http://groups.yahoo.com/group/vantage/links> >

Yahoo! Groups Sponsor

ADVERTISEMENT

<http://rd.yahoo.com/SIG=12csi89jg/M=267637.4673019.5833256.1261774/D=egroup
<http://rd.yahoo.com/SIG=12csi89jg/M=267637.4673019.5833256.1261774/D=egroup

>

web/S=1705007183:HM/EXP=1080746230/A=1945637/R=0/SIG=11t30skn6/*http://www.n
<http://www.n>
etflix.com/Default?mqso=60178397&partid=4673019> click here

<http://us.adserver.yahoo.com/l?M=267637.4673019.5833256.1261774/D=egroupweb
<http://us.adserver.yahoo.com/l?M=267637.4673019.5833256.1261774/D=egroupweb

>

/S=:HM/A=1945637/rand=538885446>

_____

Yahoo! Groups Links

* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
<http://groups.yahoo.com/group/vantage/>
<http://groups.yahoo.com/group/vantage/
<http://groups.yahoo.com/group/vantage/> >

* 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/ <http://docs.yahoo.com/info/terms/> > .

[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/.
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<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
<http://groups.yahoo.com/group/vantage/links>

_____

Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
<http://groups.yahoo.com/group/vantage/>

* 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
<http://docs.yahoo.com/info/terms/> Service.

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

system · March 30, 2004, 12:24pm

DB grew in the upgrade from 840MB to 970mb so about 15%.
-Todd C.

-----Original Message-----
From: Cliff Drumeller [mailto:cliff@...]
Sent: Tuesday, March 30, 2004 11:03 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] 6.0 DB Tuning Opinion Needed

Todd

Hope you have plenty of space on your server. My 4.0 database grew 100
MB in a year. I upgraded to 6.0 last August and it is growing at the rate of
100 MB a month !! Converted at 2.4 GB - I'm now at 3.7 GB. Are others
experienceing the same growth ??

Cliff Drumeller
IT Manager
Mass Precision Sheetmetal
408 954 0200 x 217

-----Original Message-----
From: Todd Caughey [mailto:caugheyt@...]
Sent: Tuesday, March 30, 2004 7:16 AM
To: vantage@yahoogroups.com
Subject: [Vantage] 6.0 DB Tuning Opinion Needed

Since moving to 6.0 we are experiencing a LOT of slowness. Very long
startups (despite anti-virus exclusions) and Reports taking double the
normal time to run.

A while back Ben Nixon from Epicor had made some DB tweaks while here to
install Corvu / VBI. These are in the old Vantage database and probably not
in the new MfgSys database. For sure not in the new one because it was
installed with a limit of 32 users which caused some grief yesterday when
1/3 of the users could not log in. Being the same basic database and still
Progress 9.1d I should be able to copy all the settings from the old DB to
the new one - right? Then probably have to shut the DB down and restart for
them to take effect, also right?

Any other tips for making 6.0 not run so much slower than 5.20 was?

Thanks,
Todd Caughey
Harvey Vogel Mfg. Co.

[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/.
< http://groups.yahoo.com/group/vantage/files/.>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
< 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
< http://groups.yahoo.com/group/vantage/links>

Yahoo! Groups Sponsor

ADVERTISEMENT

< http://rd.yahoo.com/SIG=12csi89jg/M=267637.4673019.5833256.1261774/D=egroup
web/S=1705007183:HM/EXP=1080746230/A=1945637/R=0/SIG=11t30skn6/* http://www.n
etflix.com/Default?mqso=60178397&partid=4673019> click here

< http://us.adserver.yahoo.com/l?M=267637.4673019.5833256.1261774/D=egroupweb
/S=:HM/A=1945637/rand=538885446>

_____

Yahoo! Groups Links

* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
< http://groups.yahoo.com/group/vantage/>

* 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/> .

[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

* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/

* 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/> .

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

system · March 30, 2004, 1:21pm

Hi Cliff,

We are on 6.0 and the db grows at about 2 mb/day with intermittent jumps
of 10mb.

The monthly change is approx 60 mb.

Thanks,

John Mansfield

-----Original Message-----
From: Cliff Drumeller [mailto:cliff@...]
Sent: Tuesday, March 30, 2004 12:03 PM
To: 'vantage@yahoogroups.com'
Subject: **SPAM** RE: [Vantage] 6.0 DB Tuning Opinion Needed

Todd

Hope you have plenty of space on your server. My 4.0 database grew
100
MB in a year. I upgraded to 6.0 last August and it is growing at the
rate of
100 MB a month !! Converted at 2.4 GB - I'm now at 3.7 GB. Are others
experienceing the same growth ??

Cliff Drumeller
IT Manager
Mass Precision Sheetmetal
408 954 0200 x 217

-----Original Message-----
From: Todd Caughey [mailto:caugheyt@...]
Sent: Tuesday, March 30, 2004 7:16 AM
To: vantage@yahoogroups.com
Subject: [Vantage] 6.0 DB Tuning Opinion Needed

Since moving to 6.0 we are experiencing a LOT of slowness. Very long
startups (despite anti-virus exclusions) and Reports taking double the
normal time to run.

A while back Ben Nixon from Epicor had made some DB tweaks while here to
install Corvu / VBI. These are in the old Vantage database and probably
not
in the new MfgSys database. For sure not in the new one because it was
installed with a limit of 32 users which caused some grief yesterday
when
1/3 of the users could not log in. Being the same basic database and
still
Progress 9.1d I should be able to copy all the settings from the old DB
to
the new one - right? Then probably have to shut the DB down and restart
for
them to take effect, also right?

Any other tips for making 6.0 not run so much slower than 5.20 was?

Thanks,
Todd Caughey
Harvey Vogel Mfg. Co.

[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/.
<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
<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
<http://groups.yahoo.com/group/vantage/links>

Yahoo! Groups Sponsor

ADVERTISEMENT

<http://rd.yahoo.com/SIG=12csi89jg/M=267637.4673019.5833256.1261774/D=eg
roup
web/S=1705007183:HM/EXP=1080746230/A=1945637/R=0/SIG=11t30skn6/*http://w
ww.n
etflix.com/Default?mqso=60178397&partid=4673019> click here

<http://us.adserver.yahoo.com/l?M=267637.4673019.5833256.1261774/D=egrou
pweb
/S=:HM/A=1945637/rand=538885446>

_____

Yahoo! Groups Links

* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
<http://groups.yahoo.com/group/vantage/>

* 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/> .

[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/.
<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

* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/

* 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
<http://docs.yahoo.com/info/terms/> Service.

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

**SPAM** RE: 6.0 DB Tuning Opinion Needed

SPAM RE: 6.0 DB Tuning Opinion Needed