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?