当我们在网格中填充5万条记录时，Rad网格很慢。（WPF） [英] Rad grid is slow when we populate 50 thousand record in grid .(WPF)

问题描述

用于在rad网格中绑定图像的任何备用技术。



我尝试过：



如何绑定国家/地区标志取决于国家/地区名称。我正在使用var二进制文件保存国家/地区图像并检索数据但是当我们一次填充5万条记录时网格很慢。所以我想要任何备用技术。我正在检索数据表中的数据并将其分配给网格视图。

Any alternate Technic to bind image in rad grid.

What I have tried:

how to bind country flag Depending upon the country name.i am saving country image in var binary and retrieving data but when we populate 50 thousand record in one time then grid is slow.so i want any alternate Technic. i am retrieving data in data table and assign it to grid view.

推荐答案

简单解决方案：不要尝试使用50,000行填充网格。



您认为这对用户有用吗？他需要多长时间才能找到他真正感兴趣的数据？

这不仅是对系统资源的一次重大浪费 - 而且速度慢 - 它几乎是为了挫败和惹恼它用户。因此，请对其进行分页，过滤，搜索：但不要尝试向用户显示超过一百行。如果你这样做，人们很快就会讨厌你的软件并且不会使用它。

Simple solution: don't try to populate a grid with 50,000 rows.

How useful to a user do you think that is going to be? How long is it going to take him to find the data he is actually interested in?
Not only is it a major waste of system resources - and slow as heck - it's almost designed to frustrate and annoy the user. So page it, filter it, search it: but never try to present more than about a hundred rows to the user. If you do, people will very quickly come to hate your software and won't use it.

关于国家图像可以存储为精灵图像，链接：标记精灵 [ ^ ]然后使用css来确定应该加载哪个标志...你可以找到很多这样的例子。



我是不熟悉RAD控件但在任何类型的网格中加载50K记录都会导致性能问题。您应该将数据分页以一次加载前10或100条记录。也许RAD网格提供过滤和排序功能，这些功能可以很好地进行分页。



用户会发现在50K记录中搜索是一项具有挑战性的任务，而且大多数情况下，大多数时候只会使用少量记录。想想搜索引擎......你永远不会看到匹配的百万条记录，因为你可能只需要查看前10条来找到你的答案。

Hi, about the country images may be stored as a sprite image, link: Flag Sprites[^] and then use css to determine which flag should be loaded...you can find many examples of this.

I'm not familiar with RAD controls but loading 50K records in any type of grid will always lead to performance issues. You should page the data to load ex 10 or 100 records at a time. Also probably RAD grid offers filtering and sorting features where these work good with paging.

The user will find searching through 50K records a challenging task and most often the majority of the time only a few records will be used. Think of search engines...you never get to see the million records matched because probably you only need to look at top 10 to find your answers.

这篇关于当我们在网格中填充5万条记录时，Rad网格很慢。（WPF）的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！