| 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 4.67 years ago |
Created: |
2020-04-27 07:33:47 5.18 years ago |
| 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. | ||||