[mythtv] patch: progfind speedup

[John Danner]

Thanks for the patch. The code as I originally had it doesn't even use the 
channel information at that point. 

So i've updated CVS to use this:

"SELECT DISTINCT title FROM program WHERE title LIKE '%1%' AND starttime > %2 
ORDER BY title;"

Thanks Again,
John


---------- Original Message -----------
From: Andy Davidoff <dert at pobox.com>
To: mythtv-dev at snowman.net
Sent: Sun, 2 Mar 2003 16:36:05 -0500
Subject: [mythtv] patch: progfind speedup

> This trivial patch speeds up the program finder by
> several orders of magnitude via dramatic reduction
> of the search space.  Apply the additional index to
> further improve search times.
------- End of Original Message -------