You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Without ROW ID can have negative impacts on larger rows and update hooks don't work anymore
SQLite recommends to implement without rowid at the end of the development cycle
A good strategy is to simply not worry about WITHOUT ROWID until near the end of product development, then go back and run tests to see if adding WITHOUT ROWID to tables with non-integer PRIMARY KEYs helps or hurts performance, and retaining the WITHOUT ROWID only in those cases where it helps.
Context
We define primary keys, there is no need for the implicit rowid column that sqlite sets.
https://www.sqlite.org/withoutrowid.html
Proposal
Use withoutrowid.
The text was updated successfully, but these errors were encountered: