search

davibe / Phonegap-SQLitePlugin

A phonegap plugin to open and use sqlite databases on iOS.
191 stars 90 forks source link

SQLitePlugin Fails after 1000 transactions on iOS #33

Closed n8sabes closed 9 years ago

n8sabes commented 9 years ago

Execute 1000 "transactions" sequentially and the app freezes up preventing further Sqlite calls. Completion functions are no longer called after 500~1000 cycles causing the freeze. Here is an example of the problem:

https://github.com/n8sabes/ionic-sqlite-1000-transactions-ios-bug

Any input on the cause / fix would be appreciated.

davibe commented 9 years ago

You are using Cordova-SQLitePlugin implementation from "brodysoft" github user. I suggest you refer to him.

n8sabes commented 9 years ago

Thank you. I posted the question on brodysoft's project as well.

NOTE -- I just rebuilt the example (replacing the SQLite plugin with your plugin) and the same issue occurs only the cycles before failure are >1500. Can you try to cycling 1500+ sequential transactions (with or without an INSERT within it) on the iOS simulator and see what your results are? My completion functions stop being called and then the SQLite plugin goes deaf.

I've been chasing this (bug?) all day and welcome any thoughts on the issue.

I'm running iOS 8.1 (12B411)