There is no need to run it every 3 days. Run it every hour, deleting rows older than 'now' - 3. This should delete approx 8000 rows each hour (given an even spread of your 4.3M sessions over 3 days).
Regards Vince Vince Duggan I.T. Architect Virgin Active South Africa (Pty) Ltd Tel (+27) (0)21 684 3525 Fax (+27) (0)21 684 3225 Cell (+27) (0)82 747 6127 Email: [email protected] Live happily ever active From: "nathanelrick" <[email protected]> To: [email protected] Date: 2012/02/29 08:34 AM Subject: [firebird-support] Re: Update take hours to delete records :( Sent by: [email protected] > How many records approx.? ok, the select count(*) return ... 4 300 000 record (for last 3 days) -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. [Non-text portions of this message have been removed]
