As far as loading all records, that does not seem to make sense. I start the query on the table with 4000 records, and a fair number are loaded. I can tell, since when I scroll down, I can see the delay while the engine pages in the next batch of record. However, in either case, whether I say unlimited or give it a # of records to read, If I enter the filter of "bruce" and assume there are 2 matches in the database, they are both displayed. So, my filter will just return the 2 matches in either case.
Bruce