Hacker News new | ask | show | jobs
by lsh123 927 days ago
Don’t use ORM for performance critical DB operations and write SQL by hand might be another answer. Case in point: I recently improved performance of my email app by about 250x by replacing SwiftData with native SQLite database (and manual sql queries). The message data is under 1M rows range plus a lot of blobs/attachments (under 10MB each).
1 comments

Adding ORM on top of SQL database seems so backwards. What's the point of using SQL database at that point?
Availability of standardized infrastructure and a broad labour pool that can manage it.