[mythtv] [mythtv-commits] Ticket #3326: Implement multiple recordings per transport

[Stuart Morgan]

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
>  this.

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.
-- 
Stuart Morgan