On Wed, Dec 15, 2010 at 9:21 AM, Luca Olivetti <luca@xxxxxxxxxxx> wrote: >>> 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). >> >> Why would you do a test and intentionally discard necessary data >> fields? ÂIf you're not going to run tests using _all_ the actual data, >> don't bother. > > Because, without indexes, sqlite will do a linear scan, so, e.g., doubling > the data per record, will roughly double the time, and the double of > "imperceptible" is "too little to notice". > But that anyway would be offset by using indexes and optimizing the data > types (e.g. in my query I used strings for parameters and source, and those > are very inefficient, intentionally so, just to show that sqlite wouldn't be > a bottleneck). Then you create indexes, not discard a big portion of necessary data. _______________________________________________ vdr mailing list vdr@xxxxxxxxxxx http://www.linuxtv.org/cgi-bin/mailman/listinfo/vdr
