Hi @Malyadri
Is Password/passphrase needed every time to open the DB connection ?
Yes, the password is required every time you open a connection to the database.
What is the best database pagesize
We generally recommend the default page size, but you are welcome to experiment with alternative sizes for your application. Keep in mind that if you use a non-standard cipher page size that migrating from major version file formats will be more cumbersome.
You may benefit from reviewing our general SQLCipher Performance guidance.