Subject Re: [ib-support] Adding index does nothing to select disctinct
Author Raymond Kennington
Mark Patterson wrote:
>
...
> Hmmm... yes, if the user enters the date range, and there is an index on date
> range, before they can choose a job_number, the list could be made available
> when they start entering the job_number. But if if still takes 8 seconds,
> because they want a report over the last 2 years...

I provide my clients (from whence the users get the same info) with written documentation
stating that data entry is fast and reports take as long as it takes; usually there is a
progress bar as an indicator.

I consider 8 seconds nothing for a 2-year report, and my users are thankful for the
report.

Raymond Kennington