no. of affected rows returned by MySQL
(other processing, perhaps a sleep)
} while (row_count >= delete_row_max;
-Original Message-
From: Viraj Alankar [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 02, 2002 9:57 AM
To: [EMAIL PROTECTED]
Subject: help optimizing log table deletes
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 optim
Hello,
We have an 'outgoing' table being used to store email header information
defined as follows:
CREATE TABLE outgoing (
rpath varchar(80) default NULL,
auth varchar(80) NOT NULL default '',
ip varchar(80) default NULL,
hfrom varchar(80) default NULL,
hto varchar(80) default NULL,
