Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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 ado.net in vb net?

874


What is the difference between sqldatareader and sqldataadapter?

915


What does adodb stand for?

973


What is isolation?

967


Does executenonquery return a value?

883


Explain what are the steps to connect to a database?

927


What are the rules to implement connection pooling?

1001


How does entity framework work?

854


Explain the difference between an ado.net dataset and an ado recordset?

994


What is ado.net code?

887


Which is better entity framework or ado.net?

969


How to pass values into a datatable?

1056


Explain how to copy the contents from one table to another table and how to delete the source table in ado.net?

819


What is the difference between ado.net and oledb?

906


Which one of the following objects is a high-level abstraction of the connection and command objects in ado.net?

1014