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