3.5.4->3.5.7 migration issues with scrypt


#1

When I upgrade from 3.5.4 to 3.5.7 (or 3.5.6), where the only change I made is changing the 4 to a 7:

compile 'net.zetetic:android-database-sqlcipher:3.5.4@aar'

I get a huge performance issue in my use of the scrypt library (+30 seconds to run it!)
(https://github.com/wg/scrypt)

Any ideas why upgrading SQLCipher would affect scrypt?

Thanks!


#2

Hi @drcrypto

I get a huge performance issue in my use of the scrypt library (+30 seconds to run it!)
Any ideas why upgrading SQLCipher would affect scrypt?

Would you provide some additional details about the scenario you are referring to? A quick review of your scrypt library source shows no dependency on SQLCipher for Android. Are you using the two libraries in conjunction within a single application? How are you using SQLCipher for Android? The full set of changes between 3.5.4 and 3.5.7 can be seen here.


#3

Yea there are no direct dependencies on SQLCipher. But it does seem that something is somehow affecting it indirectly.

Yes a single application that uses both SQLCipher and Scrypt.

re: How are you using SQLCipher for Android?
SQLiteDatabase.openDatabase, .insert, .update, .delete, .rawQuery
Not sure what you are looking for here… :slight_smile:


#4

Hi @drcrypto

Without knowing more specific information about the application, and any possible intersection between SQLCipher for Android and your scrypt implementation it is difficult for us to speculate what the issue may be. If you can provide more details about what capacity SQLCipher for Android is being used, and what if any interplay your scrypt library has during execution, we may be able to help diagnose the behavior further. We have a writeup on general SQLCipher performance that you may find beneficial in troubleshooting further.


#5

@drcrypto - It might also be helpful to know:

  1. whether the delay is reproducible on multiple different devices and architectures
  2. what is the apparent source of the slow down, is it executing scrypt or SQLCipher calls?
  3. is the issue reproducible in a very simple standalone application

#6

@sjlombardo @developernotes

re: what is the apparent source of the slow down, is it executing scrypt or SQLCipher calls?
scrypt

After some more investigation, I’ve found the reason for the slow down is doe to the failure to load the native libary for scrypt. This happens after moving from 3.5.4 to 3.5.5 so I assume this happening due to the 64 bit upgrade of SQLCipher, so the system is also trying to load the 64bit version of Scrypt (which doesn’t exist). Since it can’t load the scrypt library, it defaults to the Java version, which is why it is so much slower.

Since I don’t yet have 64bit versions of scrypt, and I believe you can’t mix 32 and 64 bit versions of libraries I’ve forced the use of 32bit SQLCipher via:
packagingOptions {
exclude 'lib/arm64-v8a/libsqlcipher.so’
exclude ‘lib/x86_64/libsqlcipher.so’
}

Does this seem like a reasonable solution?

Thanks!


#7

Hello @drcrypto

Yes, the newer builds of SQLCipher for Android did add 64-bit support. Excluding 64-bit native libraries from your application in the interim sound appropriate as the 32-bit versions of the libraries will run on 64-bit CPU’s.


#8

Perfect. Thanks for all the help! Please consider this issue closed.