On Thu, Mar 28, 2013 at 6:06 PM, Simon Slavin <[email protected]> wrote: > On 28 Mar 2013, at 9:54pm, Nico Williams <[email protected]> wrote: > >> Question: would it be better to optimize key and value encodings more >> for CPU and less for space? > > Don't forget that SQLite is not solely intended for running on a desktop > computer. Almost all smartphones use SQLite for many purposes. My TV > recorder uses SQLite for keeping lists of channels and recorded programmes. > SQLite is used inside many GPS units to maintain tracks and Points Of > Interest.
There the disparity in favor of optimizing for speed might well be bigger: using more CPU == using more power, shorter battery life. Storage size has no impact on power consumption, though I/Os do, of course, and larger encodings generally lead to more I/Os, but the difference should still favor optimizing for speed. The CPUs-get-no-faster-at-serial-work while storage-and-network-gets-bigger-and-faster-all-the-time dynamic applies all the more to mobile devices than to desktops. Nico -- _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
