The current approach is better. Having one row with 81 columns will be
harder to deal with in terms of writing code to display it. The size of the
table will be roughly the same either way -- either you have a few very big
rows, or many small rows, but that shouldn't be a huge issue if you index
Tom,
I would keep your current fiveish-column design with the 20 inserts. It
will save you a LOT of headache in the future when you want to search for
things like particular artists or titles or to compute a sort of "most
popular top twenty" based on everyone else's rankings.
SELECT artist, titl
Hello Tom,
Wednesday, June 30, 2004, 1:26:52 PM, you wrote:
TC> My question is this:
TC> Would I be better keeping this format and inserting multiple rows on each
TC> submit, or to have one row for all 81 variables ($name, 20 x Position, 20 x
TC> Artists, 20 x Titles, 20 x Labels.)
TC> I know tha
