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
Which one of the following objects is a high-level abstraction of the connection and command objects in ado.net?
Why is ADO.NET serialization slower than ADO ?
What is ole word?
Define connection string?
What is difference between datagridview and datagrid control in winforms?
How can you add or remove rows from the datatable object of dataset?
What providers does Ado.net uses?
Explain the difference between sqlcommand object and command behavior object?
What are different layers of ADO.Net?
What is ado or jdbc?
If a table contains 20000 records . In a page at each time 100 records to be displayed what are the steps you will take to improve performance? Will you use dataset or datareader?
Is datareader faster than datatable?
Define data access layer?
What are the advantage of ado.net?
Explain the difference in record set and dataset?