We are using a Workspace with three Views. Problem: there is a ton of records, as follows:
1. Customers: (44,000 records) <linked to O/E Header by Cust#>
2. O/E History-Header (250,000 records) <linked to O/E Details by Doc#>
3. O/E History-Details (1,600,000 records)

We find a Customer by Name or Tel #. This works quick.
Next, we double-click to view the Transactions from O/E Header - this takes a while.
Finally, to view the Details, we double-click the Doc# to view the Details, but this takes way too long.

The client is using GV with Gridview Server, but it still takes too long.

Any suggestions?