Android SQLCipher BLOB Performance

Question

I want to store blobs in a sql database thats encrypted by sql cipher.

My blobs are images with an average size of 40kb.

Has anyone of you experience with sql cipher and blobs?

I would like to know if i can expect an acceptable performance.

Pulkit Sethi · Accepted Answer · 2013-10-09 05:10:26Z

2

I store images of any size (dependent on camera) the database is sql cipher images can be 3-4 MB in size. at a time I can store 10 images which would max take 4 seconds (this time also includes other heavy stuff) but the performance is quiet reasonable 40KB should not be any trouble at all. Go for it No worries

answered Oct 9, 2013 at 5:10

Pulkit Sethi

1,3251 gold badge14 silver badges22 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Stephen Lombardo Over a year ago

For optimal performance, you should store your blob data in a separate table. This will allow sqlcipher to search trough metadata tables without decrypting all of the blob content.

Collectives™ on Stack Overflow

Android SQLCipher BLOB Performance

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related