Skip to content Skip to sidebar Skip to footer

Python, Sqlite, Sqlcipher: Very Poor Performance Processing First Request

My python service uses sqlite database encrypted with sqlcipher lib. There is a performance problem when processing very first request. Database is very small and simple, requests

Solution 1:

SQLCipher by default utilizes PBKDF2, currently set to 64,000 iterations to compute an encryption key, this process is slow by design. The key will be derived generally following the first SQL command to be executed after keying the database where an operation would touch the file. We provide general performance guidance on SQLCipher here.


Post a Comment for "Python, Sqlite, Sqlcipher: Very Poor Performance Processing First Request"