Retrieve bulk of data from Sqlite in WP8
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 ?