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?
- 7 Answers
- 10328 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Explain how to bind the controls(best practice) comboboxes to the data in the dataset?
What is ado rdo dao in visual basic?
What is adodb dll?
What is oledb connection?
What is an ADO.Net?
Why is ADO.NET serialization slower than ADO ?
What is the default provider in ado.net?
Data reader read and forward only, how is it possible to get 2 tables of data at a time?
What is serialization and de-serialization in .net? How can we serialize the dataset object?
What are the different row versions available in table?
What is the namespaces being used to access oracle database?
What are the advantages of oledb compared with other classes?
What is a sqldataadapter?
Which keyword is used to accept variable number of parameters?
Define bubbled event?
