MySQL Performance Example Was: Seriously, WTF?

[Paul Makepeace]

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.

P

>
>
>  Abigail
>