Daniel Wood suggested a rather interesting idea on how to make HyperList and MasterDetail even faster. In short he suggested using FileMaker’s built in record ID instead of the primary key. Its really rather brilliant and turns out to work quite well. You can read his full explanation over at Modular FileMaker. Its in the comments for HyperList.
I thought I would give the idea a try with a very large record set to see if it speed things up. Well it did. Here is the video to prove it. Enjoy