I am working on an Angular Ionic Project that uses "Database Driven Layouts". Some Pages require a lot of single Select Statements to be executed which is very slow on Android. So i tried to execute all Select queries at once using the "executeSet" Method.
This works fine on Web but on Android this Exception is thrown: "ExecuteSet: unknown error (code 0): Queries can be performed using SQLiteDatabase query or rawQuery methods only."
The Android implementation of the executeSet Method does not consider SELECT statements, which is a major problem since improving performance on Android was the reason i did this in the first place.
I realise that i could also just use a single UNION SELECT Query, which is what i will do now. If there is no intention to make ExecuteSet compatible with SELECT statements then feel free to close this issue.
let rs = await this.db.executeSet(statements, false, 'all');
executeSet call with parameters
I am working on an Angular Ionic Project that uses "Database Driven Layouts". Some Pages require a lot of single Select Statements to be executed which is very slow on Android. So i tried to execute all Select queries at once using the "executeSet" Method.
This works fine on Web but on Android this Exception is thrown: "ExecuteSet: unknown error (code 0): Queries can be performed using SQLiteDatabase query or rawQuery methods only."
The Android implementation of the executeSet Method does not consider SELECT statements, which is a major problem since improving performance on Android was the reason i did this in the first place.
I realise that i could also just use a single UNION SELECT Query, which is what i will do now. If there is no intention to make ExecuteSet compatible with SELECT statements then feel free to close this issue.
let rs = await this.db.executeSet(statements, false, 'all');executeSet call with parameters