SqlCipher 4.2 on Android performance issues even without encryption

[developernotes]

Hi @Lupus

@Lupus

For example this query:
SELECT id FROM tableTest;
takes about 8600 ms to finish

Is this the execution using the system SQLite, or SQLCipher for Android library? What are your timings from the opposite?

Also, what are your results from the general SQLCipher Performance Guidance here, specifically the PRAGMA cipher_profile results:

SQLCipher Performance Optimization

Optimization Guidelines The latest guidance has been moved to the SQLCipher Performance Optimization documentation. This topic has been archived to preserve discussion.