| Saturday, January 11th, 2014, 00:00 UTC | ||
| [00:00:26] | MartinT: | I run with a slave backend, and I don't have any problems... |
| [00:00:37] | MartinT: | although my master is tunerless... |
| [00:03:20] | MartinT: | i did have a weird issue a while back where a frontend playing films for Videos, would stutter... only when a particular slave was unconnectable, and that slave had nothing to do with the the films that was being played... |
| [00:03:45] | MartinT: | as soon as the slave came back online, no stutter in playback... |
| [00:04:14] | MartinT: | anyone know what the minimum QT version is for myth off the top of their head? |
| [00:05:32] | xris (xris!~xris@xris.forevermore.net) has quit (Ping timeout: 245 seconds) | |
| [00:06:06] | wagnerrp: | 4.8 i believe |
| [00:06:49] | MartinT: | booo... |
| [00:07:07] | wagnerrp: | http://www.mythtv.org/wiki/Release_Notes_-_0. . . . site_Changes |
| [00:07:19] | MartinT: | lookbehinds would be far easier to achieve what I want, but they are not in till 5 |
| [00:14:28] | wagnerrp: | worth a bump for 0.28? |
| [00:14:41] | wagnerrp: | we'd need to get additional buildbots set up before seriously considering that |
| [00:15:58] | xris (xris!~xris@xris.forevermore.net) has joined #mythtv | |
| [00:18:34] | NightMonkey (NightMonkey!~NightrMon@pdpc/supporter/professional/nightmonkey) has quit (Quit: Body blow! Body blow!) | |
| [00:19:08] | jpabq (jpabq!~quassel@mythtv/developer/jpabq) has joined #mythtv | |
| [00:19:49] | jpabq_ (jpabq_!~quassel@97-123-238-225.albq.qwest.net) has quit (Ping timeout: 248 seconds) | |
| [00:25:31] | MartinT: | nah... |
| [00:26:25] | MartinT: | it's a one line thing, I can do with a split... just annoying as I've spent ages trying to build a fancy regex for it... |
| [00:28:40] | MartinT: | trying to replace "\\." with something that doesn't match if it's both preceded and followed by a single character... |
| [00:29:51] | MartinT: | i.e. "House.M.D.S01E01" would be able to remove the dots and leave it with "House M.D S01E01" |
| [00:30:59] | MartinT: | it's a minor thing, I was just needing something to fill a bit of time... |
| [00:31:09] | _nyloc_ (_nyloc_!~quassel@p3EE2CF2E.dip0.t-ipconnect.de) has joined #mythtv | |
| [00:31:39] | nyloc (nyloc!~quassel@p3EE2CF2E.dip0.t-ipconnect.de) has quit (Ping timeout: 260 seconds) | |
| [00:31:46] | wagnerrp: | easy enough to just remove the dots from the filename |
| [00:32:15] | MartinT: | that's what we do... but we also remove the one in the middle of M and D... |
| [00:32:33] | MartinT: | meaning you get a failure to match on tvdb... |
| [00:32:45] | wagnerrp: | they don't match on their side? |
| [00:32:50] | MartinT: | nope |
| [00:33:08] | MartinT: | http://thetvdb.com/api/GetSeries.php?seriesname=house%20m%20d |
| [00:33:26] | MartinT: | http://thetvdb.com/api/GetSeries.php?seriesname=house%20m.d |
| [00:33:36] | wagnerrp: | right, i'm saying all periods |
| [00:33:55] | wagnerrp: | http://thetvdb.com/api/GetSeries.php?seriesname=house%20md |
| [00:34:57] | MartinT: | hmmm interesting... |
| [00:35:35] | MartinT: | still got a similar problem with the regex though... how to match the spaces and remove them... |
| [00:35:51] | MartinT: | like I said, I can do it in code, I was just trying to be fancy with the regex |
| [00:37:11] | MartinT: | unless you were referring to fixing the filename prior to import... |
| [00:37:57] | MartinT: | in which case, the answer is yes, but I was trying to make the application do it... |
| [00:38:09] | wagnerrp: | right |
| [00:39:53] | MartinT: | basically I rescaned my entire library the other week, as I managed to junk the install... so I rescaned all my house rips... all 8 seasons.. |
| [00:40:26] | MartinT: | to get them to match, I had to go into the db and update them as the overrides in the config don't appear to be working... |
| [00:41:02] | MartinT: | I though... well, why shouldn't the application recognise that a single character separation should be an abbreviation? |
| [00:41:38] | MartinT: | invent a problem, and then find the fix... best way to fill time... |
| [00:43:20] | MartinT: | anyway, I'll give it another go tomorrow, if I can regex it, I'll just code it... |
| [00:43:30] | MartinT: | laterz |
| [00:43:35] | MartinT (MartinT!~smuxi@46-18-104-220.static.vivaciti.org) has quit (Remote host closed the connection) | |
| [00:50:54] | arescorpio (arescorpio!~arescorpi@53-243-16-190.fibertel.com.ar) has joined #mythtv | |
| [01:19:38] | xris (xris!~xris@xris.forevermore.net) has quit (Changing host) | |
| [01:19:39] | xris (xris!~xris@mythtv/developer/xris) has joined #mythtv | |
| [01:45:10] | arescorpio (arescorpio!~arescorpi@53-243-16-190.fibertel.com.ar) has quit (Excess Flood) | |
| [02:02:35] | cesman (cesman!~cesman@pdpc/supporter/professional/cesman) has joined #mythtv | |
| [03:15:38] | nyloc (nyloc!~quassel@p57B4FB62.dip0.t-ipconnect.de) has joined #mythtv | |
| [03:20:25] | _nyloc_ (_nyloc_!~quassel@p3EE2CF2E.dip0.t-ipconnect.de) has quit (Ping timeout: 272 seconds) | |
| [03:20:49] | peper03 (peper03!~peper03@mythtv/developer/peper03) has quit (Ping timeout: 252 seconds) | |
| [03:23:27] | arescorpio (arescorpio!~arescorpi@53-243-16-190.fibertel.com.ar) has joined #mythtv | |
| [03:25:43] | peper03 (peper03!~peper03@mythtv/developer/peper03) has joined #mythtv | |
| [03:32:51] | TheCrasher (TheCrasher!~TheCrashe@p50807020.dip0.t-ipconnect.de) has quit (Quit: KVIrc 4.3.1 Aria http://www.kvirc.net/) | |
| [03:35:03] | rsiebert (rsiebert!~quassel@g225063239.adsl.alicedsl.de) has joined #mythtv | |
| [03:38:15] | rsiebert_ (rsiebert_!~quassel@f052174084.adsl.alicedsl.de) has quit (Ping timeout: 260 seconds) | |
| [03:40:49] | ent42 (ent42!~entith@pool-108-55-20-208.bflony.fios.verizon.net) has joined #mythtv | |
| [03:44:48] | sl1ce (sl1ce!~johnathan@pool-100-0-19-88.bstnma.fios.verizon.net) has quit (Quit: Konversation terminated!) | |
| [03:46:28] | sl1ce (sl1ce!~johnathan@pool-100-0-19-88.bstnma.fios.verizon.net) has joined #mythtv | |
| [03:47:01] | sl1ce (sl1ce!~johnathan@pool-100-0-19-88.bstnma.fios.verizon.net) has quit (Remote host closed the connection) | |
| [03:52:08] | ent42: | Hello! Not sure if I should ask this here or in #mythtv-theming, but I noticed that when browsing recordings the Blue Abstract theme will use its icon for Dolby 7.1 for anything tagged as having "dolby" audio. I suspect this is wrong as the recordings in question only have 5.1 channel audio. I started poking around the source code to see how Mythtv determines what kind of audio a recording has (mono, sterio, surround, or dolby), bu |
| [04:12:33] | arescorpio (arescorpio!~arescorpi@53-243-16-190.fibertel.com.ar) has quit (Excess Flood) | |
| [04:18:27] | ent42 (ent42!~entith@pool-108-55-20-208.bflony.fios.verizon.net) has quit (Quit: Lost terminal) | |
| [04:31:12] | ent42 (ent42!~entith@pool-108-55-20-208.bflony.fios.verizon.net) has joined #mythtv | |
| [04:31:58] | ent42 (ent42!~entith@pool-108-55-20-208.bflony.fios.verizon.net) has quit (Client Quit) | |
| [04:35:17] | ent42 (ent42!~ent42@pool-108-55-20-208.bflony.fios.verizon.net) has joined #mythtv | |
| [04:51:59] | fetzerch (fetzerch!~quassel@unaffiliated/fetzerch) has quit (Ping timeout: 252 seconds) | |
| [04:53:29] | fetzerch (fetzerch!~quassel@unaffiliated/fetzerch) has joined #mythtv | |
| [05:33:27] | Sharky-112065 is now known as Sharky112065 | |
| [05:42:18] | jpabq_ (jpabq_!~quassel@97-123-238-225.albq.qwest.net) has joined #mythtv | |
| [05:43:01] | jpabq (jpabq!~quassel@mythtv/developer/jpabq) has quit (Ping timeout: 248 seconds) | |
| [06:09:37] | joki (joki!~joki@p54862F0B.dip0.t-ipconnect.de) has quit (Ping timeout: 272 seconds) | |
| [06:14:24] | joki (joki!~joki@p54860197.dip0.t-ipconnect.de) has joined #mythtv | |
| [06:59:50] | sl1ce (sl1ce!~johnathan@pool-100-0-19-88.bstnma.fios.verizon.net) has joined #mythtv | |
| [07:11:27] | ent42 (ent42!~ent42@pool-108-55-20-208.bflony.fios.verizon.net) has quit (Quit: Lost terminal) | |
| [07:37:12] | SteveGoodey (SteveGoodey!~steve@host217-42-222-79.range217-42.btcentralplus.com) has joined #mythtv | |
| [07:55:27] | isaaclw (isaaclw!~isaac@c-24-125-75-6.hsd1.va.comcast.net) has joined #mythtv | |
| [09:15:24] | doev (doev!~doev@p4FD42D16.dip0.t-ipconnect.de) has joined #mythtv | |
| [09:15:39] | Steve-Goodey (Steve-Goodey!~steve@host109-158-212-221.range109-158.btcentralplus.com) has joined #mythtv | |
| [09:16:27] | SteveGoodey (SteveGoodey!~steve@host217-42-222-79.range217-42.btcentralplus.com) has quit (Ping timeout: 276 seconds) | |
| [09:20:32] | doev (doev!~doev@p4FD42D16.dip0.t-ipconnect.de) has quit (Remote host closed the connection) | |
| [09:39:34] | doev (doev!~doev@p4FD42D16.dip0.t-ipconnect.de) has joined #mythtv | |
| [10:26:50] | doev (doev!~doev@p4FD42D16.dip0.t-ipconnect.de) has quit (Read error: Operation timed out) | |
| [10:34:10] | stuartm: | we don't distinguish between 7.1 and 5.1 atm, old guide data only indicated 'Dolby' (for Dolby Stereo) which is obviously useless now that we multi-channel audio with digital TV |
| [10:34:50] | stuartm: | the theme is incorrect to use a 7.1 icon though |
| [10:35:55] | stuartm: | maybe we'll get around to extending/redefining the audio properties to include the number of channels instead of vague definitions like 'Dolby' and 'Surround' |
| [10:37:41] | nephyrin (nephyrin!~neph@2620:101:8003:200:7a2b:cbff:fe9e:2e67) has quit (Remote host closed the connection) | |
| [10:37:53] | nephyrin (nephyrin!~neph@2620:101:8003:200:7a2b:cbff:fe9e:2e67) has joined #mythtv | |
| [10:47:21] | dekarl: | we could update all flags after the recording is complete from the actual properties... would help with other properties like widescreen, hdtv, too. |
| [11:05:31] | natanojl (natanojl!~jonatan@mythtv/developer/natanojl) has joined #mythtv | |
| [11:16:35] | amessina (amessina!~amessina@2001:470:c1dc:7779:d6be:d9ff:fe8d:7c1e) has quit (Quit: Konversation terminated!) | |
| [11:36:30] | sraue (sraue!~stephan@xbmc/staff/sraue) has quit (Ping timeout: 252 seconds) | |
| [11:37:34] | sraue_ (sraue_!~stephan@2a02:908:fc13:e200:3e97:eff:fe0c:d215) has joined #mythtv | |
| [11:41:21] | stuartm: | dekarl: we already do :) |
| [11:41:35] | stuartm: | actually we do it using the mpeg headers as they record |
| [11:45:04] | sraue_ is now known as sraue | |
| [11:45:08] | sraue (sraue!~stephan@2a02:908:fc13:e200:3e97:eff:fe0c:d215) has quit (Changing host) | |
| [11:45:08] | sraue (sraue!~stephan@xbmc/staff/sraue) has joined #mythtv | |
| [11:45:51] | dekarl: | stuartm :( oh noes, then its buggy. I get different values for widescreen for back-to-back episodes of one series |
| [11:46:13] | dekarl: | As long as I could blame "the guide" all was fine. Now I have to wonder if I can fix it |
| [11:48:20] | stuartm: | well not sure about the widescreen flag tbh, but hdtv 1080/720 and iirc the audio props are all determined |
| [11:48:58] | stuartm: | it's in the mpegparser |
| [11:50:36] | stuartm: | which I can't seem to find |
| [11:51:53] | dekarl: | looking at the last post to the IPTV from Freebox ticket... do we not support RTP+RTCP anymore? I can't find the string "rtcp" outside of externals :( |
| [12:07:30] | robink (robink!~quassel@unaffilated/robink) has quit (Ping timeout: 245 seconds) | |
| [12:07:55] | stuartm: | dekarl: start check by the aspect ratio values in the recordmarkup table, we add a new entry each time the aspect ratio changes, then when the recording finishes we call ProgramInfo::QueryAverageAspectRatio() from TVRec::FinishedRecording() to establish what aspect ratio was dominant |
| [12:08:45] | robink (robink!~quassel@unaffilated/robink) has joined #mythtv | |
| [12:12:35] | dekarl: | stuartm, that is a very interesting sql statement |
| [12:14:47] | stuartm: | yeah, I think that's 'evolved' since I last looked at/worked on the code |
| [12:18:03] | stuartm: | nope ... that's strange, apparently I committed all of that just 9 months ago |
| [12:18:34] | stuartm: | a) could have sworn it was a lot longer ago b) I've no memory of authoring that particular query |
| [12:18:45] | dekarl: | how does it work when you have two marks, like at the start its 4:3 then switches to 16:9 and stays like that until the end? |
| [12:19:04] | dekarl: | wouldn't it be like "duration: x in 4:3" and "duration: 0 in 16:9"? |
| [12:19:23] | Sharky112065 (Sharky112065!~Sharky112@184.75.212.34) has quit (Ping timeout: 272 seconds) | |
| [12:19:33] | stuartm: | ahh, I didn't author the query, it was a copy/paste from the one in load_markup_datum |
| [12:19:34] | dekarl: | or are we adding a "the last aspect was 16:9" mark at the end of the recording |
| [12:19:44] | dekarl: | ? |
| [12:23:50] | stuartm: | not sure, fastest way to tell would be to query the table and see what's in there |
| [12:24:22] | dekarl: | we only call AspectChange when we find a keyframe and the aspectratio was unknown or different before :( |
| [12:27:50] | dekarl: | ok, "max(mark)" is 2000 frames later then "max(mark) where type between aspect_min and aspect_max" for the recording I'm looking at |
| [12:28:34] | dekarl: | that's 80 seconds missing from the calculation in this case |
| [12:39:20] | doev (doev!~doev@p4FD42D16.dip0.t-ipconnect.de) has joined #mythtv | |
| [12:39:34] | doev (doev!~doev@p4FD42D16.dip0.t-ipconnect.de) has quit (Remote host closed the connection) | |
| [12:40:47] | dekarl: | hmm, mythweb not preserving the sort order (asc vs. desc) made me debug a 2011 recording :( one 16:9 mark, still no widescreen flag set. |
| [12:48:02] | dekarl: | soo, a recording from this week... type aspect_16:9 at mark 1, then later aspect_4:3 at mark 94486 and the last (but unrelated type) at mark 98098. The result is Aspect 4:3 |
| [12:49:06] | dekarl: | If I understand the code correctly we create spans between two marks of the same type. then group by type and return the type that has the highest sum of all durations |
| [12:49:51] | dekarl: | only that saying "its 16:9 from the this 16:9 mark until the next *16:9* mark" appears strange. should be "from this 16:9 mark to the next aspect mark" imho |
| [12:50:27] | dekarl: | or in other words, I find "rm.type = recordedmarkup.type AND " suspect |
| [12:51:24] | dekarl: | should be "rm.type >= 11 AND rm.type <= 14 AND" just like it is for recordedmarkup |
| [12:51:55] | dekarl: | ^- with this change I get the expected result |
| [12:52:41] | dekarl: | (it will still fail for the example of a short X segment followed by a long Y segment until the end. but its an improvement imho) |
| [12:54:51] | dekarl: | actually it will break that case because now two wrongs make one right... (for two segments only its simply the highest first frame that wins) |
| [13:02:25] | doev (doev!~doev@p4FD42D16.dip0.t-ipconnect.de) has joined #mythtv | |
| [13:20:51] | mrand1 (mrand1!~mrand@cpe-76-183-66-12.tx.res.rr.com) has quit (Ping timeout: 276 seconds) | |
| [13:22:10] | dekarl: | stuartm, mind to review? http://pastebin.com/Wb3ZwTBk I have tested it with manual invocations in phpmyadmin and looked at the segments. (the last segment gets counted with a duration of NULL frames) |
| [13:24:07] | dekarl: | doh, its missing an "AND" behind :ASPECTEND2 |
| [13:25:47] | dekarl: | fixed patch http://pastebin.com/6GctQ3S8 |
| [13:32:22] | TheCrasher (TheCrasher!~TheCrashe@p50807020.dip0.t-ipconnect.de) has joined #mythtv | |
| [13:35:11] | mrand (mrand!~mrand@ubuntu/member/mrand) has joined #mythtv | |
| [13:53:31] | dekarl (dekarl!~dekarl@p4FCEFFE9.dip0.t-ipconnect.de) has quit (Ping timeout: 253 seconds) | |
| [13:53:44] | dekarl (dekarl!~dekarl@p4FE845DC.dip0.t-ipconnect.de) has joined #mythtv | |
| [14:06:04] | gregL (gregL!~greg@cpe-74-76-105-205.nycap.res.rr.com) has quit (Remote host closed the connection) | |
| [14:23:40] | gregL (gregL!~greg@cpe-74-76-105-205.nycap.res.rr.com) has joined #mythtv | |
| [14:53:24] | jpharvey__ (jpharvey__!~jpharvey@host86-152-2-78.range86-152.btcentralplus.com) has quit (Ping timeout: 252 seconds) | |
| [14:56:42] | Sharky112065 (Sharky112065!~Sharky112@184.75.223.194) has joined #mythtv | |
| [15:05:10] | jpharvey__ (jpharvey__!~jpharvey@host109-148-239-207.range109-148.btcentralplus.com) has joined #mythtv | |
| [16:07:30] | doev (doev!~doev@p4FD42D16.dip0.t-ipconnect.de) has quit (Read error: Connection reset by peer) | |
| [16:08:35] | doev (doev!~doev@p4FD42D16.dip0.t-ipconnect.de) has joined #mythtv | |
| [16:15:51] | moparisthebest (moparisthebest!~quassel@mailer.moparscape.org) has quit (Remote host closed the connection) | |
| [16:21:55] | moparisthebest (moparisthebest!~quassel@mailer.moparscape.org) has joined #mythtv | |
| [16:43:01] | jpabq_ (jpabq_!~quassel@97-123-238-225.albq.qwest.net) has quit (Remote host closed the connection) | |
| [16:56:55] | TheCras4 (TheCras4!~TheCrashe@p5DCE4E62.dip0.t-ipconnect.de) has joined #mythtv | |
| [17:00:11] | TheCrasher (TheCrasher!~TheCrashe@p50807020.dip0.t-ipconnect.de) has quit (Ping timeout: 252 seconds) | |
| [17:03:48] | doev (doev!~doev@p4FD42D16.dip0.t-ipconnect.de) has quit (Quit: Verlassend) | |
| [17:23:39] | TheCrasher (TheCrasher!~TheCrashe@p50807E1E.dip0.t-ipconnect.de) has joined #mythtv | |
| [17:27:08] | TheCras4 (TheCras4!~TheCrashe@p5DCE4E62.dip0.t-ipconnect.de) has quit (Ping timeout: 252 seconds) | |
| [17:39:47] | SteveGoodey (SteveGoodey!~SteveGood@host109-158-212-221.range109-158.btcentralplus.com) has joined #mythtv | |
| [17:47:33] | doev (doev!~doev@p4FD42D16.dip0.t-ipconnect.de) has joined #mythtv | |
| [18:22:48] | nephyrin (nephyrin!~neph@2620:101:8003:200:7a2b:cbff:fe9e:2e67) has quit (Quit: No Ping reply in 180 seconds.) | |
| [18:23:11] | nephyrin (nephyrin!~neph@2620:101:8003:200:7a2b:cbff:fe9e:2e67) has joined #mythtv | |
| [18:51:24] | doev (doev!~doev@p4FD42D16.dip0.t-ipconnect.de) has quit (Quit: Verlassend) | |
| [18:57:53] | taylorr (taylorr!~taylorr@cpe-173-095-144-131.nc.res.rr.com) has joined #mythtv | |
| [18:57:53] | taylorr (taylorr!~taylorr@unaffiliated/elmojo) has joined #mythtv | |
| [18:57:53] | taylorr (taylorr!~taylorr@cpe-173-095-144-131.nc.res.rr.com) has quit (Changing host) | |
| [19:12:07] | dekarl: | http://pastebin.com/wpqjTJZi http://pastebin.com/czx62DAn <- rework ProgramInfo::QueryAverageAspectRatio(), can someone take a look if that's good for pushing? |
| [20:10:52] | MartinT (MartinT!~smuxi@46-18-104-220.static.vivaciti.org) has joined #mythtv | |
| [20:30:03] | warped_ (warped_!~piotro@89-79-250-31.dynamic.chello.pl) has joined #mythtv | |
| [20:30:48] | brfransen (brfransen!~brfransen@64.179.169.226) has quit () | |
| [21:02:49] | MartinT: | dekarl: I'm obviously no expert, but QueryAverageAspectRatio, doesn't actually return an average does it> |
| [21:04:30] | dekarl: | MartinT: no, it returns the aspect ratio that is signalled for the longest time |
| [21:06:07] | dekarl: | (13:10:46) stuartm: dekarl: ... when the recording finishes we call ProgramInfo::QueryAverageAspectRatio() from TVRec::FinishedRecording() to establish what aspect ratio was dominant |
| [21:06:31] | MartinT: | just thinking that it might be worth changing the method name to actually describe what it does... |
| [21:06:55] | MartinT: | I was just reviewing your proposed commit to see if I could help, and it was a bit misleading... |
| [21:07:07] | MartinT: | principal of least surprise... |
| [21:23:02] | dekarl: | MartinT: I think its called like that because the other functions actually return an average. You're still right though. The name is a little bit misleading. |
| [21:23:49] | dekarl: | But the more I think about it, the more complex it gets (should it consider the cut list and only count uncut frames?) |
| [21:27:35] | MartinT: | seeing as it's based on the recording, shouldn't it just use the raw output? |
| [21:28:00] | MartinT: | i.e. not using the cutlist... |
| [21:29:16] | MartinT: | or maybe an overload on the method that allows it take into account the cutlist, then the caller can choose... |
| [21:29:35] | robink (robink!~quassel@unaffilated/robink) has quit (Ping timeout: 245 seconds) | |
| [21:30:06] | robink (robink!~quassel@unaffilated/robink) has joined #mythtv | |
| [21:32:12] | MartinT: | so "mark" in that table is the number of (some time based integer) from the start of the recording? |
| [21:32:37] | dekarl: | IIRC it is the frame number |
| [21:33:07] | dekarl: | but actually that is a good question because it leads to questions like "is it 0 or 1 based?" |
| [21:33:44] | dekarl: | from some bug reports it appears as its interpreted differently in different part of the code (leading to off by ones and funny effects) |
| [21:35:50] | robink (robink!~quassel@unaffilated/robink) has quit (Ping timeout: 240 seconds) | |
| [21:36:27] | dekarl: | #11924 if someone could clarify how that all goes together (is the timestamp signalling the beginning of the frame or the end? hint, the first frame has timecode 0:00) and if its 0 or 1 based. Is the frame with the cut mark kept or dropped? |
| [21:36:27] | ** MythLogBot http://code.mythtv.org/trac/ticket/11924 ** | |
| [21:38:37] | robink (robink!~quassel@unaffilated/robink) has joined #mythtv | |
| [21:38:47] | MartinT: | don't know if it's of use, by most of the recordings I can see in my db have the first mark as 1 |
| [21:38:53] | MartinT: | for those types... |
| [21:38:57] | mrand (mrand!~mrand@ubuntu/member/mrand) has quit (Ping timeout: 252 seconds) | |
| [21:40:47] | warped_ (warped_!~piotro@89-79-250-31.dynamic.chello.pl) has left #mythtv () | |
| [21:51:31] | MartinT: | dekarl: what I would say is that I don't see a reason for a second bind values... |
| [21:52:02] | MartinT: | can it not be bound to the :ASPECTSTART, and just use the same one? |
| [21:53:21] | MartinT: | I'd also take the opportunity to replace rm.chanid = recordedmarkup.chanid with rm.chanid = :CHANID |
| [21:54:05] | MartinT: | minor performance improvement over a join (that's based on SQL Server/postgres, but I imagine MySQL is the same) |
| [21:54:08] | mrand (mrand!~mrand@ubuntu/member/mrand) has joined #mythtv | |
| [21:54:30] | MartinT: | oh, and the same with the starttime in the sub select... |
| [21:55:16] | MartinT: | I was trying to find a way to simplify the sql, but my head hurts now... |
| [22:02:18] | brfransen (brfransen!~brfransen@64.179.169.226) has joined #mythtv | |
| [22:11:45] | amessina (amessina!~amessina@2001:470:c1dc:7779:d6be:d9ff:fe8d:7c1e) has joined #mythtv | |
| [22:36:31] | moparisthebest (moparisthebest!~quassel@mailer.moparscape.org) has quit (Read error: Connection reset by peer) | |
| [22:51:49] | amessina (amessina!~amessina@2001:470:c1dc:7779:d6be:d9ff:fe8d:7c1e) has quit (Quit: Konversation terminated!) | |
| [22:57:44] | sl1ce (sl1ce!~johnathan@pool-100-0-19-88.bstnma.fios.verizon.net) has quit (Quit: Konversation terminated!) | |
| [22:59:37] | sl1ce (sl1ce!~johnathan@pool-100-0-19-88.bstnma.fios.verizon.net) has joined #mythtv | |
| [22:59:38] | Chutt (Chutt!~ijr@2605:a000:1208:c08c:49ea:e998:f26:d8ae) has quit (Ping timeout: 264 seconds) | |
| [23:04:06] | moparisthebest (moparisthebest!~quassel@mailer.moparscape.org) has joined #mythtv | |
| [23:09:25] | amessina (amessina!~amessina@2001:470:c1dc:7779:d6be:d9ff:fe8d:7c1e) has joined #mythtv | |
| [23:17:31] | SteveGoodey (SteveGoodey!~SteveGood@host109-158-212-221.range109-158.btcentralplus.com) has quit (Ping timeout: 272 seconds) | |
| [23:35:16] | wagnerrp_ (wagnerrp_!~wagnerrp_@mythtv/developer/wagnerrp) has joined #mythtv | |
| [23:36:11] | wagnerrp (wagnerrp!~wagnerrp_@mythtv/developer/wagnerrp) has quit (Ping timeout: 252 seconds) | |
IRC Logs collected by
BeirdoBot.
Please use the above link to report any bugs.