I am facing slowness in using DataAdapter.Fill method in order to populate DataSet with data. The base table has around 10000 records. But I am not getting all of the records from the table. I am just getting only one record from the table by specifying WHERE condition in SELECT statement.
How can I improve the performace of DataAdapter.Fill method? Or Is there any other way I can fill up datasets with data retrieved from the database with High performance.