You can use the LIMIT clause to break up a long DELETE into a series of shorter ones,
executed in a loop.
So, in pseudo-code:
Set delete_row_max = 1000 (or another appropriate value)
do
{
DELETE FROM outgoing
WHERE timestamp < last_time
LIMIT delete_row_max;
row_count = no. of
perhaps you can run this more frequently, say once an hour if
it does not interfere with your application logic.
> -Original Message-
> From: Viraj Alankar [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, April 02, 2002 4:57 PM
> To: [EMAIL PROTECTED]
> Subject: help optimizing log table delet
