Data Purge Blank Title 100721

system · May 23, 2011, 3:05pm

I would do a simple dump of your DB to see what tables hold the most data.
There are some tables that can contain a significant amount of data, and not
mean a lot, but they will eventually get filled again anyway.

Also, with the purge function, I am not sure what dates you used, but you
may not have purged as much as you intended to.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Toby Boogerd
Sent: Monday, May 23, 2011 12:26 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Data Purge

Did a data purge of our test database and choose to purge all options and
only kept the date range that vantage forces us to keep. The size of the
database was 24GB, after purging it only went down 2GB. Doesn't make much
sense. Do we need to run some other commands or a dump and reload? Looking
for some answer on why we would still have such a big database.

Toby Boogerd | Information Systems
[cid:838450413@03092008-1A8B] 712.324.4854 | [cid:838450413@03092008-1A92]
tboogerd@...<mailto:tboogerd@...>
[Email]
Worldwide Headquarters | 1530 Western Avenue, Sheldon IA 51201 | USA

[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/linksYahoo! Groups Links

system · May 23, 2011, 12:26pm

Did a data purge of our test database and choose to purge all options and only kept the date range that vantage forces us to keep. The size of the database was 24GB, after purging it only went down 2GB. Doesn't make much sense. Do we need to run some other commands or a dump and reload? Looking for some answer on why we would still have such a big database.

Toby Boogerd | Information Systems
[cid:838450413@03092008-1A8B] 712.324.4854 | [cid:838450413@03092008-1A92] tboogerd@...<mailto:tboogerd@...>
[Email]
Worldwide Headquarters | 1530 Western Avenue, Sheldon IA 51201 | USA

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

system · May 23, 2011, 1:25pm

FWIW, I'm not an expert on the purge process. But I don't believe it
actually purges 'everything'. I think it just removes some of the finer
details from the GL transactions and stuff like that. I don't think it
removes old orders and POs.

On Mon, May 23, 2011 at 12:25 PM, Toby Boogerd <tboogerd@...>wrote:

>
>
> Did a data purge of our test database and choose to purge all options and
> only kept the date range that vantage forces us to keep. The size of the
> database was 24GB, after purging it only went down 2GB. Doesn't make much
> sense. Do we need to run some other commands or a dump and reload? Looking
> for some answer on why we would still have such a big database.
>
> Toby Boogerd | Information Systems
> [cid:838450413@03092008-1A8B] 712.324.4854 | [cid:838450413@03092008-1A92]
> tboogerd@...<mailto:tboogerd@...>
> [Email]
> Worldwide Headquarters | 1530 Western Avenue, Sheldon IA 51201 | USA
>
> [Non-text portions of this message have been removed]
>
>
>

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