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
using (var dbase = new SQLiteConnection(Globals.DBasePath, true))
{
dbase.RunInTransaction(() =>
{
var list= dbase.Query
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 ?
Replies
Know the answer? Post it — somebody with the same question will find it here.