Is it a distributed file? If so, I'd write a basic program to loop through each
of the parts sequentially (i.e., a basic select), read each record, evaluate &
archive or not, readnext. Then, I'd run a few iterations to run in parallel.
You're right about the index overhead. If you had indices, I'd say turn them
off for this process (actually, I'd select for the date criteria, save the list
for use & then do a get-list instead of basic select, then turn off indexing),
then re-index. Since you don't have them yet, creating it first would give you
a lot of overhead.
> From: [email protected]
> To: [email protected]
> Date: Wed, 16 Feb 2011 10:07:44 -0500
> Subject: [U2] Purging and Indexing
>
> Good Morning,
>
> Looking for opinions and experiences here. We are trying to do some system
> cleanups. We found that our PO file has over 10 million records dating back
> some 7 years. We've decided that 2 years of PO history is plenty to keep on
> file.
>
> Currently there are no indices on this file. Our question is would it be
> quicker to do a select and delete of the older records before building an
> index on invoice date or would it be quicker to build the index first to use
> in the select for the purge? This index has been identified as being needed
> for some reporting.
>
> My thinking is that while the select for the purge may go quicker, if the
> index is in place prior to the purge then the delete process not only has to
> delete the selected records it also has to update the index on the fly.
>
> TIA,
> Gordon
>
> Gordon J Glorfield | Software Application Developer | Vertis Communications
> 250 W. Pratt Street, Suite 1800 | Baltimore, MD, 21201
> T 410-361-8664 | M 443-280-7093
> [email protected] | http://www.vertisinc.com
>
> Vertis Communications is a results-driven marketing communications company
> that delivers inventive advertising, direct marketing and interactive
> solutions to prominent brands across North America. Our deep industry
> knowledge and extensive range of offerings-including integrated data
> solutions, digital program management systems, creative services, world-class
> print and mail production, logistics, out-of-home and business process
> outsourcing-are used to deliver superior program performance that drives
> bottom line results for our clients. With 100 strategically positioned
> locations and more than 5,000 dedicated professionals, we deliver impeccable
> quality and fast turn-around to any market.
>
> _______________________________________________
> U2-Users mailing list
> [email protected]
> http://listserver.u2ug.org/mailman/listinfo/u2-users
_______________________________________________
U2-Users mailing list
[email protected]
http://listserver.u2ug.org/mailman/listinfo/u2-users
