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

Isaac Richards ijr at po.cwru.edu
Mon Mar 3 13:52:50 EST 2003

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.


More information about the mythtv-dev mailing list