If a table contains 20000 records . In a page at each time
100 records to be displayed. What are the steps u will take
to improve performance? will you use dataset or datareader?
- 7 Answers
- 10294 Views
- I also Faced
- E-Mail Answers
Answer Posted / nitin
DataReader is better Choice for this type of Task becoz
DataReader is Read only, forward only access to data in
Connected Environment.
| Is This Answer Correct ? | 0 Yes | 3 No |
Post New Answer View All Answers
What is data view and variable view?
What is a serialized object?
What is the difference between Optimistic and Pessimistic locking?
What is the hierarchy of data in databases?
Why edit is not possible in repeater?
Define partial class?
Is ado.net dead?
Describe the disconnected architecture of ADO.NET’s data access model.
What is datatable in ado.net?
What is the provider being used to access oracle database?
What two types of data providers does ADO.NET supply? What determines which one you should use?
Explain the two fundamental objects in ado.net?
What is ole used for?
What are ado.net objects?
How can we save all data from dataset?
