Hi Junior, We have performed "Archiving" for over 800,000 records with no impact on memory. Archiving process runs seperately under usernamer AR_ARCHIVOR. You can see that in filter logs.
I found out 2 things which you might be interested in 1. Archiving process runs at server, so the time you set will be the time of the server. However, for Qualification it looks at client time. e.g. If you set to archive pre-2005 records, then you will need to set qualification as 'Create Date'<"1/1/2005 9:59:59 PM", if you are located in California and your server is in Texas. Our process was extremely fast as we had 46Gb of memory. Thanks Chintan. --- On Mon, 9/8/08, Darrell Reading <[EMAIL PROTECTED]> wrote: From: Darrell Reading <[EMAIL PROTECTED]> Subject: Re: Archiving Question To: [email protected] Date: Monday, September 8, 2008, 10:34 AM Junior, Before setting up the archiving process, I would create the archive form and move over the majority of those records by hand. Just a thought. Darrell Reading Systems Engineer Phone 479.204.5739 [EMAIL PROTECTED] Wal-Mart Stores, Inc. 805 Moberly Lane, MS-0560-68 Bentonville, AR 72716 Save Money. Live Better -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Opela, Gary L CTR USAF AFMC 72 CS/SCBAH Sent: Monday, September 08, 2008 12:31 To: [email protected] Subject: Archiving Question I'm setting up archiving for a form for the first time. There are 452,542 records that will be archived that match my specific criteria. Is there any way to control how many records at a time the archiving process will archive? Will it only archive up until the server limit for queries? I'm running ars 6.3 on windows 2k3 with mssql 2k5 database. Thanks, Gary Opela, Jr. ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" ----------------------------------------- ********************************************************************** This email and any files transmitted with it are confidential and intended solely for the individual or entity to whom they are addressed. If you have received this email in error destroy it immediately. ********************************************************************** Wal-Mart Confidential ********************************************************************** _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
