Hi Sam,
I improved the performance by creating an Excel spreadsheet containing just the records that might be of interest in the linked View (the result of the Job2Lookup Filter) which contains just 56,000 or so transactions. Then I created a View to the XLSX rather than the GL transactions. The transactions display in a couple of seconds, even with the 32-bit version of GV.
You could create a batch file to refresh the XLSX overnight or at the click of a mouse button and then load the workspace.
_________________________
Andrew Bates