MySQL Performance Example Was: Seriously, WTF?

[Abigail]

On Fri, May 09, 2008 at 04:16:16PM +0100, Robbie Bow wrote:
> On Fri, May 9, 2008 at 3:30 PM, Abigail <abigail at abigail.be> wrote:
> > On Thu, May 08, 2008 at 08:45:24PM +0100, Robbie Bow wrote:
> >>
> >> MyISAM is a good choice for non-transactional tasks.
> >
> >
> > Yeah, but if you can't be bothered with transactions, why go into the
> > trouble of using a database in the first place?
> >
> 
> 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.


Abigail
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: not available
Url : http://london.pm.org/pipermail/london.pm/attachments/20080509/85b987f6/attachment.pgp