It turns out this change between 3.12.2 and 3.13 introduces a 2% increase of build time based on statistic data in bz10367.
The added patch is forged by diffing the new sqlite3.c generated from reverting the change in raw source of sqlite3 project, and then manually migrate the delta to a sqlite3.c from the 3.14.1 tarball package because what recipes reference is actually a generated C code (amalgamation) release package and we cannot apply the real change to 3.14.1 cleanly due to so many changes happened. Fixes [YOCTO #10367] Signed-off-by: Jianxun Zhang <jianxun.zh...@linux.intel.com> --- The statistic data can be found in PDF reports in https://bugzilla.yoctoproject.org/show_bug.cgi?id=10367 Most of test was done with minimal build for qemu 64 bit on pocy tip 3a73fe0efcb7aee because it is impossible to keep up with any current tip on master for a time-consuming perf debugging. A basic boot test and build time measurement on the latest(?) poky tip 371ab635086e287 was conducted before this submission. If you have any new kinky issues in build or run time, let me know and I will have a look at it to see if this sqlite change causes it. ...1c7962-that-brings-2-increase-of-build-ti.patch | 54 ++++++++++++++++++++++ meta/recipes-support/sqlite/sqlite3_3.14.1.bb | 5 +- 2 files changed, 58 insertions(+), 1 deletion(-) create mode 100644 meta/recipes-support/sqlite/files/0001-revert-ad601c7962-that-brings-2-increase-of-build-ti.patch diff --git a/meta/recipes-support/sqlite/files/0001-revert-ad601c7962-that-brings-2-increase-of-build-ti.patch b/meta/recipes-support/sqlite/files/0001-revert-ad601c7962-that-brings-2-increase-of-build-ti.patch new file mode 100644 index 0000000..fba2ebe --- /dev/null +++ b/meta/recipes-support/sqlite/files/0001-revert-ad601c7962-that-brings-2-increase-of-build-ti.patch @@ -0,0 +1,54 @@ +From 2cc091d812ab0074c5b8ec06436ea1b646745d77 Mon Sep 17 00:00:00 2001 +From: Jianxun Zhang <jianxun.zh...@linux.intel.com> +Date: Thu, 13 Oct 2016 09:24:21 -0700 +Subject: [PATCH] revert ad601c7962 that brings 2% increase of build time. + +The comment of the change in sqlite fossil project is: +"For in-memory databases, it does not matter if pcache +entries are marked "clean" or "writable"." + +Signed-off-by: Jianxun Zhang <jianxun.zh...@linux.intel.com> +--- + sqlite3.c | 12 +++--------- + 1 file changed, 3 insertions(+), 9 deletions(-) + +diff --git a/sqlite3.c b/sqlite3.c +index ccddfe6..ecae550 100644 +--- a/sqlite3.c ++++ b/sqlite3.c +@@ -13146,7 +13146,7 @@ struct PgHdr { + sqlite3_pcache_page *pPage; /* Pcache object page handle */ + void *pData; /* Page data */ + void *pExtra; /* Extra content */ +- PgHdr *pDirty; /* Transient list of dirty sorted by pgno */ ++ PgHdr *pDirty; /* Transient list of dirty pages */ + Pager *pPager; /* The pager this page is part of */ + Pgno pgno; /* Page number for this page */ + #ifdef SQLITE_CHECK_PAGES +@@ -43504,13 +43504,7 @@ bitvec_end: + /* #include "sqliteInt.h" */ + + /* +-** A complete page cache is an instance of this structure. Every +-** entry in the cache holds a single page of the database file. The +-** btree layer only operates on the cached copy of the database pages. +-** +-** A page cache entry is "clean" if it exactly matches what is currently +-** on disk. A page is "dirty" if it has been modified and needs to be +-** persisted to disk. ++** A complete page cache is an instance of this structure. + ** + ** pDirty, pDirtyTail, pSynced: + ** All dirty pages are linked into the doubly linked list using +@@ -48314,7 +48308,7 @@ static int pager_end_transaction(Pager *pPager, int hasMaster, int bCommit){ + pPager->pInJournal = 0; + pPager->nRec = 0; + if( rc==SQLITE_OK ){ +- if( pagerFlushOnCommit(pPager, bCommit) ){ ++ if( MEMDB || pagerFlushOnCommit(pPager, bCommit) ){ + sqlite3PcacheCleanAll(pPager->pPCache); + }else{ + sqlite3PcacheClearWritable(pPager->pPCache); +-- +2.7.4 + diff --git a/meta/recipes-support/sqlite/sqlite3_3.14.1.bb b/meta/recipes-support/sqlite/sqlite3_3.14.1.bb index 3af0d2f..7c8fa40 100644 --- a/meta/recipes-support/sqlite/sqlite3_3.14.1.bb +++ b/meta/recipes-support/sqlite/sqlite3_3.14.1.bb @@ -3,7 +3,10 @@ require sqlite3.inc LICENSE = "PD" LIC_FILES_CHKSUM = "file://sqlite3.h;endline=11;md5=65f0a57ca6928710b418c094b3570bb0" -SRC_URI = "http://www.sqlite.org/2016/sqlite-autoconf-${SQLITE_PV}.tar.gz"; +SRC_URI = "\ + http://www.sqlite.org/2016/sqlite-autoconf-${SQLITE_PV}.tar.gz \ + file://0001-revert-ad601c7962-that-brings-2-increase-of-build-ti.patch \ + " SRC_URI[md5sum] = "3634a90a3f49541462bcaed3474b2684" SRC_URI[sha256sum] = "bc7182476900017becb81565ecea7775d46ab747a97281aa610f4f45881c47a6" -- 2.7.4 -- _______________________________________________ Openembedded-core mailing list Openembedded-core@lists.openembedded.org http://lists.openembedded.org/mailman/listinfo/openembedded-core
