View Ticket
Not logged in
Ticket Hash: f529e49550545c210961b692aba24c1b5700182f
Title: Update query performance much slower after upgrade
Status: Pending Type: Performance
Severity: Important Priority: Medium
Subsystem: Native_Assembly Resolution: Need_More_Info
Last Modified: 2020-05-23 23:47:55
Version Found In:
User Comments:
anonymous added on 2020-04-27 07:33:47: (text/x-markdown)

We upgraded SQLite version from to recently and have noticed performance degradation for Update statements. Did 275219 records 7 inserts and 275212 updates in 30.2279744 secs. Did 275219 records 7 inserts and 275212 updates in 10.4684537 secs.

So it looks that there newer takes around 3 times longer for the updates. Is there any new Pragmas I need to set to get the old performance back?

mistachkin added on 2020-05-23 23:47:55: (text/x-markdown)
Perhaps try using "PRAGMA page_size = 512" on a new database?  If this helps,
it means the default page size change a while back impacted your use case.