> Would I be better keeping this format and inserting multiple rows on each > submit, or to have one row for all 81 variables ($name, 20 x > Position, 20 x > Artists, 20 x Titles, 20 x Labels.) > I know that the latter will be easier to query.
Are you sure? Why? > Also, without maintenance, the size of the table for the current > method will > get extremely large. Will that affect server performance? There is no difference: the size is the same for the 2 tables (actually the current one has one tinyint more which is also part of an index, but that is almost nothing). The current method (IMHO) is much better. What if you want to perform a search for artist in the other case? What if you want to change the design to top 10 instead of top 20? And so on... -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
