It's me, performance monster again. I notice when sorting certain fields your control is very fast but while sorting others its quite quite slow. Dates and Numbers all seems to be fine, and text that does not repeat seems to be fine. But when I sort fields that often have the same data in multiple rows it seems to drastically slow down.
I'm currently sorting 501 rows in less than a second for numbers, dates, and non-repeating text (things like a name). But when I sort on a string field that has data that is likely to repeat (say category types) it can take upwards of 30 seconds. That's a pretty big contrast, any ideas why this might be happening?
I can’t really create a project that demonstrates this, but I think I can explain why the one non-number/date column is being sorted more quickly than the others. It is already sorted in the initial data grid so there is less data to re-order, which would make it return faster.
I’m already getting users complaints about the sorting speed on non-number/date fields. Would it be possible to look into enhancing the performance of this? Do you know what type of sort algorithm is being done on this? Sorting a dataset of this data takes a fraction of the time in comparison to letting the control do it.
When sorting with text field, the control tries to parse the text if they are a number or datetime string. So it will be slow. We will think it over and improve the sorting performance soon.
Has there been any progress on this issue? I am experiencing the same performance problems when sorting columns containing text. This will be a big issue for my users if I go live with this control.