matt ryan wrote:
Replace does a delete followed by an insert.
Ahh, I'm testing innodb on our tables with this problem
I've switched to innodb but performance isnt very good
while the insert runs, here's what I get for performance
select count(*) from rondon; 1 row in .13 sec
select count(*) from rondon; 1 row in 21.88 sec
select count(*) from rondon; 1 row in 42.47 sec
select count(*) from rondon; 1 row in 1 min 47.69 sec
not sure why the first was so fast, the rest SUCK
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
