/ Check-in [8029f1e4]
Login

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

Overview
Comment:The VDBE aggregate functions use an in-memory btree instead of a disk-based btree for improved performance. (CVS 1579)
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1:8029f1e465b900215acdff48c8eefb53c71341a8
User & Date: drh 2004-06-12 20:42:30
Context
2004-06-13
00:54
More speed improvements. (CVS 1580) check-in: c5ebc1c0 user: drh tags: trunk
2004-06-12
20:42
The VDBE aggregate functions use an in-memory btree instead of a disk-based btree for improved performance. (CVS 1579) check-in: 8029f1e4 user: drh tags: trunk
20:12
Speed up in the handling of VDBE cursors. (CVS 1578) check-in: e42316f5 user: drh tags: trunk
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to src/vdbeaux.c.

   776    776     ** information.
   777    777     **
   778    778     ** If db is NULL, then close the temporary btree if it is open.
   779    779     */
   780    780     if( db ){
   781    781       if( !pAgg->pBtree ){
   782    782         assert( pAgg->nTab==0 );
   783         -      rc = sqlite3BtreeFactory(db, 0, 0, TEMP_PAGES, &pAgg->pBtree);
          783  +      rc = sqlite3BtreeFactory(db, ":memory:", 0, TEMP_PAGES, &pAgg->pBtree);
   784    784         if( rc!=SQLITE_OK ) return rc;
   785    785         sqlite3BtreeBeginTrans(pAgg->pBtree, 1, 0);
   786    786         rc = sqlite3BtreeCreateTable(pAgg->pBtree, &pAgg->nTab, 0);
   787    787         if( rc!=SQLITE_OK ) return rc;
   788    788       }
   789    789       assert( pAgg->nTab!=0 );
   790    790