Today based on help I got for this crash report , I switched out a deprecated REALSQLDatabase object for the "new" SQLiteDatabase object. Here's a paraphrase of the client's response to using the new version:
1. the journal file is constantly being deleted and recreated. I don't remember seeing that ever happen in the old version.
2. in the old version creating the database took 1 second, and now it takes 14 seconds.
The app does massive calculations and creates very large databases requiring days to process. The example 1 second DB creation cited above is a benchmark test we made for the app. The old benchmark was 1 second, and with the new DB object that is now 14 seconds. Obviously, this is unacceptable.
I understand that when an object gets deprecated and replaced by something new, the code has to follow suit. Even when all the functionality of the old object is retained and old code will work, that doesn't mean the old code shouldn't be rewritten. So the question here is: how does the old code need to be rewritten for the new object? Are the journal file observation and slow performance enough clues to go on?