CoreData: debug: PostSaveMaintenance: fileSize 30409752 greater than prune threshold

Dear: Use core data to store super long strings. After storage, the strings are incomplete.

Xcode tips:

CoreData: debug: PostSaveMaintenance: fileSize 30409752 greater than prune threshold

CoreData: annotation: PostSaveMaintenance: wal_checkpoint(TRUNCATE) 

help me?

Replies

I don't know anything about the specific messages you're seeing, but… Instead of storing "super long strings" in a field of type String, store them in a field of type Binary Data. Also, consider the "Allows External Storage" option.

I have the same issue does anyone know what it means?

I’ve the same issue. My .sqlite file is 88 MB and my sqlite-wal is 1.5 GB! I tried to run VACUUM and:

storeDescription.setOption(["incremental_vacuum": "0", "wal_autocheckpoint": "100", "wal_checkpoint": "TRUNCATE"] as NSDictionary, forKey: NSSQLitePragmasOption)

Nothing helped. When I set a different journal_mode (DELETE or TRUNCATE), the app timeouts after 240 seconds when setting up Core Data. Any idea?