System.Data.SQLite
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: 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.