[mythtv-users] Increase in recorded file sizes
Mike Holden
mythtv at mikeholden.org
Wed Apr 22 18:54:01 UTC 2009
Mike Perkins wrote:
> I'm not able to try out your SQL at the moment, but it looks interesting.
Interesting indeed!
A slight variation on that, and the below is the list of programs from my
BBC1 and BBC2 Freeview going back over the last 9 months (must get round
to watching some of those older ones!).
With only a few aberrant data points, the typical size/time ratio looks to
increase from about 2.4 to 3.1 for BBC2 around 6th-7th April, but a skip
the other way of about the same amount for BBC1 :-). Not a lot of data
points to prove it, but certainly looks possible that BBC2 improved while
BBC1 got lower.
This has been a stable system for quite a while, using multirec (3 per
tuner) x 4 = 12 virtual tuners plus one pvr150 for recording from a cable
settop box. Myth 0.21-fixes from atrpms on fedora 9.
select title, starttime, round(filesize/1024/1024) as mbytes,
round((filesize/1024/1024)/(TIME_TO_SEC(TIMEDIFF(progend,progstart))/60/60))
as rate from recorded where chanid=4002 order by 2;
BBC1 (chanid=4001)
+-----------------------------------+---------------------+--------+------+
| title | starttime | mbytes | rate |
+-----------------------------------+---------------------+--------+------+
| Little Dorrit | 2008-10-26 19:59:00 | 3001 | 3001 |
| Little Dorrit | 2008-10-30 20:29:00 | 1695 | 3389 |
| Little Dorrit | 2008-11-05 19:59:00 | 1717 | 3435 |
| Little Dorrit | 2008-11-06 19:58:00 | 1719 | 3437 |
| Little Dorrit | 2008-11-12 19:58:00 | 1739 | 3479 |
| Little Dorrit | 2008-11-13 19:58:00 | 1739 | 3478 |
| Little Dorrit | 2008-11-19 19:58:00 | 1628 | 3255 |
| Little Dorrit | 2008-11-20 19:59:00 | 1596 | 3192 |
| Little Dorrit | 2008-11-26 19:58:00 | 1739 | 3477 |
| Little Dorrit | 2008-11-27 19:58:00 | 1719 | 3439 |
| Little Dorrit | 2008-12-03 19:58:00 | 1915 | 3830 |
| Little Dorrit | 2008-12-07 18:13:00 | 3045 | 3045 |
| Little Dorrit | 2008-12-09 02:44:00 | 1694 | 3389 |
| Little Dorrit | 2008-12-10 19:58:00 | 1739 | 3479 |
| Little Dorrit | 2008-12-11 19:58:00 | 3043 | 3043 |
| Shark Tale | 2008-12-25 15:08:00 | 3917 | 2938 |
| Deep Impact | 2008-12-30 22:58:00 | 5219 | 2847 |
| Shrek 2 | 2009-01-01 17:13:00 | 4135 | 2919 |
| The Diary of Anne Frank | 2009-01-05 18:58:00 | 1740 | 3480 |
| The Secret Diary of the Holocaust | 2009-01-05 22:33:00 | 2175 | 3262 |
| The Diary of Anne Frank | 2009-01-06 18:58:00 | 1737 | 3475 |
| The Diary of Anne Frank | 2009-01-07 18:58:00 | 1738 | 3476 |
| The Diary of Anne Frank | 2009-01-08 18:58:00 | 1739 | 3477 |
| The Diary of Anne Frank | 2009-01-09 18:58:00 | 1737 | 3475 |
| Moses Jones | 2009-02-09 02:37:00 | 3307 | 3307 |
| The Narnia Code | 2009-04-16 22:33:00 | 2368 | 2368 |
| Ashes to Ashes | 2009-04-20 20:58:00 | 2467 | 2467 |
+-----------------------------------+---------------------+--------+------+
BBC2 (chanid=4002)
+----------------------------------+---------------------+--------+------+
| title | starttime | mbytes | rate |
+----------------------------------+---------------------+--------+------+
| Charlie Brown | 2008-07-31 11:36:00 | 3610 | 2707 |
| Charlie Brown | 2008-08-07 11:36:00 | 3409 | 2557 |
| Later... with Jools Holland | 2008-09-26 23:34:00 | 2777 | 2563 |
| Later Live... with Jools Holland | 2008-09-30 21:58:00 | 1541 | 3082 |
| Later... with Jools Holland | 2008-10-03 23:39:00 | 2698 | 2698 |
| Later... with Jools Holland | 2008-11-07 23:33:00 | 2758 | 2545 |
| Later... with Jools Holland | 2008-11-14 23:38:00 | 2682 | 2682 |
| The Nightmare before Christmas | 2008-12-20 11:48:00 | 2466 | 2114 |
| Wainwright's Walks | 2008-12-22 09:28:00 | 1412 | 2824 |
| Wainwright's Walks | 2008-12-23 09:28:00 | 1407 | 2813 |
| Wainwright's Walks | 2008-12-24 09:28:00 | 1409 | 2818 |
| Calendar Girls | 2008-12-24 20:28:00 | 3709 | 2120 |
| Wainwright's Walks | 2008-12-26 09:28:00 | 1316 | 2633 |
| Wainwright's Walks | 2008-12-29 09:28:00 | 1428 | 2856 |
| Wainwright's Walks | 2008-12-30 09:28:00 | 1392 | 2784 |
| Wainwright's Walks | 2008-12-31 09:28:00 | 1390 | 2779 |
| Wainwright's Walks | 2009-01-01 09:28:00 | 1381 | 2762 |
| Wainwright's Walks | 2009-01-02 09:28:00 | 1371 | 2742 |
| Lock Up Your Daughters | 2009-01-03 22:58:00 | 2204 | 2645 |
| Moses Jones | 2009-02-02 20:57:00 | 2419 | 2419 |
| Beautiful Creatures | 2009-02-08 00:18:00 | 3116 | 2337 |
| Moses Jones | 2009-02-09 20:57:00 | 2382 | 2382 |
| Moses Jones | 2009-02-16 20:57:00 | 2373 | 2373 |
| Railway Walks | 2009-03-09 19:58:00 | 1206 | 2412 |
| Railway Walks | 2009-03-16 19:58:00 | 1192 | 2385 |
| Railway Walks | 2009-03-23 19:58:00 | 1379 | 2759 |
| Five Minutes Of Heaven | 2009-04-05 20:59:00 | 3192 | 2253 |
| Later Live... with Jools Holland | 2009-04-07 21:58:00 | 1563 | 3127 |
| Later Live... with Jools Holland | 2009-04-14 21:58:00 | 1544 | 3087 |
| Later with Jools Holland | 2009-04-17 23:33:00 | 3020 | 2788 |
| The Super League Show | 2009-04-20 04:18:00 | 3045 | 3045 |
| Later Live... with Jools Holland | 2009-04-21 21:58:00 | 1577 | 3155 |
+----------------------------------+---------------------+--------+------+
--
Mike Holden
http://www.by-ang.com - the place to shop for all manner of hand crafted
items, including Jewellery, Greetings Cards and Gifts
More information about the mythtv-users
mailing list