如何执行此 [英] how can Perform this

问题描述

朋友们！

一个面试中有人问过我一个问题.

问:如果我的gridview页面每页显示100条记录，而有10页，则意味着总记录为1000，如何处理?


这是任何人都可以回答的问题.

Hi Friends!

I have been asked by a question in one interview.

Q:If my gridview page is displaying 100 records /page and it have 10 pages means the total records are 1000 ,how can you handle it?


This is the question can any one give answer please.

推荐答案

看看这个:

有效地分页处理大量数据 [ ^ ]

look at this :

Efficiently Paging Through Large Amounts of Data [^]

这种方式: ^ ]

然后主要关注访问者的问题是Gridview分页的性能问题.因为如果您使用的是Gridview分页，那么就内存而言这将是非常昂贵的.因为所有记录都保存在内存中，可能是性能问题.如此简单的答案是，在这种情况下，我们将使用
-始终使用Sql Reader绑定gridview
-在Sql服务器端实现分页.不要使用Gridview分页.

Then main concern of the interviewer is performance issue with Gridview paging. Because if you are using Gridview paging then it will be very costly in terms of memory. Because all records save in memory and can be performance issue. So simple answer is, in this case we will use
- Always use Sql Reader to bind the gridview
- Implement paging on Sql server side. Do not use Gridview paging.

这篇关于如何执行此的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！