Performance Issue with DataTable.

Question

I have lakhs of records in my database table. I have used DataAdapter to fill the data into the dataset. And based on some conditions I am saving those records into multiple DataTables. Now I want to process one of the DataTable But it is taking a lot of time to process. Is there any solution to process faster?

Manas Mohapatra · Answer

Generally it will slow when you are performing operation on 1 lakh records. In order to avoid problem either use paging or fetch required no of records. Let create an StoredProcedure and return multiple result sets. And assign them directly to List or DataTable(Better to use List if Datatable doesn't give any advantage).