[mythtv] [mythtv-commits] Ticket #3326: Implement multiple recordings per transport
stuart at tase.co.uk
Fri Oct 5 15:24:29 UTC 2007
On Friday 05 October 2007 15:56:58 MythTV wrote:
> I've attached a patch for the range map optimization for scheduling in
> 3326-multimap-sched-v1.patch. I only yields a 3% speedup after applying
> the previous optimizations to speed up IsSameProgram checking. It used to
> yield a 20% speedup. I don't think 3% is worth it so I'm not applying
I'd say that any speedup, no matter how small is worthwhile when you consider
that the speed of a reschedule, affects the speed at which we update the UI
to reflect scheduling changes. If I hit 'R' to toggle a recording in the EPG
it's not until the reschedule is complete that I'll know if that showing will
be recorded or whether it will conflict. This can be frustratingly slow even
with the scheduler in trunk.
The 27% improvement is impressive though and looking at the patch, you are
probably right in saying that a 3% improvement doesn't make it worthwhile.
This might be the time to start thinking about the change which could bring
significant speed improvements to scheduling - subqueries. That means
dropping support for MySQL 3.3 and moving to MySQL 4.1.
More information about the mythtv-dev