Loading

Performance Issue with DataTable.

Dilip Kumar

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?

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Manas Mohapatra9y ago
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).