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:
http://www.sqlite.org/draft/queryplanner-ng.html
We've run literally millions and millions of test cases on the NGQP with no
problems. We've tested in on Linux, Windows, Mac, OpenBSD, and Solaris,
and on 32-bit and 64-bit systems. The Fossil server that manages the
SQLite website is running NGQP. The version of Firefox on which this email
is being composed is running the NGQP. Everything seems to work great.
Nevertheless, it is important that you test the NGQP in your application.
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 fuss with. Everything works exactly
as it did before, only a little faster. You should be able to simply
recompile and end up with an application that (hopefully) runs a little
faster.
Please try this out, and let me know if of your successes and of any
problems you encounter.
--
D. Richard Hipp
d...@sqlite.org
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
