Thread: Indexeses
View Single Post
Old 09-07-2008, 01:47 PM   #22
pilotbob
Grand Sorcerer
pilotbob ought to be getting tired of karma fortunes by now.pilotbob ought to be getting tired of karma fortunes by now.pilotbob ought to be getting tired of karma fortunes by now.pilotbob ought to be getting tired of karma fortunes by now.pilotbob ought to be getting tired of karma fortunes by now.pilotbob ought to be getting tired of karma fortunes by now.pilotbob ought to be getting tired of karma fortunes by now.pilotbob ought to be getting tired of karma fortunes by now.pilotbob ought to be getting tired of karma fortunes by now.pilotbob ought to be getting tired of karma fortunes by now.pilotbob ought to be getting tired of karma fortunes by now.
 
pilotbob's Avatar
 
Posts: 19,618
Karma: 11337367
Join Date: Jan 2007
Location: Tampa, FL USA
Device: Kindle Touch
Quote:
Originally Posted by kovidgoyal View Post
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
pilotbob is offline   Reply With Quote