Jim Maul wrote:
I dont use mysql with SA, but you should be able to use truncate instead
of delete. It may very well be faster with all those rows.
From MySQL 4.x manual:
"For InnoDB, TRUNCATE TABLE is mapped to DELETE, so there is no
difference."
We're using InnoDB rather than MyISAM, so there's apparently no big
difference. It doesn't free disk space, though, so an OPTIMIZE TABLE
should be issued.
Still no input from developers/maintainers.... can I empty the
bayes_seen table without breaking DB consistency?
Thanks,
Paolo
