>>Hi everybody,
>>
>>The queue assignment process usually takes ~ 1 min., except for UNASSIGNED BILLER, where it takes ~10 minutes.
>>
>>Now, I speculated, that the reason is that we have only small amount of UNASSIGNED BILLER records comparing with other types.
>>
>>Can you help me to justify this theory in "scientific" form or do you think I should try to find the bottleneck using Coverage Profiler instead of guessing?
>
>The grid itself demonstrates problems with large tables and filters that show few records. Use of non-rushmore-optimizable commands with rushmore optimizable filters also have such problems.
In this particular case we're talking about SQL that retrieves small amount of records using indexes. There is no GUI involved to contribute to the problem.
If it's not broken, fix it until it is.
My Blog