[sqlite] Bug in sqlite3_trace/trigger/delete

On 08/03/2015 07:24 PM, sqlite-mail wrote: > > Hello Dan ! > > I downloaded again > http://www.sqlite.org/2015/sqlite-amalgamation-3081101.zip just and > recompiled it and running I still get the same 1000 lines of the > trigger call. > > My environment is ubuntu 14.04 and I'm using gcc 4.9.2 and

[sqlite] Bug in sqlite3_trace/trigger/delete

On 07/31/2015 08:34 PM, sqlite-mail wrote: > Hello ! > > I'm using sqlite for a project and with this specific database > https://dev.dadbiz.es/tmp/odoo.db.zip (12MB compressed / 38MB uncompressed) > this is happening: > > -1 Registering an sqlite3_trace function when trying to delete a

[sqlite] queryplanner.html invalid links

https://www.sqlite.org/queryplanner.html contains the text "The process is illustrated by figure 2 below." where the "figure 2" part links to https://www.sqlite.org/queryplanner.html#fig2 DocSrc: https://www.sqlite.org/docsrc/artifact/ce9ee7160e98d868?ln=100 The link to the image does not

[sqlite] Read data from database slow the first time but then very fast thereafter. How can I improve the speed for the first time read?

I am trying to read large data from the database about 1 million records. It takes around 1min for the first time read. But if I do the same process thereafter, the time is significantly reduced to 3 seconds. How can I get a fast speed for the first time read? Hope to received your valuable