SQLite

Check-in [35b4d6e938]
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:Avoid unnecessary calls to applyAffinity() during INSERT and UPDATE operations, especially for table that have indices and tables for which all columns have affinity "NONE".
Downloads: Tarball | ZIP archive
Timelines: family | ancestors | descendants | both | insert-optimization
Files: files | file ages | folders
SHA1: 35b4d6e938164fabaf30b504c54cfd9a69060cee
User & Date: drh 2014-02-17 14:59:22.345
Context
2014-02-17
15:36
Merge the VDBE_PROFILE fixes from trunk. (check-in: 2914e41911 user: drh tags: insert-optimization)
14:59
Avoid unnecessary calls to applyAffinity() during INSERT and UPDATE operations, especially for table that have indices and tables for which all columns have affinity "NONE". (check-in: 35b4d6e938 user: drh tags: insert-optimization)
2014-02-16
01:55
Enhance the code generator for INSERT INTO ... SELECT so that the SELECT generates output directly in the registers that INSERT INTO will be using, in many cases, and OP_SCopy operations can thus be avoided. (check-in: aa2d8b0e81 user: drh tags: insert-optimization)
Changes
Unified Diff Side-by-Side Diff Patch
Changes to src/analyze.c.
Changes to src/delete.c.
Changes to src/fkey.c.
Changes to src/insert.c.
Changes to src/pragma.c.
Changes to src/sqliteInt.h.
Changes to src/update.c.
Changes to src/vdbe.c.