I have a huge datareader from sql server to insert into a sqlite database. I'm using xamarin C#, my problem is that the datareader is very big and the foreach item in datareader is very slow.
I have 131 fields in this table and is not feasible to use the index, I mean that I know that if I use the index instead of the name of the field I got better speed, but this is not feasible because fields can change.
Is there a method to deal with the datareader as a whole and accelerate the inserts?
Aucun commentaire:
Enregistrer un commentaire