mardi 1 septembre 2015

huge datareader to insert in sqlite ( XAMARIN IOS)?

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