You run that query in addition? Or as part of the delete query?
Regards,
Bill
I run that query in addition.
Regards,
mick
Bill Shupp wrote:
Thanks for the tip, I'll put it in a shell script, and make a note of it
on the site.
This is done. See http://shupp.org/ for details.
Regards,
Bill Shupp
I would suggest to optimize the table. That is why I added OPTIMIZE
TABLE relaytofrom.
Regards,
Mick
Mick wrote:
Bill Shupp wrote:
Thanks for the tip, I'll put it in a shell script, and make a note of it
on the site.
This is done. See http://shupp.org/ for details.
Regards,
Bill Shupp
I would suggest to optimize the table. That is why I added OPTIMIZE
TABLE relaytofrom.
You run
Bill Shupp wrote:
Mick wrote:
Bill Shupp wrote:
Thanks for the tip, I'll put it in a shell script, and make a note
of it
on the site.
This is done. See http://shupp.org/ for details.
Regards,
Bill Shupp
I would suggest to optimize the table. That is why I added OPTIMIZE
TABLE
Rick Macdougall wrote:
Here's some code that should go somewhere. I call it deletegreylist.sql
on my system and run it every hour.
delete FROM `relaytofrom` WHERE origin_type = AUTO and (
unix_timestamp( )- unix_timestamp( record_expires ) 0 )
If you don't do that, of course, your
Bill Shupp wrote:
Thanks for the tip, I'll put it in a shell script, and make a note of it
on the site.
This is done. See http://shupp.org/ for details.
Regards,
Bill Shupp