<br><div><span class="gmail_quote">On 9/4/07, <b class="gmail_sendername">Victor Perez</b> <<a href="mailto:spectro@gmail.com">spectro@gmail.com</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<span class="q"><br><div><span class="gmail_quote"></span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><br></blockquote></div><br></span>
IMHO the query is pretty quick but (at least in my case) returns a whole lot of information. I got 1168 rows back in 4 seconds but the data makes a 421K file. In my opinion the delay is from mythtv parsing through this huge dataset so we would need to find out why does it need that much information back on each row, program's primary key should be enough for mythtv to find the next program to record.
<br><br></blockquote></div><br>replying to myself, after a quick peek at the sources (scheduler.cpp) it seems they are actually loading the whole thing in memory, so in my case the backend loads 500K of crap in memory every time I delete something. I am going to check if there are better ways to do this and if there is a developer already working on it.
<br><br>/me signs up to mythtv-dev mail list<br><br>