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?
Answers were Sorted based on User's Feedback
Answer / vijay
we have to use a dataset because on using datareader
forward only paging can be achieved. Suppose if you are at
1000 page and you want to go back to 999th page, if you use
datareader it cannot be achieved, since it does not support
backward navigation.
Dataset supports forward and backward navigation
Is This Answer Correct ? | 7 Yes | 0 No |
Answer / anna
we have to use datareader.
because it is more faster & efficient than dataset.
Is This Answer Correct ? | 3 Yes | 1 No |
Answer / 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 |
Answer / renjith t n
You need to look at ROW_NUMBER() to do this effectively.
Temp tables, cursors are to costly.
CREATE PROCEDURE myProc
@StartIndex INT
@MaxRecords INT
AS
SET @StartIndex = @StartIndex + 1
SELECT
first_name,
last_name,
middle_init
FROM
(SELECT
first_name,
last_name,
middle_init
ROW_NUMBER() OVER(ORDER BY last_name)
AS rownum
FROM
Users)
AS Users
WHERE
rownum between @StartIndex and (@StartIndex + @MaxRecords) -
1
Then we can use Dataset for best performance..
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / vijay
answer # 3 is really appreciate me thanks for giving
correct answer. i ve tested with sqldatasource with
gridview and change datasourcemode to datareader giving
error u must use dataset..
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / kumar vaibhav
Create a stored procedure with parameter page size and current page index.Get the lower bound and upper bound of the page by using following formula
Lower bound=Pagesize*PageIndex+1
Upper Bound=lowerbound+pagesize
call this Stored Procedure on every paging event of gridview.
Is This Answer Correct ? | 0 Yes | 1 No |
Answer / nitin
DataReader is better Choice for this type of Task becoz
DataReader is Read only, forward only access to data in
Connected Environment.
Is This Answer Correct ? | 0 Yes | 3 No |
What are disadvantages of microsoft-provided data provider classes in ado.net?
How to copy the contents from one table to another table and how to delete the source table in ado.net?
What is the purpose of using adodb?
What provider ADO.net use by default ?
5 Answers Accenture, BirlaSoft, Wipro,
Difference between OLEDB Provider and SqlClient ?
Can we create Synonymns in MS Acess,My Sql Server,Sql Server? But iam we can create in oracle!
What are basic methods of dataadapter?
How do you filter the data in datagrid?
2 Answers Apps Lab, Choice Solutions,
How can I retrieve two tables of data at a time by using data reader? Data reader read and forward only, how is it possible to get 2 tables of data at a time?
What are the different row versions available in table?
Does entity framework use ado.net?
What do you know about ADO.NET's objects and methods?