On Mon, Feb 18, 2019 at 2:16 PM Arun - Siara Logics (cc) <a...@siara.cc> wrote:
> 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? > No there isn't. Query parsing and planner is fast enough. Pages are not accessible using the public API. "Regular" tables (i.e. not the new Without Rowid tables) have an implicit rowid integral column. Querying use that column is faster, since no index access is necessary at all. You cannot do any better than this. --DD _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
