[mythtv-users] slow mythweb?
ron at ronfrazier.net
Tue Apr 22 15:52:51 UTC 2008
> This would fail only for programs longer than 6 hours? (no scheduling
> until program is over?)
No it wouldn't. You are asking it to only record programs that START
in the next 6 hours. You don't say anything about when they end (I
purposely left that out).
> From my observations: every time a show ends (or starts) there is a
> moment of checking the schedules.
Thats what I thought too, but I just wanted to mention it to be
thorough (in case I was mistaken).
> Normally I have about 5 days of info for the three channels.
> This would mean that every time it happens about 5 times 24 hours of
> program data is (re)scheduled.
> With the WHERE condition as you describe it, this would be reduced by a
> factor of 20 (5 times 4). This should be noticable, right?
Yes, if that's where your bottleneck is, it will help tremendously.
Because of the way conflict detection needs to be done, the scheduler
scales worse than linearly.
More information about the mythtv-users