Database Design Issue
| From: | Jason Lange | Date: | Thu, 14 Aug 2003 19:31:31 +0000 |
| Subject: | Database Design Issue | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-29896@lists.php.net to get a copy of this message | ||
Hello Everyone,
Here's my question. I'm creating a website for a weekly radio show. One of the items I would like to store in the database is the list of songs played in each show (there's normally between 20-25 songs per show), and the songs will be displayed by show. Should I put all of the songs in a single table with a field denoting what show they're from, or should I create a separate table for each weeks show and just request that entire table? I'm looking at this from both a long-term performance and *maintenance* issue.
TIA,
Jason