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 are the benefits of ADO.NET?

1172


What you mean by filtering of data?

1016


What is ado.net object model?

1029


Can you explain how to enable and disable connection pooling?

1009


What is the maximum pool size in ado.net connection string?

993


How do you merge 2 datasets into the third dataset in a simple manner?

1059


What is executequery?

992


Which is faster sqldataadapter and sqldatareader?

980


What are the steps to connect to a database?

1071


What are the namespaces used in ado.net for data access?

1028


What is difference between executenonquery and executequery?

1024


What are the ado.net components?

1070


What is ado.net components?

1003


What is the difference between oledb sql server and oledbdotnet provider?

1059


What is data access pattern?

1003