Something that would be very useful in the shell code in a future release would be the ability to handle data containing embedded binary data. I use the shell to populate tables and many of the files I need to load have the odd \n or \000 embedded in what whould be ascii text. Sybase handles this situation but for sqlite I need to filter the data first. Obviously not a priority but nevertheless something nice to get fixed eventually...
jim -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, April 02, 2007 11:47 AM To: sqlite-users@sqlite.org Subject: [sqlite] Version 3.3.14 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] ------------------------------------------------------------------------ ----- -------------------------------------------------------- NOTICE: If received in error, please destroy and notify sender. Sender does not intend to waive confidentiality or privilege. Use of this email is prohibited when received in error. ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
