Jens Alfke wrote: > is there any difference in performance for requesting more or fewer > columns of the table in the result? Or is the performance penalty only > incurred when actually reading the column values?
During the sqlite3_step() call, all values in the SELECT clause are copied into temporary registers. In practice, this does not matter unless you have large strings/blobs that must be read from overflow pages. Regards, Clemens _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users