A user is currently allowed to set a sorting order on 8 different columns.
When a user applies a sort order on 1 column it takes up to 16 seconds for the application to show the sorted set. And Excel style filtering can't handle it all. Trying to place a filter via the Excel style filtering on a column header takes so long that I have to force close the application via the Windows Task Manager.
What's the best practice for handling these performance issues? I could create a index for every possible sort column (8 in total). But what if a user wants to sort on multiple columns at once? Then the created index no longer covers the query.
Best answer by Jasper