|
Some numbers. On my 20,000 book test library
start with sorted by title
Without the change:
- search for 'foo'. Finds 48 records. Time: approx 2.5 seconds
- sort on author: Approx 1.5 seconds
- clear the search: Time: instant
With the change:
- search for 'foo'. Approx 2.5 seconds
- sort on author: instant
- clear the search: Approx 1.5 seconds
These numbers are consistent with the underlying changes. One pays for a complete sort when the search is cleared.
@kiwidude: there is one sort, no appreciable lag for multiple columns. The GUI knows to use the DB's multi-column sort in this case.
|