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
Why do we need ado.net?
What is the difference between statement and preparedstatement interface?
What is different between sqlcommand object and command behavior object?
What is dao and ado?
What is the use of SqlCommandBuilder?
Explain which name space is used to get assembly details?
What is microsoft ado.net?
What is the default Timeout for SqlCommand.CommandTimeout property?
What are datareaders?
What are the Features and disadvantages of dataset
How to add an aggregate column?
What is ole used for?
Is ado.net an orm?
What two types of data providers does ADO.NET supply? What determines which one you should use?
What is difference between connected and disconnected architecture in ado.net?