Thanks; that sounds like a very worthwile update. Will let you know what the performance gain is once I have my wrappers sorted.
RBS > SQLite version 3.3.14 is now available on the SQLite website > > http://www.sqlite.org/ > > Version 3.3.14 focuses on performance improvements. There > have been several changes to the back-end layers (the pager > and the b-tree subsystems) that reduce the amount of disk > I/O. A new optimization has been added to the INSERT command > which, as a side effect, makes VACUUM work significantly faster > for large databases and helps VACUUM to greatly reduce the > amount of fragmentation in the database. We have also added > the concept of "exclusive access mode". In exclusive access > mode, SQLite holds onto locks until you close the connection. > This allows for additional I/O reductions and corresponding > performance improvements, at the expense of concurrency. The > core SQLite sources are now also available as a single huge > file of C code (which we call "the amalgamation") rather than > as a collection of smaller files. > > When all the latest changes are used and the code is > recompiled using the amalgamation with -O3 under gcc 4.1.0, > we are seeing performance improvements on Linux of about 35% > over version 3.3.13. We are very interesting in hearing > about performance changes on other compilers and with other > operating systems. > > Version 3.3.14 incorporates many changes over version 3.3.13. > These changes have been well tested on Linux, but as the > no so much on windows and other systems. If you find problems, > please report them either on this list or at > > http://www.sqlite.org/cvstrac/tktnew > > -- > D. Richard Hipp <[EMAIL PROTECTED]> > > > > ----------------------------------------------------------------------------- > To unsubscribe, send email to [EMAIL PROTECTED] > ----------------------------------------------------------------------------- > > > ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
