22 quatloos for you!
Yeah, in retrospect, I imagine Dan's on the money: the seek
time is where the money's at. Thanks for the feedback, all!
____________________________________________________________
Eamon Daly
----- Original Message -----
From: "Frank Bax" <fbax@stripped>
To: <mysql@stripped>
Sent: Wednesday, June 23, 2004 9:55 PM
Subject: Re: Fetching 12 columns or 1 TEXT field?
> At 03:29 PM 6/23/04, Eamon Daly wrote:
> >Which do you folks think is faster: randomly accessing a
> >table with a primary key and a dozen CHAR columns or a table
> >with a primary key and a single merged TEXT column? The data
> >in the 11 extra columns will always be fetched as a single
> >request.
>
> Both the same - with extremely minor variance.
>
> >I rolled my own benchmarking program and 10,000 runs each
> >came out just about equal, which surprised me a little.
>
> Wow. I'm right - what's the prize?
