From 3d604f6c8c44a44772f41a8c50e473af94e0e700 Mon Sep 17 00:00:00 2001 From: "Frank Ch. Eigler" Date: Fri, 25 Nov 2022 10:00:52 -0500 Subject: [PATCH] pipeline: drop the analyze Individual analysis passes run optimize ops as they need to already. The "analyze" op here has been observed to suck up cpu & I/O, despite a pragma analysis_limit setting. --- bin/pipeline | 4 ---- 1 file changed, 4 deletions(-) diff --git a/bin/pipeline b/bin/pipeline index 1c0cc91..f6d088a 100755 --- a/bin/pipeline +++ b/bin/pipeline @@ -246,10 +246,6 @@ def main(): else: break - with sqlite3.connect(args.db, uri=True) as db: # reopen database for analyze op - db.execute("pragma analysis_limit=1000") - db.execute("analyze") - try: # requires sqlite3.sqlite_version > 3.16, but will at worst just fail db = sqlite3.connect(args.db, uri=True) # reopen database for stats -- 2.43.5