Re: [sqlite] The next-generation query planner

Richard Hipp writes: > The combination of schema, sqlite_stat1, and query is normally sufficient, > yes. > > Can you change (and shorten) the table and index and column names to > obscure their meaning and origin, and give us written permission to include > your case in the published

Re: [sqlite] The next-generation query planner

On Fri, Jun 28, 2013 at 8:45 AM, Wolfgang Enzinger wrote: > Richard Hipp writes: > > > Nevertheless, it is important that you test the NGQP in your application. > > Getting back at the issue described in > http://article.gmane.org/gmane.comp.db.sqlite.general/81564

Re: [sqlite] The next-generation query planner

Richard Hipp writes: > > I try to compile with SQLITE_HAS_CODEC defined I get errors saying that > > sqlite3_key_v2 and sqlite3_rekey_v2 functions are undefined. Are these new > > APIs? > > > > Yes. You need to use your login and password to download the latest SEE > source - the

Re: [sqlite] The next-generation query planner

On Fri, Jun 28, 2013 at 7:21 AM, E.Pasma wrote: > > I tested the draft version ... > Thanks for the test report! > Unfortunately I also found a bug. For some reason the optimizer may ignore > a where clause on an outerjoined table. The example below shows this, as > far

Re: [sqlite] The next-generation query planner

Op 26 jun 2013, om 16:08 heeft Richard Hipp het volgende geschreven: The next-generation query planner (NGQP) is a rewrite of the query planner for SQLite that is faster (reduced run-time for sqlite3_prepare()) and generates better plans for queries (reducing the run-time for

Re: [sqlite] The next-generation query planner

On Fri, Jun 28, 2013 at 6:50 AM, Wolfgang Enzinger wrote: > Richard Hipp writes: > > > Amalgamations for the latest SQLite containing the NGQP are available > from > > the http://www.sqlite.org/draft/download.html page. This should be a > > drop-in replacement for

Re: [sqlite] The next-generation query planner

Richard Hipp writes: > Amalgamations for the latest SQLite containing the NGQP are available from > the http://www.sqlite.org/draft/download.html page. This should be a > drop-in replacement for the amalgamation you are currently using. There > are no new APIs or compiler flags to

Re: [sqlite] The next-generation query planner

ussion of SQLite Database > Betreff: [sqlite] The next-generation query planner > > The next-generation query planner (NGQP) is a rewrite of the query planner > for SQLite that is faster (reduced run-time for sqlite3_prepare()) and > generates better plans for queries (reducing the run-time

[sqlite] The next-generation query planner

The next-generation query planner (NGQP) is a rewrite of the query planner for SQLite that is faster (reduced run-time for sqlite3_prepare()) and generates better plans for queries (reducing the run-time for sqlite3_step()). More information about the NGQP is available here: