I am using the ultrawingird control version 9.2 latest SR, on a winform.
It has 19 columns, of which about 10 are visible.
It is databound to a datable.
I have a user with about 42000 rows.
They are finding latency when using the filters. so the header row allows them to start typing a name, and there is a 1 to 2 second lag between characters typed in.
The basic filter settings are set:
Allow=allow
action=hide filtered out rows
filter range - all rows in band
filterUItype = filter row
filter operator default value is start with
any ideas on how to speed up performance?
You could set the FilterEvaluationTrigger property on the Override to something like OnEnterKey. That way the filters would not be evaluated until the user presses the Enter key and there wouldn't be any delay while typing.
Hi Daryl,
Did Mike's solution work for you ? Let me know if you have further questions regarding this. Thanks.
Mike solution didn't work for me..
I was loading 42000 rows in the grid, on my machine I did not see much slow down, on others there were.
However, I releazed I did not not them all, actuallyonly needed about 3500 rows...
Are you saying it worked on your machine and on others it didnt ? If that is the case what's the difference between your machine and theirs ? What is the configuration difference like OS, RAM, hard disk, etc ? Sometimes with lesser memory the performance can take a hit.
It was able to load so many records into the grid on my machine becuase of the computing power, cpu, memory etc..
On others with lowered cpu and memory it took a little longer.
Well that explains it then. Thanks for the update.