This patch removes an extraneous LEFT JOIN from the credits section of
showDetails in programinfo.cpp. Before the patch hitting 'U' in watch
recordings takes ~10 seconds, after the patch it is instantaneous.
Index: libs/libmythtv/programinfo.cpp
===================================================================
RCS file: /var/lib/mythcvs/mythtv/libs/libmythtv/programinfo.cpp,v
retrieving revision 1.195
diff -u -r1.195 programinfo.cpp
--- libs/libmythtv/programinfo.cpp 9 Feb 2005 21:35:13 -0000 1.195
+++ libs/libmythtv/programinfo.cpp 18 Feb 2005 00:19:49 -0000
@@ -2398,10 +2398,8 @@
{
query.prepare("SELECT role,people.name from credits"
" LEFT JOIN people ON credits.person = people.person"
- " LEFT JOIN program ON credits.chanid = program.chanid"
- " AND credits.starttime = program.starttime"
- " WHERE program.chanid = :CHANID"
- " AND program.starttime = :STARTTIME ORDER BY role;");
+ " WHERE credits.chanid = :CHANID"
+ " AND credits.starttime = :STARTTIME ORDER BY role;");
query.bindValue(":CHANID", chanid);
query.bindValue(":STARTTIME", startts.toString(Qt::ISODate));
_______________________________________________
mythtv-dev mailing list
[email protected]
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-dev
