Bulk data retrieve from sqlite in WP8

• General discussion

• 

  

  0

  Sign in to vote

  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