System.Data.SQLite
Ticket Change Details
Not logged in
Overview

Artifact ID: 09243643c2a032dc4780c1b83395fee319c1f7ff
Ticket: f529e49550545c210961b692aba24c1b5700182f
Update query performance much slower after upgrade
User & Date: mistachkin 2020-05-23 23:47:55
Changes

  1. icomment:
    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.
    
  2. login: "mistachkin"
  3. mimetype: "text/x-markdown"
  4. priority changed to: "Medium"
  5. resolution changed to: "Need_More_Info"
  6. status changed to: "Pending"
  7. subsystem changed to: "Native_Assembly"
  8. type changed to: "Performance"