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>
