Am 14.12.2010 21:56, schrieb Luca Olivetti: > Instead of speculating I actually tried. > I created a test database with the contents of my channels.conf (only > containing the number, name, frequency, source, symbol rate and the > vpid, I don't think adding all the fields would change the result > considerably). > > With no indexes, the time to get the result to the following query > (which is meant to find the next channel in the same transponder) is too > short to measure: > > select * from channels where nr>13 and freq=10992 and > params='VC23M2O0S0' and source='S13.0E' and sr=27500 and vpid>0 order by > nr limit 1; You didn't do a join of the channel list with the list of devices (on tuned transponder, or on not tuned device, or - join with all connected streams of that device - all streams have lower priority than live priority), and a join with all CAM on whether the CAM works with the device, and a join with all CAM slots of all CAMs that can work with device on whether the CAM slot is free or CAM slot priority is lower than live priority. (thats still simplified.) SCNR, Udo _______________________________________________ vdr mailing list vdr@xxxxxxxxxxx http://www.linuxtv.org/cgi-bin/mailman/listinfo/vdr
