QuickStart Development

[Kenneth Brody]

On 6/7/2016 11:46 AM, Richard Kreiss via Filepro-list wrote:
[...]
> As I indicated in a previous post, one client has a report that process
> just over 4,700 records.  The issue here is that each record can
> reference between 30 and 50,000 plus records using a lookup next to the
> order detail file.  The output is only 1 line for a csv file but when run
> directly on their old server, this took over 6 hours.  They are replacing
> the old server and I ran a test with this report and it runs in under 3
> hours.  Since this report is run at least twice a week, that is a big
> boost in performance.
[...]

Is it really necessary for each record to look up to as many as 50,000 
records?  Is there no way to have an index help this?

-- 
Kenneth Brody