ADO.NET generates indexes on the primary key(s). So, if you have to search a datatable for records based on some primary key value, use
DataTable.Rows.Find() instead of
DataTable.Select(). The
Find method will use the index to find the row. This turns out to be faster because of the presence of the index.