Rationale: "Our clients like to be able to see everything." :)

I have tried to get several major design deficiencies out of this app
and the client has refused all suggestions. Ergo, not my problem any
more.

Thanks for the sympathy. :)

Allen.

In article <5.1.0.14.2.20021016114329.055cad40@...>,
helebor@... says...

> At 02:03 AM 14-10-02 -0700, you wrote:
> Your real problem here appears to be your customer's requirement to open
> the application with an ordered set of 90,000 records. What is the
> rationale behind this, when
>
> select <all 90,000 records> takes a minute and a quarter, whereas
>
> select <a much smaller set>
> where <parameterised very steep criteria>
> will be sub-second?
>
> IOW, what you need to convince him is that, as long as your app provides
> selectors for keys, he can retrieve any record he wants, faster than a
> speeding bullet...well, at least quantumly faster than waiting for the
> whole set and then scrolling through 90,000 records...
>
> You have my sympathy, if that helps at all...
>
> Helen