We developed an application for the iPad (using Sencha Touch and Phonegap) that stores data locally using websql db. Thousands of records are inserted into db during synchronization, but sometimes the application crashes in the middle of the process due to high memory usage. Starting the application, the Xcode Instruments tool displays about 80 mb of memory allocated by "VM: SQLite page cache". The question arises: is there a way to clear this "page cache" or close the connection to db? I read some topics about pragmas for setting cache size in SQLite, but I did not find a way to do this with websql db.
source share