locked
Bulk data retrieve from sqlite in WP8 RRS feed

  • General discussion

  • Hi,
    I have to retrieve bulk of data from the database.As their is around 40K data,So, it is taking lot of time for execution.My Code:-
    List<string> finalList=new List<string>(); 
    using (var dbase = new SQLiteConnection(Globals.DBasePath, true))
    {
            dbase.RunInTransaction(() =>
            {
                    var list= dbase.Query<Vehicles>("select * from Vehicles");
                    foreach (Vehicles veh in list)
                    {
                            string str = veh.vehName;
                            finalList.Add(str);
                    }
            });
        dbase.Close();
    }
    It takes arount 8-10 secs to load 30-40K data.Is their any way to reduce this time ? 
    Monday, March 16, 2015 10:05 AM