Data to be inserted has just two TEXT columns whose individual length don't even exceed 256. I initially used executeSimpleSQL since I didn't need to get any results. It worked for simulataneous inserts of upto 20K smoothly i.e. in the bakground no lag or freezing observed. However, with 0.1 million [...] read more
In my firefox extension I'm trying to make an Update statement, but I've getting back this error Error: Component returned failure code: 0x80630001 (NS_ERROR_STORAGE_BUSY) [mozIStorageConnection.executeSimpleSQL] Insert/Select statements works fine, but Update and Delete are not working. Code: Components.utils.import("resource://gre/modules/Services.jsm"); Components.utils.import("resource://gre/modules/FileUtils.jsm"); ... this.dbFile = FileUtils.getFile("ProfD", [Source.globalValue.DB_NAME+".sqlite"]); this.db = Services.storage.openDatabase(this.dbFile); ... /* #1 [...] read more