[sqlite] Increasing performance of query

Dear SQLite communiy, I’m trying to increase the performance of a query to its maximum possible speed. The schema is roughly constituted of two tables, one is a full text index, fts5_table, while the other is called datatable. The query in question is a full text query on the full text index

Re: [sqlite] Increasing performance of query

Thanks for your answers! First of all, my apologies with ANALYZE I meant that it increased performance (decreased query time) by orders of magnitude. Before ANALYZE the query was in the order of seconds (about 2 seconds). After ANALYZE the query was in the order of milliseconds. I tried VACUUM

Re: [sqlite] Increasing performance of query

. (However, I wasn't able to load my dataset into a memory db because, by using .dump the fts5 table doesn't get backed up correctly). Thanks, Gabriele On Fri, Apr 21, 2017 at 10:34 AM, Gabriele Lanaro <gabriele.lan...@gmail.com > wrote: > Thanks for your answers! > > First of al

[sqlite] SQLite in memory

Hi, I'm trying to assess if the performance of my application is dependent on disk access from sqlite. To rule this out I wanted to make sure that the SQLite DB is completely accessed from memory and there are no disk accesses. Is it possible to obtain this effect by using pragmas such as

Re: [sqlite] SQLite in memory

are SSD. Thanks, Gabriele On Thu, May 18, 2017 at 7:51 AM, Eduardo Morras <emorr...@yahoo.es> wrote: > On Wed, 17 May 2017 22:18:19 -0700 > Gabriele Lanaro <gabriele.lan...@gmail.com> wrote: > > > Hi, I'm trying to assess if the performance of my application is > &