sqlite3_exec still prepares an SQL query and executes it with step. It is merely syntactic sugar (a convenience wrapper) around the standard prepare and step procedure.
--- The fact that there's a Highway to Hell but only a Stairway to Heaven says a lot about anticipated traffic volume. >-----Original Message----- >From: sqlite-users [mailto:sqlite-users- >boun...@mailinglists.sqlite.org] On Behalf Of Arun - Siara Logics >(cc) >Sent: Monday, 18 February, 2019 06:16 >To: SQLite mailing list >Subject: Re: [sqlite] Reading a table from inside a scalar function >Importance: High > >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 ><d...@sqlite.org> wrote ---- > > On 2/18/19, Arun - Siara Logics (cc) <a...@siara.cc> 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 > > d...@sqlite.org > > _______________________________________________ > > sqlite-users mailing list > > sqlite-users@mailinglists.sqlite.org > > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite- >users > > > > >_______________________________________________ >sqlite-users mailing list >sqlite-users@mailinglists.sqlite.org >http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
