Huge data sql problem

Hello
I want to make an apps which contain a quran with 3 language
so, the database is very big. 6348 rows, with 3 numeric column and 3 text column.
I want that on first open it will make the sql. But when I use run, it only setup around 1000 rows and not more than that.

What is the solution for making total 6348 rows. plz help

1000 is limit per one commit. You could do it 7 times or read the deep documentation, idk how commit the changes by ionic API.

1 Like
	this.platform.ready().then(() => {
        this.storage.query("SELECT id FROM quran LIMIT 1").then((data) => {
            this.quran = [];
            if(data.res.rows.length == 0) {
                for(var i=0;i<6500;i++){
					this.storage.query("INSERT INTO quran (sura,ayat,bangla) VALUES ("+this.qData[i][0]+","+this.qData[i][1]+",'"+this.qData[i][2]+"')");
				}
            }
        }, (error) => {
            console.log("ERROR -> " + JSON.stringify(error.err));
        });
    });

is this a problem ?