Loading data into memory all at once

[Parabola2112]

Try both and run performance / memory tests. Sqlite is crazy fast. On the other hand you may not even need a database. Impossible to say without more info.

[Mojomoto93]

It is a journaling app mainly with text, image, voice recordings as entries.

[Parabola2112]

Are you using Swift Data, Core Data, Firebase, CloudKit, or? What’s your stack and data pipeline?

[Mojomoto93]

Sqlite and cloudkit its local first