S. Fischer [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 20, 2003 1:43 PM
To: 'Jack Coxen'; 'MySQL List (E-mail)'
Subject: RE: Delete questions and speed/safety issues
It's quite possible you're using the wrong tool for the job. Since this
is a write-intensive environment, you may get better
It's quite possible you're using the wrong tool for the job. Since this
is a write-intensive environment, you may get better performance by
using another database such as PostgreSQL or Oracle. Alternatively,
consider the option of re-architecting the application to distribute the
writes across
Jack Coxen wrote:
I had originally planned to use syntax similar to:
DELETE * FROM table_name WHERE `dtime` [90 days ago]
delete * from table_name where to_days(now())-to_days(dtime) 90
After the DELETE runs, I plan on running MYISAMCHK on the affected table.
Then I'll repeat both steps for
Coxen; 'MySQL List (E-mail)'
Subject: RE: Delete questions and speed/safety issues
Switching to another database isn't really an option. I didn't write
the package and I'm not good enough to port it to another database or to
rewrite it for a multiple machine architecture.
Probably the only non