James what were the scatter factors? I was told at a Progress DBA training that with scatter factors of 2 or more on heavily used tables you should consider a dump and load for performance reasons. It would also be a good opportunity to change your blocksize if that is needed.
Bart Sgroi
-----Original Message-----
From: James Piper [mailto:admin@...]
Sent: Friday, February 13, 2004 10:20 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Deframentation of database
Question that was brought up yesterday during a tech support call . . . . .
. .
I was told it's time to do a defragmentation of our database due to the
scatter factor on several of our tables and the size of our current
database.
(2 gigs)
I was told this would double our performance of our database.
I have been working here two years and no one here has ever heard of having
to do this.
(We go all the way back to Vantage 5.0)
I am not disputing that it is a good idea.
What I am looking for is your experience of if you have done it etc?
Epicor supplied me with a kit to do a dump of my database to a file then
reloading a that file into a new database.
They indicated this needs to be done about once a year
Again this is the first I have ever heard of it and I am curious if anyone
out there has done this or has a plan to do this on an annual basis etc.
Thanks
J.P. Piper - Systems Administrator
MECO, Inc
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
<http://rd.yahoo.com/SIG=12cghb1es/M=274551.4550177.5718621.1261774/D=egroupweb/S=1705007183:HM/EXP=1076771990/A=1994230/R=2/*http://ad.doubleclick.net/jump/N3349.yahoo1/B1282054.22;abr=!ie4;abr=!ie5;sz=300x250;code=18634;dcopt=rcl;ord=1076685590769060?> Click HereClick Here
<http://us.adserver.yahoo.com/l?M=274551.4550177.5718621.1261774/D=egroupweb/S=:HM/A=1994230/rand=870293021>
_____
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]
Bart Sgroi
-----Original Message-----
From: James Piper [mailto:admin@...]
Sent: Friday, February 13, 2004 10:20 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Deframentation of database
Question that was brought up yesterday during a tech support call . . . . .
. .
I was told it's time to do a defragmentation of our database due to the
scatter factor on several of our tables and the size of our current
database.
(2 gigs)
I was told this would double our performance of our database.
I have been working here two years and no one here has ever heard of having
to do this.
(We go all the way back to Vantage 5.0)
I am not disputing that it is a good idea.
What I am looking for is your experience of if you have done it etc?
Epicor supplied me with a kit to do a dump of my database to a file then
reloading a that file into a new database.
They indicated this needs to be done about once a year
Again this is the first I have ever heard of it and I am curious if anyone
out there has done this or has a plan to do this on an annual basis etc.
Thanks
J.P. Piper - Systems Administrator
MECO, Inc
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
<http://rd.yahoo.com/SIG=12cghb1es/M=274551.4550177.5718621.1261774/D=egroupweb/S=1705007183:HM/EXP=1076771990/A=1994230/R=2/*http://ad.doubleclick.net/jump/N3349.yahoo1/B1282054.22;abr=!ie4;abr=!ie5;sz=300x250;code=18634;dcopt=rcl;ord=1076685590769060?> Click HereClick Here
<http://us.adserver.yahoo.com/l?M=274551.4550177.5718621.1261774/D=egroupweb/S=:HM/A=1994230/rand=870293021>
_____
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]