MySQL Performance Example Was: Seriously, WTF?

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

On Fri, May 9, 2008 at 4:21 PM, Abigail <abigail at> 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




More information about the mailing list