if a master form has detail forms attached, don't load the data on the listview page unless the tab is selected then get the data.
Example:
have a master form
employees (11,000 records)
|
| (detail forms)
____ notes
|____ documents
|____ cases
|____ job profiles
paging takes over 7 seconds to load a page showing 10 records/page and the records only have test data currently a couple of records at max for some of the detail forms
I've also customized the view to display the above 4 sub-forms as well on the view table... it appears < 1 second with 3 note and 1 doc record