[vdr] Request: E parameter in channels.conf for epg scan

Luca Olivetti luca at ventoso.org
Tue Dec 14 21:56:01 CET 2010

Al 14/12/10 21:20, En/na Luca Olivetti ha escrit:
> Al 13/12/10 11:34, En/na Steffen Barszus ha escrit:
>> That was my point in the beginning. Then: I want to see sqlite3 being
>> less efficient on insert and fetch or memory consumption. I can not
>> imagine it (prove me wrong! ;)). Last but not least i don't think any
>> user would even notice any difference in behaviour. I think the low
>> end would be PIII 700 (SMT7020s/S100) or ARMv5(sheeva/dockstar)
>> recently.
> I'd say that the performance would be better.
> Right now I have a recording going on. If I press the "up" channel past
> the last channel on the same transponder, vdr is unresponsive for ~30
> seconds.
> I guess that sqlite, with a well formulated query and the right indexes,
> would take a fraction of a second to realize that there are no more
> channels in the same transponder.

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 

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;

(note that the machine was running vdr while performing the query).


More information about the vdr mailing list