如何从sql server检索快速数据到asp.net页面

本文介绍了如何从sql server检索快速数据到asp页面的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

如何从sql server检索快速数据到asp页面 有各种方式像水晶报告网格视图来显示数据。 但要显示和从sqlserver检索快速数据到asp页面.. 显示快速数据的方式.. 请建议我.. thnaks ..

how to retrieve fast data from sql server to asp page there are various way like crystal reports grid view to display the data. but to display and retrieve fast data from sqlserver to asp page.. way to display fast data.. please suggest me.. thnaks..

推荐答案

一个数据。其中包含超过500000个名称和地址ID还有更多..花时间来获取和显示数据 你期待什么？ 半个百万个名称和地址，加上更多将是什么，每行100或200个字符？ 这是您要传输的100,000,000字节数据，没有任何必要的HTML围绕它...当然它会很慢！ 在生产中，情况会更糟，因为当两个或两个以上的人同时开始这样做时，各种服务器上的带宽lved会非常，非常，快速地被吃掉。 更糟糕的是，它完全没用。你认为你的一个用户需要多长时间才能找到他们需要在50万行中找到的路线？几个小时？更多？ 页面它。 提供搜索和过滤器，以帮助用户找到他所需要的 - 并且从不显示超过25或所以路线一次！ 或者你的用户会去别的地方而且他们不会回来...... "A data.Which contain more than 500000 name and address id and much more..its taking time to fetch and display the data" What did you expect? Half a million names and addresses, plus "much more" is going to be what, 100 or 200 characters per row? That's 100,000,000 bytes of data you are transferring, without any of the necessary HTML around it... Of course it's going to be slow! And in production, it'll be even worse, because as two or more people start doing it at the same time, the bandwidth on the various servers involved is going to get eaten very, very, quickly. And worse, it's completely useless. How long do you think it's going to take one of your users to find the one route they need to look at somewhere in half a million rows? Couple of hours? More? Page it. Provide searches, and filters so help the user find what he needs - and never show more than 25 or so routes at a time! Or your users will go elsewhere and they won't come back...