I am out of the office until 16/07/2012.
In my absence kindly contact Amanda Rust for any SMS requests, and any of
Amanda, Adrienne Charles or Andre Mostert for other urgent work.
Note: This is an automated response to your message "[firebird-support]
alternative approach" sent on 6/19/12 14:3
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) Lt
we are waiting for a transaction to
finish (because you are using isc_tcb_wait), we can simply carry on and
any locked rows will be deleted next time we run.
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
C
I am out of the office until 12/01/2012.
In my absence kindly contact Andre Mostert for any urgent assistance.
Note: This is an automated response to your message "[firebird-support]
Replication with embedded databases." sent on 1/9/12 10:56:32.
This is the only notification you will receive