Re: [sqlite] Concurrent reads for VTs with in-memory data structures

d. Bootstrap: CREATE VIRTUAL TABLE my_table_rw USING my_module ( 'RW' ); INSERT INTO ... DROP TABLE my_table_rw; Applcation. CREATE VIRTUAL TABLE my_table USING my_module (); -Ursprüngliche Nachricht- Von: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.or

Re: [sqlite] Concurrent reads for VTs with in-memory data structures

eton across multiple processes. However this is not the default because static data segments are "process local" not "library local" ... -- ˙uʍop-ǝpısdn sı ɹoʇıuoɯ ɹnoʎ 'sıɥʇ pɐǝɹ uɐɔ noʎ ɟı > -Original Message- > From: sqlite-users [mailto:sqlite-users-boun..

[sqlite] Concurrent reads for VTs with in-memory data structures

I have some virtual tables that keep in-memory data structures. Data loading is happening at table creation (xCreate and xConnect are the same) and after that, during querying, only read access is needed. Queries do not access any other tables. Is there a way to achieve concurrent execution with

Re: [sqlite] Virtual table vs real table query performance

year ago). From: sqlite-users on behalf of Bob Friesenhahn Sent: Wednesday, February 8, 2017 4:09 PM To: SQLite mailing list Subject: Re: [sqlite] Virtual table vs real table query performance On Wed, 8 Feb 2017, Dimitris Bil wrote: > Do you perform the benchm

Re: [sqlite] Virtual table vs real table query performance

Hello, Do you perform the benchmark on the native database table using cold cache or warm cache? Also, can you briefly describe what the benchmark does and give the schema for the native database table? thanks From: sqlite-users on behalf of Bob Friesenhah

Re: [sqlite] Query Planner fails to recognise efficient strategy when '=' condition gives a strong hint

Why don't you just explicitly sort by bar.foo? sqlite> EXPLAIN QUERY PLAN SELECT bar.foo as id, foo.baz FROM bar CROSS JOIN foo ON bar.foo = foo.id ORDER BY bar.foo LIMIT 10, 10; 0|0|0|SCAN TABLE bar 0|1|1|SEARCH TABLE foo USING INTEGER PRIMARY KEY (rowid=?) sqlite> Dimitris

Re: [sqlite] Virtual table acting as wrapper of a regular table

n result value Call xNext() -> step(), column_value() -> Retrieve next row from table B This is about twice as much work. -Ursprüngliche Nachricht- Von: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] Im Auftrag von Dimitris Bil Gesendet: Montag, 24. Oktober

Re: [sqlite] Virtual table acting as wrapper of a regular table

tep" and "column" in your xFilter/xNext methods and an extra "result" in your xColumn function. Doing twice as much work taking twice as long seems quite reasonable. -Ursprüngliche Nachricht- Von: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org]

[sqlite] Virtual table acting as wrapper of a regular table

Hello, I am trying to create a simple virtual table that acts as wrapper for a normal database table for a specific query. For example, consider that I have tables A and B in my database and the query: select count(A.id) from A CROSS JOIN B where A.id=B.id Now I am using a virtual table acting