diff options
| author | anbr <vdr07@deltab.de> | 2011-12-02 21:13:23 +0100 |
|---|---|---|
| committer | anbr <vdr07@deltab.de> | 2011-12-02 21:13:23 +0100 |
| commit | a1d4639a69bbba6afd0781db178d8ac5978c3b9e (patch) | |
| tree | 86557256cb57e7a5a03f7cff16e74f3d37566206 /lib | |
| parent | 88f3d82036d3ff912b78157379e0e3d6fa4b314f (diff) | |
| download | xxv-a1d4639a69bbba6afd0781db178d8ac5978c3b9e.tar.gz xxv-a1d4639a69bbba6afd0781db178d8ac5978c3b9e.tar.bz2 | |
TIMERS: improve query performence
Diffstat (limited to 'lib')
| -rw-r--r-- | lib/XXV/MODULES/TIMERS.pm | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/lib/XXV/MODULES/TIMERS.pm b/lib/XXV/MODULES/TIMERS.pm index e121b83..d2badd1 100644 --- a/lib/XXV/MODULES/TIMERS.pm +++ b/lib/XXV/MODULES/TIMERS.pm @@ -1267,6 +1267,7 @@ SELECT SQL_CACHE (SELECT IF(CHAR_LENGTH(e.description)>77,RPAD(LEFT(e.description,77),80,'.'),e.description) FROM EPG as e WHERE t.eventid = e.eventid + and t.channel = e.channel_id LIMIT 1) as __description, NOW() between starttime and stoptime AND (flags & 1) as __running, r.host as __host |