Changes between Initial Version and Version 1 of Ticket #7604
- Timestamp:
- Nov 18, 2009, 8:05:19 PM (14 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
Ticket #7604
-
Property
Status
changed from
new
toinfoneeded_new
-
Property
Status
changed from
-
Ticket #7604 – Description
initial v1 1 1 When I delete a recording through the frontend it takes over 15 seconds until the record is deleted. There is one very slow query that takes over 13 seconds: 2 2 {{{ 3 3 SELECT DISTINCT channel.chanid, channel.sourceid, program.starttime, program.endtime, program.title, program.subtitle, program.description, channel.channum, channel.callsign, channel.name, oldrecduplicate, program.category, sched_temp_record.recpriority, sched_temp_record.dupin, recduplicate, findduplicate, sched_temp_record.type, sched_temp_record.recordid, program.starttime - INTERVAL sched_temp_record.startoffset 4 4 MINUTE AS recstartts, program.endtime + INTERVAL sched_temp_record.endoffset … … 33 33 AND oldrecstatus.title = program.title ) 34 34 ORDER BY sched_temp_record.recordid DESC 35 35 }}} 36 36 Here is the explain of this query: 37 {{{ 37 38 id select_type table type possible_keys key key_len ref rows Extra 38 39 1 SIMPLE capturecard ALL PRIMARY NULL NULL NULL 3 Using temporary; Using filesort … … 42 43 1 SIMPLE channel eq_ref PRIMARY,sourceid PRIMARY 4 myth-test.recordmatch.chanid 1 Using where 43 44 1 SIMPLE program eq_ref PRIMARY,id_start_end,program_manualid,starttime PRIMARY 16 myth-test.recordmatch.chanid,myth-test.recordmatch.starttime,myth-test.recordmatch.manualid 1 44 1 SIMPLE oldrecstatus ALL NULL NULL NULL NULL 4224 45 1 SIMPLE oldrecstatus ALL NULL NULL NULL NULL 4224 46 }}}