Thank you, for the detailed advice, info and the pointer. Is there a faster way to query the table using row id, that is, skip the query parsing and planner? I still need the page cache feature and allow for concurrent modification of the row involved, while ensuring determinism by designing so. I guess sqlite3_exec() would take care of this, but is there a faster way?
---- On Mon, 18 Feb 2019 16:55:23 +0530 Richard Hipp <[email protected]> wrote ---- > On 2/18/19, Arun - Siara Logics (cc) <[email protected]> wrote: > > Hi, > > > > This is for an experimental feasibility study. Is it possible to read > > specific row(s) from a table within same db (using row ids) from inside a > > User defined Deterministic scalar function (C API)? > > > > If known, kindly point me to an existing open source implementation. > > https://www.sqlite.org/src/file/ext/misc/eval.c > > -- > D. Richard Hipp > [email protected] > _______________________________________________ > sqlite-users mailing list > [email protected] > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
