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 / ashok

This can be done using following ways. Mainly its base on
multitreading environment.

1. Declare delegate (I am using Async delegate)
2. Start a new thread which will gets a data information in
collection or we can fill the dataset.
3. In main thread you can keep polling to the datafill
thread whether the operation is complete or not.
4. with IAsyncResult we can find whether the thread which we
started earlier has completed the assigned task or not.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the usages of the command object in ado.net?

1024


What is the meaning of executenonquery?

1066


Explain ado.net features?

1051


What are the different layers of ado.net?

1083


What is different between sqlcommand object and command behavior object?

1060


What are the advantages of oledb compared with other classes?

2795


How to identify the updated rows in a dataset?

1018


What are the objects of ado.net?

1073


differance between ADO vs ADO.Net?

1062


What is the role of clr?

950


How can you add or remove rows from the datatable object of dataset?

1025


What is microsoft ole db provider for sql server?

933


How to add an aggregate column?

1018


What is the full form of ado.net?

989


What is shadow copy?

985