mardi 3 novembre 2015

How to insert multiple rows without losing performance SQLITE + C#

My applicantion needs to insert 221 rows when it started by 1st time, so, i am losing performance because i am using arrays to insert it. for exemple.

 private async Task insereHinos()
    {
        var local = Path.Combine(Windows.Storage.ApplicationData.Current.LocalFolder.Path, "hinos.sqlite");
        SQLiteAsyncConnection con = new SQLiteAsyncConnection(local, SQLiteOpenFlags.Create | SQLiteOpenFlags.ReadWrite);
        await con.CreateTableAsync<hinos>();

        variaveis variavel = new variaveis();
        for (var i = 0; i < 221; i++)
        {
            var hino = new hinos() { numHino = variavel.numeroHinos[i], favHino = variavel.favHinos, nomeHino = variavel.nomeHinos[i], catHino = variavel.categoriaHinos[i], letraHino = variavel.letraHinos[i] };
            await con.InsertAsync(hino);

        }

    }

In this way, i am losing performance a lot ,so, How can I use other way to fix it.

Aucun commentaire:

Enregistrer un commentaire