Quote:
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?
BOb