On 2/16/2011 10:07 AM, Glorfield, Gordon wrote:
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
I would do the cleanup before applying the index. If you use a unibasic
SELECT instead of a TCL select, you can just run through every record
once checking the date, deleting the ones you do not want.
On another note, I also used Keith Johnson's MAKEXML
http://www.pickwiki.com/cgi-bin/wiki.pl?MakeXml to archive off some 3
years of Bill of Lading data. I figure the archive would then be future
proof and was too big for a reasonable spreadsheet.
2 TCL statements and 10 minutes and my archive was done.
_______________________________________________
U2-Users mailing list
[email protected]
http://listserver.u2ug.org/mailman/listinfo/u2-users
