|Title:||Update query performance much slower after upgrade|
|Last Modified:||2020-05-23 23:47:55|
|Version Found In:||188.8.131.52|
anonymous added on 2020-04-27 07:33:47:
Hi, We upgraded SQLite version from 184.108.40.206 to 220.127.116.11 recently and have noticed performance degradation for Update statements. 18.104.22.168: Did 275219 records 7 inserts and 275212 updates in 30.2279744 secs. 22.214.171.124: 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.