You are welcome.

It would depend on if they were searching for episode information . No. If they were searching for tv shows for a certain year. Yes.

Updating and inserting. Yes.

Until you get gigabyte sized databases speed will be quick if you are on a well maintained server.

All in all usually tables get corrupted and if you don't have more data in tables than needed you have less hassle getting your site back up in a pure maintenace standpoint.
Lock Down Reviewed by Lock Down on . How Should I Organize My SQL Tables? I'm sorry, I'm sure this is a complete n00b question, but I've been working with collecting data, and I'm starting to get to the point where I'd like to start populating a database, but I can't figure out what system will work best. Final Project: Dealing with TV Shows and information from the database... TV Show - Seasons - Episodes in season (for episode in each season) - Information about episode in season Rating: 5