/ Check-in [26cb1df7]
Login
SQLite training in Houston TX on 2019-11-05 (details)
Part of the 2019 Tcl Conference

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

Overview
Comment:Fix a performance glitch that appears for large transactions.
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: 26cb1df73504d5d883cf0967e57b46aa062d0b00
User & Date: drh 2010-02-04 17:38:32
References
2010-02-25
01:47
Start a new branch for release 3.6.22 plus limited enhancements and fixes. This first check-in includes the performance enhancements of check-ins [26cb1df735], [61a2c8d4d6], and [27dc5b1c52] check-in: 95882598 user: drh tags: branch-3.6.22
Context
2010-02-05
14:12
Remove the use of 64-bit math in the offset computations of the OP_Column opcode for a small performance improvement. check-in: 61a2c8d4 user: drh tags: trunk
2010-02-04
17:38
Fix a performance glitch that appears for large transactions. check-in: 26cb1df7 user: drh tags: trunk
2010-02-03
19:55
Add a new full-text search variant that tracks the total number of documents and document sizes, to make ranking search results easier. Currently called FTS4. check-in: 1b6e6094 user: drh tags: trunk
Changes
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to src/pcache.c.

   238    238       ** unreferenced dirty page.
   239    239       */
   240    240       expensive_assert( pcacheCheckSynced(pCache) );
   241    241       for(pPg=pCache->pSynced; 
   242    242           pPg && (pPg->nRef || (pPg->flags&PGHDR_NEED_SYNC)); 
   243    243           pPg=pPg->pDirtyPrev
   244    244       );
          245  +    pCache->pSynced = pPg;
   245    246       if( !pPg ){
   246    247         for(pPg=pCache->pDirtyTail; pPg && pPg->nRef; pPg=pPg->pDirtyPrev);
   247    248       }
   248    249       if( pPg ){
   249    250         int rc;
   250    251         rc = pCache->xStress(pCache->pStress, pPg);
   251    252         if( rc!=SQLITE_OK && rc!=SQLITE_BUSY ){