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
What is two way data binding android?
Which components of a data provider is used to retrieve, insert, delete, or modify data in a data source?
Define different execute methods of ADO.NET command object ?
Give an example that shows how to execute a stored procedure in ado.net?
What is the meaning of object pooling?
The answers which posted above is not satisfied my requirement? Can some one post teh exact answer? Thanx
Explain the difference between data reader and data set?
What are the core objects of ADO.NET?
Is datareader faster than datatable?
How would you connect to a database by using .NET?
What is ado and dao?
What is acid in ado.net?
What is disconnected architecture in ado.net?
How do you find the count of records in a dataset?
Name which operations can you not perform on an ado.net dataset?