matt ryan wrote:
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
Well, this a particularly bad command to use to test innodb performance.
With MyISAM table, the record count is immediately available.
With Innodb, the server has to actually count records. Different users will get
different counts depending on the transaction isolation mode and number of uncommitted records.
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
