Huge data sql problem


#1

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


#2

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.


#3
	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 ?