/ Check-in [35b4d6e9]
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 | SQL archive
Timelines: family | ancestors | descendants | both | insert-optimization
Files: files | file ages | folders
SHA1: 35b4d6e938164fabaf30b504c54cfd9a69060cee
User & Date: drh 2014-02-17 14:59:22
Context
2014-02-17
15:36
Merge the VDBE_PROFILE fixes from trunk. check-in: 2914e419 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: 35b4d6e9 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: aa2d8b0e user: drh tags: insert-optimization
Changes
Unified Diffs Side-by-Side Diffs 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.