Re: Replace delayed locks table

[matt ryan]

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