[mythtv] Re: PATCH: mythfilldatabase v1.43 -- arbitrary end times

[Isaac Richards]

On Monday 03 March 2003 01:40 pm, Andy Davidoff wrote:
> What MySQL is optimized for is indexing large tables so that queries
> that retrieve a few specific records based on indexed values are fast.
>
> If you want to search for programs with no endtimes, create an index
> on the endtime column:
>
> 	alter table program add index (endtime);

It's not really necessary to hit the DB to find out what programs don't have 
endtimes, though -- the filldatabase process just inserted stuff into the 
database, so all that information is already present in ram.

Isaac