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?

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


Please Help Members By Posting Answers For Below Questions

What is data relation?

502


What is ado.net code?

523


What are the important features of ado.net 2.0?

594


What is the difference between dataset and datatable?

489


Which object holds only data and does not interact with data source?

501






What is shadow copy?

581


What is sqldatasource?

523


What is row state?

528


What is ado.net object model?

514


How does entity framework work?

468


What property must be set and what method must be called in your code to bind the data from some data source to the Repeater control?

561


Does ado.net use odbc?

527


What is ado object model?

519


Is it possible to load multiple tables in a Dataset?

530


What is a control toolbox?

505