Hi Jose, Thanks for your prompt reply.
I too thought of same solution, but we don't want to delete the original table. Any other solution is greatly appreciated. Thanks & Regards, Mallik. -----Original Message----- From: José Pedro Silva Pinto [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 14, 2004 5:02 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: Deleting the records from a table Hi, It songs a funny solutions but... Create a TEMP table and insert latest 5 days data After delete the table and rename temp table José Pinto -----Original Message----- From: Mallik [mailto:[EMAIL PROTECTED] Sent: terça-feira, 14 de Dezembro de 2004 11:31 To: [EMAIL PROTECTED] Subject: Deleting the records from a table Hi Friends, I need a help from you in implementation of purging functionality. I am given a hash of table(s), each having millions of records. i need to delete those records keeping latest 5 days records in the tables. I know the delete query like: delete from $tableName where adddtm < today ? $numDays ; where $numDays is the variable having number of days latest data to be retained. if i give the direct query like above it takes a lot of time to delete records from that set of tables. Do you have any idea to implement this purging that can be done in time for any number of tables containing millions of records in a loop. i need to implement this in perl, with DBI-informix interface. Thanks in advance, Mallik. -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] <http://learn.perl.org/> <http://learn.perl.org/first-response> -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] <http://learn.perl.org/> <http://learn.perl.org/first-response>
