MySQL Performance Example Was: Seriously, WTF?
paulm at paulm.com
Sat May 10 00:58:43 BST 2008
On Fri, May 9, 2008 at 4:21 PM, Abigail <abigail at abigail.be> wrote:
> 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.
Do not feed the troll.
Structured. Query. Language.
More information about the london.pm