Sweta Sinha

Sweta Sinha

  • NA
  • 51
  • 40.5k

Retrieve bulk of data from Sqlite in WP8

Mar 16 2015 5:38 AM
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 ?