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: vince.duggan@...

Live happily ever active





From:
"nathanelrick" <nathanelrick@...>
To:
firebird-support@yahoogroups.com
Date:
2012/02/29 08:34 AM
Subject:
[firebird-support] Re: Update take hours to delete records :(
Sent by:
firebird-support@yahoogroups.com

> 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]