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 is two way data binding android?

1031


Which components of a data provider is used to retrieve, insert, delete, or modify data in a data source?

1180


Define different execute methods of ADO.NET command object ?

1169


Give an example that shows how to execute a stored procedure in ado.net?

1114


What is the meaning of object pooling?

1312


The answers which posted above is not satisfied my requirement? Can some one post teh exact answer? Thanx

2082


Explain the difference between data reader and data set?

969


What are the core objects of ADO.NET?

1089


Is datareader faster than datatable?

1017


How would you connect to a database by using .NET?

991


What is ado and dao?

1007


What is acid in ado.net?

1105


What is disconnected architecture in ado.net?

1044


How do you find the count of records in a dataset?

1023


Name which operations can you not perform on an ado.net dataset?

1038