The results below are for a non-optimized build. With -O2, the same :memory: no-outer-BEGIN/COMMIT benchmark is 6 times faster (7.953s now versus 47.828s with yesterday's CVS).
--- Joe Wilson <[EMAIL PROTECTED]> wrote: > > Can you rerun your tests with the latest CVS check-in > > and let me know if it makes a difference? > > With the latest CVS, Dennis' :memory: database test without outer > BEGIN/COMMIT is now 4.3 times > faster on my machine (58.1s before, 13.4s now). > > profile results with dirty pages fix: > > % cumulative self self total > time seconds seconds calls ms/call ms/call name > 9.20 0.31 0.31 100011 0.00 0.03 sqlite3VdbeExec > 7.42 0.56 0.25 4849544 0.00 0.00 sqlite3VdbeRecordCompare > 6.68 0.79 0.23 10487713 0.00 0.00 parseCellPtr > 5.04 0.95 0.17 12943618 0.00 0.00 sqlite3VdbeSerialGet > 5.04 1.12 0.17 400006 0.00 0.00 sqlite3BtreeMoveto > 4.45 1.27 0.15 6471807 0.00 0.00 sqlite3MemCompare > 3.56 1.40 0.12 19270230 0.00 0.00 get2byte > 3.56 1.51 0.12 12181181 0.00 0.00 findCell > 3.26 1.62 0.11 3227291 0.00 0.00 binCollFunc > 2.97 1.73 0.10 2064924 0.00 0.00 sqlite3pager_get > 2.82 1.82 0.10 4500154 0.00 0.00 sqlite3pager_unref > 2.67 1.91 0.09 29816 0.00 0.02 balance_nonroot > 2.37 1.99 0.08 2716112 0.00 0.00 _page_ref > 2.23 2.06 0.07 5270826 0.00 0.00 findOverflowCell > 2.08 2.13 0.07 2100045 0.00 0.00 sqlite3VdbeSerialType > 2.08 2.21 0.07 1332302 0.00 0.00 initPage > 2.08 2.27 0.07 86067 0.00 0.00 assemblePage > 1.78 2.33 0.06 300004 0.00 0.01 sqlite3BtreeInsert > 1.48 2.38 0.05 6735322 0.00 0.00 put2byte > 1.48 2.44 0.05 3432951 0.00 0.00 pager_lookup > > > results for same test with yesterday's CVS: > > % cumulative self self total > time seconds seconds calls ms/call ms/call name > 83.61 25.20 25.20 100002 0.25 0.25 > pager_get_all_dirty_pages > 1.87 25.77 0.56 100011 0.01 0.17 sqlite3VdbeExec > 1.00 26.07 0.30 4849544 0.00 0.00 sqlite3VdbeRecordCompare > 0.78 26.30 0.23 10487713 0.00 0.00 parseCellPtr > 0.63 26.49 0.19 12943618 0.00 0.00 sqlite3VdbeSerialGet > 0.60 26.67 0.18 400006 0.00 0.00 sqlite3BtreeMoveto > 0.50 26.82 0.15 3432951 0.00 0.00 pager_lookup > 0.43 26.95 0.13 2064924 0.00 0.00 sqlite3pager_get > 0.38 27.07 0.12 6471807 0.00 0.00 sqlite3MemCompare > 0.36 27.18 0.11 19270230 0.00 0.00 get2byte > 0.36 27.29 0.11 1368027 0.00 0.00 reparentPage > 0.36 27.39 0.11 29816 0.00 0.03 balance_nonroot > 0.33 27.50 0.10 2716112 0.00 0.00 _page_ref > 0.33 27.59 0.10 1858370 0.00 0.00 getAndInitPage > 0.30 27.68 0.09 4849549 0.00 0.00 fetchPayload > 0.28 27.77 0.09 6735322 0.00 0.00 put2byte > 0.28 27.86 0.09 1964919 0.00 0.00 getPage > 0.27 27.93 0.08 12181181 0.00 0.00 findCell > 0.27 28.02 0.08 5270826 0.00 0.00 findOverflowCell > 0.27 28.09 0.08 2722659 0.00 0.00 pageDestructor > 0.27 28.18 0.08 1332302 0.00 0.00 initPage > 0.27 28.25 0.08 359548 0.00 0.00 insertCell > 0.27 28.34 0.08 300004 0.00 0.01 sqlite3BtreeInsert > 0.25 28.41 0.07 4500154 0.00 0.00 sqlite3pager_unref > > > __________________________________________________ > Do You Yahoo!? > Tired of spam? Yahoo! Mail has the best spam protection around > http://mail.yahoo.com > __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com