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

-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] Im Auftrag von Dimitris Bil Gesendet: Montag, 03. Juli 2017 19:14 An: sqlite-users@mailinglists.sqlite.org Betreff: [sqlite] Concurrent reads for VTs with in-memory data structures I have some virtual tables that keep in-memory data struct

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

--Original Message- > From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] > On Behalf Of Dimitris Bil > Sent: Monday, 3 July, 2017 11:14 > To: sqlite-users@mailinglists.sqlite.org > Subject: [sqlite] Concurrent reads for VTs with in-memory data structures &g

[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

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

table query performance On Wed, 8 Feb 2017, Dimitris Bil wrote: > 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? My benchmark repeatedly rea

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

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

atch Call xEof() Call xColumn() -> return 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] I

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

ite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] Im Auftrag von Dimitris Bil Gesendet: Samstag, 22. Oktober 2016 15:31 An: sqlite-users@mailinglists.sqlite.org Betreff: [sqlite] Virtual table acting as wrapper of a regular table Hello, I am trying to create a simple virtual table th

[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