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.
>
>
>
