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
- 10298 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
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?
What are the drawbacks of using ado.net?
Why is stored procedure used in ado.net?
What is DataRowCollection?
What is difference between ado.net and asp net?
What is a datagridview?
What is variable view?
What are the parameters that control most of connection pooling behaviors?
What is shadow copy?
How we can provide data to ado.net?
What is Dataset Object?
What is sqldatasource?
What is difference between Dataview and Datatable?
What is meant by ‘transaction’ in a database and what are the ‘properties of transaction’?
What is aggregating data ?
