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
- 10299 Views
- I also Faced
- E-Mail Answers
Answer Posted / anna
we have to use datareader.
because it is more faster & efficient than dataset.
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
If we are not returning any records from the database, which method is to be used?
What is serialization and de-serialization in .net? How can we serialize the dataset object?
What is ado asp?
Why is it important to close an ado.net application?
What is dataset and datatable in ado.net?
Define table relations?
What is Dataset Object?
What are the different ado.net namespaces are available in .net?
Explain the basic use of "dataview" and explain its methods.
Explain the advantage of ADO.Net?
how Sequence to connect and retrieve data from database using dataset?
How many major types of connection objects in ADO.NET?
What is data relation?
Describe datareader object of ado.net with example.
Explain how to copy the contents from one table to another table and how to delete the source table in ado.net?
