• Welcome, Guest. Please login.
 
September 17, 2019, 02:40:27 pm

News:

Welcome to the SQLitening support forums!


Big changes coming to SQLIte itself

Started by Paul Squires, January 16, 2008, 10:24:14 am

Previous topic - Next topic

Paul Squires

Here is a quote from Richard Hipp himself (from the SQLite mailing list):
Quote
In case you haven't been watching the timeline
(http://www.sqlite.org/cvstrac/timeline) we are in the middle
of some major changes. The virtual machine inside of SQLite
is being transformed from a stack-based machine into a
register-based machine.  The whole virtual machine and
the code generator is being rewritten.  Slowly.  Piece by
piece.  I haven't done an overall line change count yet, but
we are looking at some pretty serious code churn.  3.5.4 to
3.5.5 is likely to be the biggest single change in the history
of SQLite.

Looks like some cool stuff is happening. I followed the thread and the biggest reason for the change is to simplify code generation and avoid stack overflow errors (there will no longer be a stack). Hipp also implies that because of the streamlined code and reduction in stack based operations, that the engine itself should see some level of performance increase (although it is too early in the process to tell at this time). They only started making these changes Jan 2nd.


Paul Squires

Looks like the changes have now been made. The SQLite site has a new update (version 3.5.5) available that incorporates the new register based machine.  http://www.sqlite.org/releaselog/3_5_5.html

The next version of SQLite3 C/S (0008) will use this new DLL.