Ticket Hash: | f529e49550545c210961b692aba24c1b5700182f | |||
Title: | Update query performance much slower after upgrade | |||
Status: | Closed | Type: | Performance | |
Severity: | Important | Priority: | Medium | |
Subsystem: | Native_Assembly | Resolution: | Need_More_Info | |
Last Modified: | 2020-10-29 02:39:17 | |||
Version Found In: | 1.0.112.1 | |||
User Comments: | ||||
anonymous added on 2020-04-27 07:33:47:
Hi, We upgraded SQLite version from 1.0.84.0 to 1.0.112.1 recently and have noticed performance degradation for Update statements. 1.0.112.1: Did 275219 records 7 inserts and 275212 updates in 30.2279744 secs. 1.0.84.0: 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. |