I have built a site for a local auction house. Each auction has around 2000 lots, which are held in the table auction_items with references to another 3 tables.
I am trying to work out the best way of displaying all of the items for a given auction, whilst optimising performance.
Each site visitor typically wants to see all of the items in the list and wants the option to "show all" items in a single view.
From past hits we estimate approximately 700 hits a day, most of which will want to view the list of items.
Are there performance benefits to be gained from displaying the results 20 to a page and having the users scroll through? Rather than loading the full list once per user?
From a usability point of view they would be better off with one list that they can see "at a glance" and print.
I look forward to your comments and suggestions.