Re: [sqlite] Estimated Costs and Memory DBs

2019-07-24 Thread Dominique Devienne
On Wed, Jul 24, 2019 at 2:55 AM Justin Olbrantz wrote: > [...] my virtual table will be held completely in memory. What should I do > with the > estimatedCost value from xBestIndex? According to the documentation this > should be an approximation of the number of disk accesses for the query, >

[sqlite] Estimated Costs and Memory DBs

2019-07-23 Thread Justin Olbrantz
While looking through the SQLite3 source trying to find answers to some questions I had about virtual tables, I noticed that the memory DB is implemented as a VFS rather than a database. Is my understanding correct that this means that the estimated cost the query planner uses for memory tables