We are building an application which may have thousands item in the table list. As we decide each page only show 25 item, so there maybe 10-100 pages.
We allow the user click the table column header to sort items, for example, sort by id or sort by email.
We have hot debate for two options:
Sort only apply to items in current page. That's means we only sort 25 item when user click once.
Sort the whole list.
So which options is more reasonable?