topic Archiving Z table in Application Development and Automation Discussions

Archiving Z table

Former Member — Fri, 17 Oct 2008 20:55:56 GMT

Hi all,

In my ztable I have 10 million records, when user runs the report it takes too much time, for that I have already created one archive table same as my ztable, now I want to insert all ztable data(record) to my zarchive table, I want to keep only one month data in original ztable for that I want to create one archive program to insert all record in my zarhive table and keep 30 days data like: system date to older then 30 days.

Can you give me some idea how to create program? Give me some logic.

Thanks

zeni

Edited by: Julius Bussche on Oct 18, 2008 1:00 AM

Edited by: Julius Bussche on Oct 18, 2008 1:35 AM

Re: Archiving Z table

Former Member — Fri, 17 Oct 2008 21:14:06 GMT

1) Please pick a more suitable title for your question.

B) Rather than trying to come up with some sort of user archiving process, it might be simpler to do some performance tuning on the programs that access this table.

Rob

Re: Archiving Z table

Former Member — Fri, 17 Oct 2008 23:30:33 GMT

Okay, lets help him / her out => Archive Z table it is...

Edited by: Julius Bussche on Oct 18, 2008 1:34 AM