Hi, Mike
Yes, I've tried limiting the results to 500. Actually, the stats I listed originally (something like 30 seconds) was with this limit in place. Without the limit, the 12,000 records takes some 2+ minutes!
You're right, though: users should not have to view such a large selection. This could be the key in this type of task. Unfortunately, I have other apps that users do want to scroll through all records (no matter how large), I suppose to get a feel for trends or such. So I may have to approach this problem later, anyway.
Mark
>The Advanced Options menu in the View Designer has an area that allows you to limit the size of your result set to a specific number of MAX RECORDS. You could create a parameterized remote view as show earlier then check _TALLY for the number of matches. If this equalled your predetermined MAX RECORDS, alert the user to be more specific and reissue the query.
>
>If your users are at all like mine, I am sure they would not want to scroll through a list of over a hundred or so names.
"It hit an iceberg and it sank. Get over it."
Robert Ballard, dicoverer of the Titanic wreckage.