Balance security with performance in android notebook app

Question

As a notebook product, the user's sensitive data should be encrypted before stored in the database, in case the Android phone was root, and the database file was stolen by another evil app.

But in that case, search in the notebook would be slow, because the app has to decrypt every notes before searching.

How to balance security with performance in this case?

Answer 1

If you need to keep your database encrypted and at the same time keep it very responsive, you could use SQLCipher. Taken from their description: "SQLCipher is an SQLite extension that provides transparent 256-bit AES encryption of database files"