Rad grid is slow when we populate 50 thousand record in grid .(WPF)

Question

0.00/5 (No votes)

See more:

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.

Posted 24-Dec-16 22:46pm

Member 12185819

Updated 24-Dec-16 23:26pm

Add a Solution

Comments

Kornfeld Eliyahu Peter 25-Dec-16 4:50am

The real question is why to populate 50,000 records to a grid? Where is the super-human can handle that much info in one run?

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2016-12-24T23:19:00

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.

P_Z · Answer 2 · 2016-12-24T23:26:00

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.

Rad grid is slow when we populate 50 thousand record in grid .(WPF)

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0