MySQL Performance Example Was: Seriously, WTF?

Robbie Bow robbiebow at gmail.com
Fri May 9 20:41:23 BST 2008


On Fri, May 9, 2008 at 4:21 PM, Abigail <abigail at abigail.be> wrote:
>>
>> Go on then, tell me the easier, better way to hold these 100 million
>> records and perform the kind of searches in question. Or even the
>> transactions one should be "bothered" with in this scenario.
>
> Those 100 million records have to come from somewhere, did the rows
> come with your version of MySQL? All MySQLs I installed just came with
> empty tables.
>
> I agree, there are cases where you don't need a transaction if you are
> searching. But I don't want to go from 0 rows to even 1 row without
> transactions, let alone to 100 million.
>

What do we gain from transactions when the only task is to insert data
e.g. we go from

insert

to:

begin
insert
commit


More information about the london.pm mailing list