|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:
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:
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.