Maintaining a Tuning Space

Each loader DLL should remove out-of-date data from its tuning space. Removing out-of-date data keeps the Guide database from growing too large. Such data cleanup consists of:

• Deletion of records from the Channel, Episode, Station and Theme tables that are no longer being referenced in other tables.
• Deletion of expired records from the Time Slot table. Expired records are records whose end time is more than one day in the past.
• Deletion of duplicate time slots from the Time Slot table. Duplicate time slots are identical or overlapping time slots specified for the same show. For example, if a show is listed as being broadcast on a particular channel from 10 A.M. to 12 P.M., and the loader adds a new time slot for that show from 10:30 to 11:30 A.M. on the same channel, one of the time slot entries should be removed.

These actions can be performed by running the cleanup queries defined in the Guide database. For more information on these queries, see Guide Database Query Reference.