On 5/30/17, James K. Lowden <jklow...@schemamania.org> wrote: > > I didn't know sqlite3_column_text converted the result. I thought the > result was constant, and the function returned a string > representation of it. >
It might be a good optimization to change that, so that sqlite3_column_text does in fact keep the original value and just return a temporary string that is freed at the next sqlite3_step() (or sqlite3_reset() or sqlite3_finalize()). That would mean that columns that are constant do not need to be recomputed at each step. It is something to look into. But I don't think it would make much difference in most applications, so it is not a huge priority. -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
