Originally Posted by kovidgoyal
Actually it's the sort/filter operations that become slow, no the UI. Paging wont help that, since for the results to be correct, a sort/filter has to run through the full database.
Ah... what db are you using? It seems slow in that case, cause 10k records isn't alot. Do you have the data indexed by title/author/tags so that the db doesn't have to do a table scan and it can do an index scan?
Do you create tag index tables or just sort through a tags field in every record to find stuff?